CASE STUDY:

A private-equity backed food and beverage distributor

Enhanced Business Intelligence

About This Project
Client

A private-equity backed food and beverage distributor

Industry

Food and Beverage

Challenges

The company struggled to find value in the outputs due to both the timelag between the underlying data (transactions) and the reporting via the 3rd-party tools

Background

A private-equity backed distributor of food and beverage products had recently undergone an ERP transformation. To better leverage the quality of information now available via their new ERP the company stood up a new FP&A team and equipped them with a 3rd party business intelligence tool (i.e., PowerBI / Tableau).

Challenge

Despite their newfound ability to aggregate, explore and visualize data, senior management struggled to find value in the outputs due to both the timelag between the underlying data (transactions) and the reporting via the 3rd-party tools and with the trustworthiness of the analysis being presented, which never seemed to reconcile to the company’s financial statements. Charger leveraged its existing mapping of the underlying ERP to transform transaction-level data into common, repeatable business logic, automated the daily (near-real-time) extraction of information from the systems, harmonized all of the captured and remodeled data into a data warehouse. The company’s business intelligence teams were able to seamlessly connect their 3rd party tools to this trusted data repository and use the underlying metrics defined via Prism to power their on-going analysis and reporting.

Solution

Management, able to at a glance reconcile financial and operational reporting coming from the business intelligence teams back to financial results, immediately began trusting the intelligence being produced by their teams. Today, we continue to work with this client to crystalize many of their repeated models, originally built in a 3rd party tool, into our Pulse reporting tool where they are ingested daily by both company executives and their private equity sponsors.

ready to overcome reporting as an obstacle?

Get Started