We are the Outsourced Analytics Team for Small and Midsize Companies

You need your data in one place so that your team doesn’t create islands of spreadsheets.

We take care of the technical stuff!

WHO HIRES US

Chief Financial Officers

CFOs hire us because they want good clean data to drive decision making across the company.

We bring efficiency and velocity to:

  • Financial and operational reporting
  • Month-end closing (with our General Ledger visualizer and interactive reports)
  • Budgeting, forecasting and planning (using our XLhub Excel add-in)

We work in the background to pull data from systems, add it to the data warehouse, and build dashboards and visualizations.

And we also help ensure user adoption of new dashboards and analytical capabilities.

 

IT Directors

IT Directors want a vendor who is deep on technology, competitive on price and based in the U.S.

Data Analytics is our specialty. We build point-to-point solutions, pull and push data between APIs, and build data-centric technology solutions.

We understand you have to protect your data. We will follow you security guidelines and comply with your IT standards.

OUR CAPABILITIES

Analytics Strategy & Adoption

Analytics Strategy

Analytics Business Case

Visioning, Buy-In and Adoption

 

Software Development
ETL

API connectors

Custom Applications

Excel to SQL Integration

Dashboards
Custom SQL

Power BI Development

Tableau Development

Klipfolio Development

Data Warehouses

Cloud Data Warehouse

Design and Development

Data Warehouse Operation

 

OUR PARTNERSHIPS

Sample Projects

Here are examples of a few solutions we have designed, developed and deployed

Salesforce Snapshot Reporting

A company that uses Salesforce was noticing that their sales forecast changed significantly from month to month. They needed a way to trace the changes for better accountability and planning.

We solved the mystery using Salesforce’s reporting snapshot feature and Tableau. Now, any sales rep who replaces a forecast quantity for an opportunity knows that the prior values will be preserved for comparison.

NetSuite Data Warehouse

There’s a gold mine of data in NetSuite, but the analytics aren’t so great.

We solved that by utilizing the NetSuite connector and pulling data into the data warehouse.

Floor Plan Visualization

A leasing team for a mall operator wanted to show floor plans by store category and traffic.

We took floor plan coordinates from the architect firm and overlaid them with the lease data from MRI. Now the leasing team can see a birds-eye-view the stores shaded by Sales PSF, Rent PSF and more.

Rent Manager Data Warehouse

Rent Manager has an excellent API that allows access to lots of reports.

We built a Data Warehouse by writing API connectors and building a data model optimized for analytics. See https://rentviewer.com for more information.

Entrata Dashboards

A multifamily operator was tired of having to manually  update their metrics scorecard each week from Entrata.

We connected their scorecard to the Entrata API and scheduled automatic refreshes. Now they can look at P&L data, resident retention, box score and more metrics without exporting to Excel.

Yardi Power BI Dashboard

A multifamily operator wanted to visualize metrics from Yardi but not have to pay for expensive Yardi Business Intelligence add-ons.

We built a simple solution with Power BI and Excel exports that refreshes daily. The latest metrics are visible on large TVs in the corporate office.

General Ledger Analytics

A CFO wanted to take control of expenses and see where every dollar was going.

We connected Tableau to the General Ledger data (via an API connector). Now the customer can visualize where money is being spent, see trends, find outliers and wrongly coded expenses. Learn more about the Expense Visualizer.

Journal Entry Posting

A company wanted to post transactions from a Point of Sale system into the General Ledger. The volume was hundreds of transactions per day.  

We automated the posting of journal entries by writing an API that pulls a CSV file from a sFTP site, It converts the CSV to JSON, and makes post calls to the accounting system API to post journal entries. Includes good logging and error handling as well.

Budgeting & Forecasting

Most of our customers want to avoid emailing Excel files back and forth and losing track of versions.

We built XLhub, an Excel addin, to streamline the planning, budgeting and forecasting processes for many companies. XLhub enables writing data from Excel to a SQL database.

Sales & Operations Planning

A customer wanted to compare product availability from their factories and demand from customers. The information sat in many different systems.

We built a Sales & Operations Planning system that allows comparison of the production forecast and sales forecast, and highlights gaps and oversupply situations. Planners can make fast decisions to keep the factories humming and customers getting their shipments on time.

WHY METRIC-X

We specialize in moving, organizing and visualizing data.

We offer full lifecycle capabilities: Visioning, Enterprise Architecture, Software Development, Go Live and Operations.

We are based in the U.S. and are easy to work with.

CUSTOMERS

READY TO DISCUSS YOUR PROJECT?

Call 248-601-6400

or

Subscribe for updates

We would love to share stories about new projects and how we solved data challenges. No spamming.