Linking data to a BI platform for an aggregate view on operational performance


The Challenge

The senior leadership of this franchise customer needed to report on an overall view of the business performance of each franchisee and store, consolidating all individual results for an overarching operational performance view. They additionally sought to form a baseline of performance and provide advanced alerting when a franchisee fell outside of the expected performance thresholds.

Whilst the data could be compiled and reported on, the challenge our customer had was each time the existing process took 5 hours across multiple resources, and the results were inconsistent due to the largely manual process and staff involved.

Client type: Franchise Business

Industry: Retail

Solution: Business Intelligence & Modern Data Warehouse