A prominent operator of retirement communities and long-term care homes was looking for a partner to help them clean their data, improve data flows, and centralize data sources. Their Power BI development had become complex, challenging, and time-consuming to load Microsoft Excel/CSV files every month to produce standard reports. To solve the issue, Imaginet constructed a centralized, organized data warehouse, imported the Excel files into tables, and created a Power BI model with improved performance.

We used automated processes to bring files from Google Drive into Azure Storage, then used Azure Data Factory to run scripts, load, and transform the data from source files into the data warehouse (built in Azure SQL Database). We used Azure DevOps to create and track work items, manage source code, and deploy code automatically to test and production environments using release pipelines.

Our code review procedures acted as a quality gate and offered opportunities for feedback and learning for the client. We provided extensive mentoring and training through Microsoft Teams to give our client the knowledge and confidence to maintain the data warehouse with internal resources.

Imaginet helped the client move away from siloed data and develop a more cohesive data strategy. By consolidating data from multiple sources and automating a complex reporting system, we drastically reduced the time and effort needed to generate monthly reports, creating a clearer view of the business and improving ROI.