Day 15 COVID-19 Analysis Dashboard
DAY 15

🦠 COVID-19 Analysis Dashboard

Ghaziabad Mohan Nagar
Design Drafted by: HR Prateek Sharma

🌍 COVID-19 Pandemic Data Analysis

Power BI Dashboard Development with Real-World Data

🔌 API - Application Programming Interface
API
Application Programming Interface
An API is a set of protocols, tools, and definitions that allows different software applications to communicate with each other. In Power BI, APIs enable us to connect to external data sources, retrieve real-time data, and integrate various services seamlessly. APIs act as intermediaries that allow applications to request and exchange data efficiently and securely.
📊 Data Source & Analysis

🔗 COVID-19 Data Source

Comprehensive data on COVID-19 cases, deaths, and recoveries by country and territory

📥
Data Loading

Load: When data should be clean

  • Import cleaned and validated data
  • Ensure data quality before loading
  • Remove duplicates and errors
  • Standardize formats and values
  • Optimize for performance
🔧
ETL Tool

Extract, Transform, Load

  • Extract data from multiple sources
  • Transform and clean the data
  • Load into destination system
  • Automate data pipelines
  • Schedule regular refreshes
🌐
Web Data Import

Wikipedia COVID-19 Data

  • Connect to web data source
  • Extract tables from Wikipedia
  • Parse HTML content
  • Transform into usable format
  • Create dynamic connections
⚡ Power Query Editor

🔍 Power Query Editor: ETL Tool

Power Query Editor is Microsoft's powerful ETL (Extract, Transform, Load) tool integrated into Power BI. It provides a visual interface for data transformation and cleansing operations.

Key Features: Data shaping, column operations, filtering, merging, appending, and custom transformations using M language.

⚠️ IMPORTANT: Cannot use Ctrl+Z in Power Query Editor

Unlike traditional applications, Power Query Editor doesn't support the standard Ctrl+Z undo function. Instead, you must use the Applied Steps panel to remove or modify transformation steps.

📈 COVID-19 Dashboard Components
📊
Total Cases Analysis
💔
Death Rate Tracking
💚
Recovery Statistics
🌍
Country-wise Comparison
📅
Timeline Analysis
🗺️
Geographic Distribution
🎯
Dashboard Objectives
  • Visualize COVID-19 spread patterns
  • Compare country-wise statistics
  • Track recovery and mortality rates
  • Identify hotspots and trends
  • Enable data-driven decisions
📋
Data Preparation Steps
  • Import Wikipedia COVID-19 data
  • Clean and validate entries
  • Handle missing values
  • Create calculated columns
  • Establish data relationships
📊
Visualization Types
  • World map with case distribution
  • Line charts for trend analysis
  • Bar charts for comparisons
  • Cards for key metrics
  • Tables for detailed data
💡 Key Concepts Learned
🔌 API Integration
📥 Data Loading
⚡ Power Query Editor
🔧 ETL Process
🌐 Web Data Import
⚠️ No Ctrl+Z
📊 Dashboard Creation
🦠 COVID-19 Analysis
🎓 Learning Outcomes

By completing this COVID-19 Analysis Dashboard project, students will gain practical experience in data extraction from web sources, data transformation using Power Query Editor, understanding API concepts, implementing ETL processes, and creating meaningful visualizations that tell the story of the global pandemic. This hands-on project demonstrates how data analytics can provide valuable insights during critical global events.

COVID-19 Analysis Dashboard - Day 15

Power BI + Real-World Data = Powerful Insights

Ghaziabad Mohan Nagar

Designed by HR Prateek Sharma

Last Updated: December 6, 2025

Comments

Post a Comment

Popular posts from this blog

  HR Analytics - Day 2 Notes 📊 HR Analytics - Day 2 Ghaziabad, Mohan Nagar 🔄 Different Phases of HR Phase 1: Job Posting Internal Hiring: Recruiting from within the organization External Hiring: Recruiting from outside the organization External Hiring Process: Recruitment Example Scenario: 1000 resumes received for 2 job positions Step 1: Short Listing - ATS (Applicant Tracking System) From 1000 resumes → ATS shortlists → 100 candidates ⚠️ Critical Point: Selection of wrong candidates = Loss of time KPI Metri...
Read more
  HR Analytics - Day 1 Notes 📊 HR Analytics - Day 1 Ghaziabad, Mohan Nagar 💱 Currency Conversion Reference $1 Million = ₹8,000 Cr $5 Million = ₹40,000 Cr $50 Million = ₹40 Lakh Crore 📚 Key Terminology BPO Business Process Outsourcing GPU Graphics Processing Unit KRA Key Responsibility Area KPI Key Performance Indicator - Quality of work, helps che...
Read more
  Day 3 - HR Analytics Notes 📊 Day 3: HR Analytics & Business Intelligence Ghaziabad, Mohan Nagar Drafted by: HR Prateek Sharma 📈 Key Metrics Attrition Rate (A.R): Total Employees Left / Total Employees × 100 Example: 45/1500 × 100 = 3% Yearly Increment of Employee = 10% 🔍 Four Types of Analytics 1. Descriptive Analytics Like describing the problem to a doctor Name, Age, Gender, Address Last college name Kinship Rule: Blood relations allowed in companies (preference-based) Considerations: Discrimination, same comp...
Read more