Built fully in (Excel) using slicers, Pivot charts,
and clean formatting.
? Insights extracted :
• Highest average billing amount was in the
36–50 age group
• Arthritis and Diabetes are the most common conditions
• Most frequently used medications: Aspirin and Ibuprofen
• Females show higher medication usage than males
• Admission types are almost evenly distributed (Elective – Emergency – Urgent)
Dashboard Features :
• Dynamic filters for: Age Group, Gender, Medical Condition, admission type, and Test Results
• Charts show distribution, frequency, and averages
• Clean, minimal design that highlights key takeaways