💡 Key Learnings & Project Insights

📊 Power BI & Dashboard Design

• Built an interactive dashboard that highlights patient flow, waiting times, and satisfaction levels.
• Designed visuals like KPIs, bar charts, pie charts, and heatmaps to clearly explain hospital performance.
• Learned how to apply conditional formatting to emphasize waiting status and referral patterns.

🔗 Data Modeling & DAX

• Used calculated columns and DAX measures to categorize patients by wait time intervals, admission status, and age groups.
• Created a date-based analysis to track patient admissions across time periods.
• Applied KPI indicators (Avg Wait Time, Satisfaction Score, % On Target Patients) for quick insights.

🧩 Problem Solving & Analysis

• Identified bottlenecks in patient waiting times (62% seen within target vs. 38% delayed).
• Analyzed department referral trends, showing which specialties contributed most to ER cases.
• Observed demographic patterns like 0–9 age group being the largest, and differences in male vs female admissions.

📁 Project Execution & Confidence

• Completed a realistic healthcare dataset project from scratch.
• Strengthened knowledge of healthcare KPIs and how dashboards can support hospital decision-making.
• Boosted confidence to explain data storytelling by connecting KPIs to real-world hospital challenges.