Intrahealth Builds Azure Analysis Services Data Models via Azure Data Factory for Global Facility Power BI Immunization Reporting
CHALLENGE
Intrahealth is one of the world's largest global health nonprofits who has worked in over 100 countries since 1979 to help eradicate the world from curable and preventable diseases. By working alongside the CDC to administer vaccines and treatments world wide, Intrahealth is looking to eradicate some of the world’s deadliest diseases over time including HIV.
As a part of Intrahealth’s efforts to monitor its facility’s efforts globally, the organization was looking to build a data model that would populate its measures dynamically and programmatically every time global facility reporting results were delivered.
SOLUTION
HGS delivered interactive Power BI dashboards that would allow Intrahealth to measure the vaccination rates across all of their global facilities for all of the testing that they were doing.
TECHNOLOGY
The data models for these dashboards were built in Azure Analysis Services on top of the Azure Data Factory pipelines administered by Intrahealth. HGS built C# scripts to automate the population of the metrics built on the Analysis Services hosted TOM data model used for the Power BI reporting. This way no DAX is ever needed to be built by Intrahealth data analysts for their reporting as the new columns and measures are built dynamically every time the C# script is run.
TEAM
The Intrahealth team consisted of a core Azure and Power BI solutions architect.
DELIVERY
Through an agile process, the engineer was able to continuously integrate feedback throughout the design and development process. HGS worked directly with the Intrahealth Data Science team and stakeholders. Microsoft Teams was used for project management, allowing Intrahealth to stay in contact with the HGS team at all times.
IMPACT
With the help of HGS, Intrahealth was able to take a formulated concept and bring it to life. Centralizing their Power BI data models using Azure Analysis Services allows for the Intrahealth data analysts to be able to consume from Power BI data models and the built measures and columns directly rather than having to implement new logic for each report instance. This not only saves time through RPA of development time but also allows for less human error. The dynamically built measures through C# have been validated so no analyst is building any new metrics that could be error prone. Therefore, a standardization of reporting is achieved as everyone is using the centrally defined Azure Analysis Server hosted data model rather than a different Power BI one each time.