📊 Project Overview
An interactive Power BI dashboard analyzing India's healthcare system performance from 2015-21, combining data from National Family Health Survey (NFHS-5) and district-level health indicators. The project demonstrates advanced data analysis, SQL expertise, and interactive visualization capabilities.
📱 Dashboard Preview
Page 1: National Overview
Interactive map of India showing state-wise improvement rates, top 10 performing states, and regional performance breakdown.
Page 2: State Deep Dive
Drill-down analysis showing district-level performance within selected states, with top and bottom performers highlighted.
Page 3: Health Indicators Analysis
Detailed comparison of specific health metrics across states, showing trends from NFHS-4 to NFHS-5.
🎯 Key Findings
✅ Major Success: 78% National Improvement
101,619 health indicators improved across India (vs 28,426 declined), showing a 4:1 improvement-to-decline ratio. This demonstrates the effectiveness of National Health Mission programs.
🏆 Top Performers
- NCT Delhi: 94.2% improvement rate (1,960/2,080 indicators improved)
- Tripura: 87.8% improvement rate (Northeast success story)
- Telangana: 84.7% improvement rate (3,701/4,368 indicators improved)
📈 Biggest Health Wins
- Institutional Births: 68% → 89% (+20.5 percentage points)
- Early Antenatal Care: 51% → 72% (+20.2 pp)
- 4+ ANC Visits: 44% → 60% (+16.3 pp)
⚠️ Areas Needing Attention
- Bottom 5 Districts: Jabalpur (MP), Rupnagar (Punjab) showing 40%+ decline rates
- Child Nutrition: Only 47% of indicators improved
- Regional Disparity: South region lagging at 69.9% (vs Northeast at 76.4%)
🌟 Surprising Pattern: Northeast Leading
Despite infrastructure challenges, the Northeast region leads with 76.4% improvement rate, defying stereotypes and showing effectiveness of targeted tribal health programs.
⚙️ Technical Implementation
Data Pipeline
- Data Sources: NFHS-5 (140K+ records), HMIS, covering 707 districts
- ETL Process: Python scripts for automated data cleaning and transformation
- Database: SQLite with normalized schema (4 dimension tables + 1 fact table)
- Data Quality: Handled missing values, duplicate columns, standardized naming
SQL Skills Demonstrated
- Window Functions: RANK(), NTILE(), OVER() for performance rankings
- CTEs: Complex multi-level aggregations
- JOINs: Multiple table relationships across dimensions
- Views: 5 pre-built analysis views for common queries
Dashboard Features
- 3-Page Interactive Dashboard: National → State → Indicator drill-down
- 15+ Visualizations: Maps, charts, tables, KPI cards
- Advanced Filtering: Category, Indicator, Region, State slicers
- Dynamic DAX Measures: 12+ custom calculations
- Conditional Formatting: Color-coded performance indicators
💼 Business Value
- Policy Insights: Identifies best-performing states and successful programs for replication
- Resource Allocation: Highlights districts needing urgent intervention
- Performance Benchmarking: Enables state-to-state comparison and goal-setting
- Trend Analysis: Tracks 5-year improvement trajectory for 105+ health indicators
- Stakeholder Communication: Translates 140K+ data points into actionable insights
🎓 Skills Demonstrated
Technical Skills
- Database Design
- ETL Development
- SQL (Advanced)
- Python (Pandas)
- Power BI / DAX
- Data Modeling
Analytical Skills
- Data Quality Assessment
- Statistical Analysis
- Trend Identification
- Performance Metrics
- Correlation Analysis
- Outlier Detection
Business Skills
- Data Storytelling
- Stakeholder Communication
- Domain Knowledge (Healthcare)
- Strategic Insights
- Report Writing
- Presentation Design
📝 Project Details
- Duration: 3 weeks (from conception to deployment)
- Tools Used: Python, SQL, Power BI, GitHub
- Dataset Size: 140,608 records, 20MB database
- Lines of Code: 800+ (Python + SQL)
- Documentation: Comprehensive README, data dictionary, methodology
- Version Control: Git/GitHub with detailed commit history
🚀 Interested in Similar Analysis?
I can help your organization derive actionable insights from complex healthcare or policy data.
Get in Touch