Riverside General Hospital — Healthcare Data Warehouse Model
Dimensional data warehouse model for financial, clinical, and operational analytics
📋 Project Overview
This project designed a dimensional data warehouse model for Riverside General Hospital to support financial, clinical, and operational analytics. I created a star schema connecting transaction data to core healthcare dimensions including doctors, patients, procedures, locations, and calendar.
🎯 Business Problem
Riverside General Hospital lacked a unified, analytics-ready data structure capable of supporting fast, reliable reporting across departments. Existing systems made it difficult to analyse revenue, expenses, provider performance, patient volumes, and geographic demand trends.
Data Modelling
Star Schema
BI Architecture
Healthcare Analytics
Data Engineering