Project reports and dashboard analysis for the MIMIC-IV demo lakehouse pipeline on Databricks with Power BI.
Medallion architecture, ETL pipeline, data source, Gold layer, DAX measures, and technologies.
Open report.html →Cross-domain analysis of all five Gold views — population, clinical profile, medications, operations, and recommendations.
Open conclusion →Executive Overview page — KPIs, admissions, LOS, readmissions, insurance. Verified against vw_admission_overview.
Primary vs secondary ICD diagnoses, comorbidity patterns, demographics, and LOS by condition. Verified against vw_diagnosis_analysis.
Prescription volume, top drugs, administration routes, drug types, and duration. Verified against vw_prescription_analysis.
Patient transfers, care unit flow, event types, and procedure volumes. Verified against vw_transfer_analysis + vw_procedure_analysis.
Interactive published dashboard — 4 pages: Hospital Overview, Diagnosis, Medication, Operations.
Open Power BI ↗