BI
Covid 19 Cases - Saudi Arabia
A comprehensive epidemiological tracking dashboard monitoring COVID-19 infection trends, recovery rates, and vaccination progress across regions in Saudi Arabia.
Project Overview
Developed to provide stakeholders, health professionals, and the public with real-time, interactive insights into the COVID-19 pandemic landscape in Saudi Arabia. The solution integrates disparate public health datasets into a centralized Power BI interface, allowing users to slice and dice metrics by region, date ranges, and demographic indicators to understand viral spread and healthcare capacity utilization
-
The Challenge
Daily retrieval of data from the Ministry of Health website, then re-displaying it in a Power BI report while retaining previous data.
-
The Approach
Designed and engineered the end-to-end data pipeline using Power BI. Applied rigorous data cleansing and modeling techniques to structure raw health statistics into relational schemas, followed by crafting a clean, accessible, and intuitive UI optimized for fast executive reporting
-
The Solution
An interactive Power BI dashboard featuring dynamic map visuals, trend analysis charts, key performance indicator (KPI) cards, and multi-parameter filtering panels that update seamlessly to deliver a complete picture of public health metrics
Project Achievements
- Automated daily data ingestion, eliminating manual reporting overhead.
- Delivered intuitive geographic breakdowns for all administrative regions in Saudi Arabia.
- Enabled rapid assessment of active cases, recoveries, and healthcare metrics in sub-second response times
The Results
- The dashboard succeeded in being a successful example of Power BI's ability to create an interactive report that exactly matches the report of the Saudi Ministry of Health.