Healthcare Data Warehouse Design

Designed a healthcare data warehouse to support business intelligence and analytics using the Kimball dimensional modeling methodology. Developed a scalable star schema consisting of fact and dimension tables to enable efficient reporting and analytical queries.

The project included data profiling, data quality validation, ETL planning, and dimensional modeling to ensure accurate, consistent, and reliable healthcare data for decision-making. The solution was designed to support hospital performance analysis and future analytics initiatives.

Highlights

Designed a Star Schema data warehouse

Applied Kimball dimensional modeling

Defined fact and dimension tables

Performed data quality validation

Optimized the model for analytical reporting

Technologies

SQL Server • Kimball Methodology • Star Schema • Data Warehouse • Data Modeling • ETL