This project presents a comprehensive, multi-layered analytical story that explores the global landscape of vaccination coverage, disease incidence, and immunization program effectiveness using authoritative datasets from the World Health Organization (WHO).
Built entirely on the Microsoft Fabric ecosystem, the solution demonstrates how Fabric can unify data engineering, data modeling, and interactive reporting to deliver insights that directly support global health decision-making.
Vaccination programs are one of the most impactful public health interventions — yet many countries struggle with incomplete coverage, dose drop-off, delayed vaccine introduction, and inconsistent disease reduction outcomes.
This dashboard answers critical real-world questions:
Are higher vaccination rates translating into lower disease incidence?
How does vaccine introduction affect disease cases in the years before and after rollout?
Which antigens, schedules, and booster programs show the strongest outcomes?
How much vaccine demand is expected in the next decade?
The report combines these dimensions into a unified analytical experience, enabling policymakers to evaluate effectiveness, identify risk pockets, and plan targeted interventions.
✔ Real-world impact
It uses authentic WHO datasets to uncover insights relevant to global public health.
✔ Full Fabric capability showcase
Data engineering, Lakehouse, SQL, notebooks, data modeling, and visualization — all in one ecosystem.
✔ Strong analytical depth
The dashboard answers more than 30 analytical and scenario-based questions.
✔ Clear storytelling structure
Each page builds on the next, guiding the audience through vaccination outcomes and disease trends.
✔ Designed for decision makers
Interpretation text and KPIs convert data into actionable insights.
Technical Excellence – How Fabric Was Used End-to-End
1️⃣ Data Engineering in Microsoft Fabric
WHO datasets collected and stored in Fabric Lakehouse (Files → Tables)
ETL Notebook used to clean, standardize, merge, and structure data
Fabric SQL Endpoint used for relational modeling and quality checks
Mapping tables (antigens, diseases, vaccine keys) created for semantic consistency
2️⃣ Data Modeling in Power BI (directly connected to Fabric)
3️⃣ Visualization & Storytelling
A professionally structured multi-page data story covers:
Global Vaccination & Disease Impact
First-to-Subsequent Dose Attrition
Incidence vs Coverage (Effectiveness Modeling)
Before/After Vaccine Introduction
Vaccine Schedule Effectiveness
Global Disparity & Benchmarking
Scenario Simulator & Demand Forecast
The report uses modern UI patterns:
navigation page
minimalistic white/blue WHO-themed palette
KPI cards, decomposition, small multiples
custom tooltips and drill-downs
contextual text for non-technical audiences
Ultimately, the dashboard supports:
better vaccination policy
timely identification of health gaps
resource allocation
outbreak risk assessment
evaluating the success of global immunization programs
By integrating reliable global health data with powerful visualization, this solution intends to empower countries and health organizations to drive data-driven vaccination strategies for a healthier world.
🏆 Fabric Community DataViz Contest | Winner and Judges Favorites
eyJrIjoiYTBjZjE5NjAtZTI1MS00M2FlLWFjMDAtN2EyNWM1YTNlNzUzIiwidCI6IjVmOGI3NGFkLWJkOGUtNDA4MC1iZGM2LTkyMDg0OTdhMjNmNCJ9
