Project information
- Category: Data Warehouse Solution
- Client: Healthcare Company
- Project date: Dec 2, 2020
Health Care - Data Warehouse
Need – Client wants to automate the manual process of report creation. The client was using Excel files to apply joins to various sources and create powerful reports after applying several business and cleansing rules.
Project Portfolio - We integrated the EHR system and Payroll system to fetch the necessary data. We used Data Factory pipeline to integrate both systems and populate the data warehouse's dimension and fact tables. Additionally, we implemented SSIS packages along with Data Factory pipeline to populate the data warehouse tables. We designed a Star Schema from the staging table for the Data Warehouse. Furthermore, we created a tabular model on top of the physical data mart to process the data and store the pre-calculated measures. Finally, we designed a Power BI report with the tabular model to present the report data.
Key Tools & Features
-
• Azure Data Factory
• Azure SQL Database
• Azure Blob Storage
• ETL Jobs
• SSIS Packages
• Power BI reports