This portfolio project showcases an interactive Power BI dashboard designed to analyze hospital operations, patient demographics, financial performance, and clinical outcomes. The dashboard demonstrates the use of data visualization, DAX measures, and executive reporting techniques to transform healthcare data into meaningful insights for operational and strategic decision-making.
- Develop a multi-page healthcare analytics dashboard using Power BI.
- Create executive-level KPIs to monitor hospital performance.
- Visualize patient demographics and clinical outcomes.
- Demonstrate proficiency in DAX, data modeling, and interactive reporting.
- Present healthcare data in a format that supports informed decision-making.
Provides a high-level overview of hospital performance through key performance indicators (KPIs), including:
- Total Admissions
- Total Billing
- Average Billing per Patient
- Average Length of Stay (LOS)
- Admissions by Month
- Billing by Diagnosis
- Billing by Insurance Provider
- Admissions by Type
Analyzes patient population characteristics, including:
- Age Distribution
- Gender Distribution
- Diagnosis by Age Group
- Insurance Provider by Age Group
- Blood Type Distribution
- Most Common Diagnosis
Evaluates operational performance across hospitals using:
- Admissions by Hospital
- Billing by Hospital
- Average Billing
- Average Length of Stay
- Normal Test Results %
- Test Results by Category
- Admissions by Type
Examines patient outcomes and quality metrics, including:
- Normal vs. Abnormal Test Results
- Medication Usage
- Billing by Diagnosis
- Test Results by Diagnosis
- Most Common Medication
- Average Length of Stay
- Power BI Desktop
- DAX (Data Analysis Expressions)
- Power Query
- Data Modeling
- Data Visualization
- Interactive Dashboard Design
- KPI Development
- Healthcare Data Analytics
- DAX Measure Creation
- Executive Reporting
- Data Storytelling
- Slicer & Filter Implementation
- Business Intelligence
This dashboard was created as part of my healthcare analytics portfolio to demonstrate Power BI, DAX, and data visualization skills using a hospital operations dataset.