🦠 COVID-19 Data Pipeline & Dashboard

Author: Rehana Hassan Muhumed
Certificate: IBM Data Analyst
Date: April 2026

---

📌 Project Overview

This project is an automated data pipeline that extracts live COVID-19 data from a public API, processes it, creates a professional dashboard, and generates daily reports.

Key Features:

• ✅ Real-time data extraction from API
• ✅ Automated data cleaning and processing
• ✅ Professional 4-chart dashboard
• ✅ Daily report generation
• ✅ Organized folder structure

---

📂 Data Source

Attribute	Details
API Name	disease.sh
URL	https://disease.sh
Authentication	None required (Free)
Data Type	Live COVID-19 statistics
Countries Tracked	Somalia, USA, UK, Kenya, Ethiopia, Nigeria, South Africa

---

📊 Dashboard Components

The professional dashboard includes 4 visualizations:

Chart	Description
Top Left	Total COVID-19 cases by country (horizontal bar chart)
Top Right	Deaths vs Recovered comparison (stacked bar chart)
Bottom Left	Cases per 1 million people by country
Bottom Right	Summary statistics card with key metrics

Dashboard Preview

---

📁 Project Structure

covid-data-pipeline/
│
├── data/
│   └── covid_today.csv              # Latest COVID-19 data
│
├── images/
│   └── covid_dashboard.png          # Professional dashboard
│
├── reports/
│   ├── covid_report_latest.txt      # Most recent report
│   └── covid_report_YYYYMMDD.txt    # Daily archived reports
│
├── notebooks/
│   └── covid_analysis.ipynb         # Main Jupyter notebook
│
├── README.md                        # Project documentation

---

🔧 Tools & Technologies

Tool	Purpose
Python 3.13	Core programming language
Requests	API data extraction
Pandas	Data manipulation & analysis
Matplotlib	Dashboard visualization
Jupyter Notebook	Development environment
Git & GitHub	Version control

---

🚀 How to Run This Project

Prerequisites

• Python 3.13 or higher
• Internet connection (for API data)

Step-by-Step Instructions

# 1. Clone the repository
git clone https://github.com/rihhanna/covid-data-pipeline.git

# 2. Navigate to project folder
cd covid-data-pipeline

# 3. Install required packages
pip install requests pandas matplotlib

# 4. Launch Jupyter Notebook
jupyter notebook

# 5. Open and run: notebooks/covid_analysis.ipynb
# Click "Run All" to execute all cells

Expected Output

After running, you will see:

• A professional 4-chart dashboard
• CSV file saved in data/ folder
• Text report saved in reports/ folder

---

📈 Sample Report Output

========================================
     COVID-19 DASHBOARD REPORT
========================================
Generated: 2026-04-28 14:30:00
========================================

COUNTRY STATISTICS:
========================================

Country: Somalia
   Population: 15,893,000
   Total Cases: 27,334
   Total Deaths: 1,361
   Active Cases: 1,234
   Recovered: 24,739

Country: USA
   Population: 331,900,000
   Total Cases: 103,436,829
   Total Deaths: 1,195,672
   Active Cases: 1,256,789
   Recovered: 100,984,368

========================================
GLOBAL SUMMARY
========================================
Total Countries: 7
Total Cases: XXX,XXX,XXX
Total Deaths: XXX,XXX
Death Rate: X.XX%
Recovery Rate: XX.XX%
========================================

---

📊 Key Insights

Finding	Insight
Highest Cases	USA has the highest total cases
Death Rate	Varies significantly by country
Recovery Rate	Most countries show high recovery rates
Cases per Million	USA and UK have highest per capita rates

---

💡 What I Learned

Building this project taught me:

1. API Integration – How to fetch live data from public APIs
2. Data Pipeline – End-to-end data extraction to reporting
3. Dashboard Design – Creating professional, multi-chart visualizations
4. Automation – Structuring code for daily execution
5. Git Workflow – Organizing and pushing projects to GitHub

---

📚 Related Projects

Project	Description	Link
Project 1	Telco Customer Churn Analysis	GitHub Link
Project 2	Sales Performance Dashboard	GitHub Link
Project 3	COVID-19 Data Pipeline	GitHub Link

---

👩‍💻 Author

Rehana Hassan Muhumed

Role	Details
Position	Data Analyst (In Training)
Certificate	IBM Data Analyst Professional Certificate
GitHub	github.com/rihhanna
Location	Somaliland

---

🙏 Acknowledgments

• disease.sh – For providing free COVID-19 API
• IBM – For Data Analyst Certificate curriculum
• Open Source Community – For Python libraries

---

⭐ Show Your Support

If you found this project useful:

• ⭐ Star this repository on GitHub
• 🔗 Share it with your network
• 📝 Connect with me on LinkedIn

---

Built with ❤️ by Rehana | 3/3 Portfolio Projects Complete

Feel free to reach out for collaboration, feedback, or opportunities!