I created a comprehensive, interactive Excel dashboard to analyze key healthcare metrics using a structured dataset. This project demonstrates my ability to transform raw data into clean, insightful visuals that support data-driven decision-making.
🎯 Project Objeve
The goal was to design a single-page, interactive dashboard that delivers actionable insights into:
- Patient demographics
- Health conditions
- Admission trends
- Education vs. credit behavior
🛠️ Skills & Tools Used
- Microsoft Excel (Advanced)
- Pivot Tables
- Pivot Charts
- Dynamic Slicers
- Data Cleaning & Transformation
- Dashboard Design Principles
📊 Dashboard Features
✅ Summary Cards
- Total Records
- Average Age
- Average Salary
✅ Pie Chart
- City-wise admission counts
✅ Bar Charts
- Health condition distribution by blood type
- Education level vs. credit score
✅ Line Chart
- Monthly admission trends
✅ Slicers for Interactivity
- Gender
- City
- Blood Type
- Month
📈 Key Insights Discovered
- Health Condition Trends: A high percentage of patients reported average or poor health, mostly tied to specific blood groups.
- Age Distribution: Most admissions fall within the 30–50 age group.
- Education vs. Credit Score: Higher education correlated with better credit scores.
- Monthly Trends: Admissions spike during Q2 and Q4.
🎨 Design Focus
- Clean, professional layout
- Clear typography and visual hierarchy
- Smooth filtering experience via slicers
💡 What This Project Shows
This project demonstrates my ability to:
- Work independently with complex data
- Create structured dashboards from scratch
- Blend data storytelling with technical precision
- Use Excel not just for analysis, but for user-friendly reporting