mauree155/NCDC-COVID-19-Report

This project analyzes COVID-19 in Nigeria using NCDC data, examining cases, recoveries, deaths, and regional trends to show how the pandemic evolved over time. # NCDC-COVID-19-Report ### Table of contents 1. Project Overview 2. Data Source 3. Tools Used 4. Analytical Process 5. Dashboard 6. Executive Summary 7. Recommendations 8. Conclusion ## 1. Project Overview This project offers a comprehensive, data-driven view of the COVID-19 pandemic as it unfolded across Nigeria. Built using real-time case data from the Nigeria Centre for Disease Control (NCDC), the dashboard highlights the national and state-level impact of the virus, tracking confirmed cases, recoveries, deaths, and active infections over time. Designed for both public health stakeholders and analysts, the interactive dashboard presents clear trends, regional disparities, and health response patterns. It allows users to explore the data across multiple time frames and geographic filters to support data-informed decision-making during and after the pandemic. By visualizing the evolution of the virus from early outbreak to eventual containment phases, the project serves as a digital historical record and a practical tool for understanding public health dynamics in Nigeria. ## 2. Data Source The dataset was obtained from the official COVID-19 reports published by the Nigeria Centre for Disease Control (NCDC). It covers daily confirmed cases, recoveries, and death counts for each state in Nigeria. Each entry includes: - State name - Date of report - Number of confirmed cases - Number of recoveries - Number of deaths From this dataset, additional fields such as Active Cases, Monthly Trends, and Total Aggregates were derived for analytical depth. ## 3. Tools Used - Microsoft Excel Used for data cleaning, structure adjustment, column renaming, and preliminary calculations (e.g., active cases, data formatting). - Power BI Utilized for dashboard design, DAX calculations, and interactive visualizations. Filters were applied to enable dynamic views by Year, Month, and State, while chart visuals conveyed trends and distributions clearly. ## 4. Analytical Process **Step …