One of the UK's leading care providers, with over 230 franchises reporting through one Azure data platform.
Home Instead needed to track data across every franchise to spot patterns and make informed decisions. The incumbent system needed a statement of works for every change, offered no self-service BI and could not embed reports.
We advised on data strategy, designed the architecture, built the Azure infrastructure, ETL pipelines, data warehouse and Power BI model. A proof of concept with five franchises led to a full six-month implementation: data from more than 230 franchises, over a hundred tables per database and more than 23,000 nightly pipelines.
