Complex Data from Multiple Sources into a Combined Visual Report

The Challenge 

With many restaurants throughout the country and internationally, the client had very large and complex data sets. These were from multiple sources. The requested output data ranged from details such as food quantities sold per hour per restaurant, to daily restaurant profitability, to corporate metrics. Combining this data into meta data sets and then meaningful, individualized reports for these diverse groups with very different needs was a significant challenge.

The Solution

The development architecture was created and then refined. The client was consulted on future data sets and development requirements to ensure the architecture would accommodate long term goals.

Our development and analyst team created APIs and a data warehouse for the many data sets.

Our Power BI team of specialists worked closely with the client to develop the best visualization profiles that would aid the wide group of users. The users ranged from the CEO, CFO, COO and the rest of the Executive team, Finance and Accounting, Regional Operation Managers, to the individual restaurant Managers and Operating Staff.

Using Power BI, and very large data sets from many disparate data sources, the team created individualized reports with specialized filters and designated access groups.

The Result

Instead of looking through a multitude of disjointed excel files, everyone had access to their own specialized information in a visualized, easy to understand format.

They could dig down to the finest detail when necessary. Comparisons with prior months, quarters, years, other stores, and many other scenarios were readily available.

The result: the teams were able to manage their operations in a much more efficient and profitable way.