<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1615816415302394&amp;ev=PageView&amp;noscript=1">
Contact us

Meritum Eliminates Data Silos for a Complete Portfolio Perspective

"Unlocking our data has materially improved our operational and financial reporting which allows for efficient and accurate analysis, insight, decision making and execution. The entire organization from our employees in the field to our executive team are now able to see daily, weekly, monthly, and annual data and analysis that saves countless hours and unites the organization with a single source of data truth."
Ben Carl
CFA, VP of Finance
Client:
Meritum Energy Holdings
Industry:
Distribution, Logistics, & Warehousing
Business need:
Data Analytics & Visualization
Topic:
Data Silo Elimination
Services:
Data Strategy, Data Architecture, Data Visualization
Platform:
AWS, Matillion, Snowflake, Tableau

Scaling Through Acquisitions Required a New Data Foundation

The business had an M&A model that purchased individual fuel delivery companies. Each acquisition brought its own systems and data. As the company grew, getting timely, accurate, and repeatable data into the hands of employees so they could make informed decisions was out of reach with the current process.

Disparate Systems Created Manual, Time-Consuming Reporting

Each acquisition brought its own systems and data, meaning analyses on financial performance, customer gain and loss, and employee efficiency metrics had to be wrangled manually from disparate sources each month. The effort by one financial analyst was 80+ hours a month, and as the company grew these analyses became unmanageable and delayed.

A Cloud-Based Data Strategy Built for Growth

SVA partnered with this company to develop a data strategy that captured and consolidated reporting requirements across the business. By establishing the end goal up front, stakeholder expectations were aligned, and we could establish a prioritized roadmap for the build.

We developed a cloud-based, fit-for-purpose data pipeline using Matillion, Snowflake, and AWS that captures historic and current data. These data are visualized in Tableau and provide actionable information from the field up to the executive level.

Faster Insights, Better Decisions, and Measurable Time Savings

  • The executive team has daily financial projections at the consolidated and individual location level to rapidly help manage growth.
  • The individual location managers have daily delivery and service information to identify trends.
  • Customer service representatives have information on accounts receivable so they can prioritize collections and can work customer delivery schedules to maximize driver and delivery efficiency.
  • Financial analyst saved 80+ hours per month on manual reporting and can now be strategic elsewhere.
  • Lost customers can be identified daily instead of 2+ months late, raising the opportunity to address why and win back.

Count on SVA as your strategic partner

Explore the capabilities that we use to solve your business problems and transform the way your organization functions.
See our capabilities

Ready to build a success story of your own?

Let’s chat! Just fill out the short contact form and our team will reach out shortly.
CONTACT US