EazytheDataGuy/Infectious-Disease-Surveillance-hub-2009-2018-
Domaine:
healthcareType de record:
dataset
Créateur:
Eaz
Hôte:
Analysis of infectious disease surveillance data in Nigeria (2009-2018), highlighting case distribution, mortality rates, and affected demographics. Includes visualizations for data-driven public health insights.
# Infectious Diseases Surveillance Hub(2009-2018)
## Table of Contents
- Project Overview
- Data Sources
- Tools
- Data Cleaning/Preparation
- Exploratory Data Analysis
- Data Analysis
- Results/Findings
- Recommendations
- Limitations
## Project Overview
---
This project analyzes infectious disease trends in Nigeria from 2009 to 2018 using SQL for data cleaning and Power BI for visualization. It explores disease prevalence, mortality rates, gender-based distribution, urban vs. rural impact, and state-wise case trends.
### Data Sources
---
Infectious Diseases Data: The primary dataset used for this analysis is the "meningitis_clean" file
### Tools
---
- SQL - Data cleaning
- Power bi - for visualization
### Data Cleaning/Preparation
---
In the initial data preparation phase, we performed the following tasks:
1. Data loading and inspection.
2. Handling missing values.
3. Data cleaningand formatting.
### Exploratory Data Analysis
---
EDA involved exploring the infectious diseases data to answer key questions, such as:
- What are the most prevalent infectious diseases in Nigeria (2009-2018)?
- How does disease distribution compare between rural and urban areas?
- What is the overall mortality rate?
- How have disease cases fluctuated over the years?
- Which states reported the highest number of cases?
- How does the number of total cases compare to death cases by gender?
- How do disease cases vary by gender?
### Data Analysis
---
Include some interesting code/features worked with
```sql
CREATE DATABASE MENINGITIS_DATASET; -- creating a database
-- CREATING A TABLE FOR INSERTING MENINGITIS DATASET
CREATE TABLE MENINGITIS_DATASET2
(
id int,
surname text,
firstname text,
middlename text,
gender text,
gender_male int,
gender_female int,
state text,
settlement text,
rural_settlement int,
urban_settlement int,
report_date text,
report_year int,
age int,
age_str text,
date_of_birth text,
child_group int,
adult_group int,
disease text,
cholera int,
diarrhoea int, …
Similaires
Infectious Disease Surveillance, Country of Chad (PubMed).Towards One Health disease surveillance: The Southern African Centre for Infectious Disease Surveillance approachEarly Detection and Surveillance of Infectious Disease Outbreaks in Nigeria The Data Hub: Enhancing Infectious Disease Research and Action with Reproducible Data HarmonizationDigital Technologies to Enhance Infectious Disease Surveillance in Tanzania: A Scoping ReviewStrengthening Infectious Disease Surveillance in Nigeria: A Focused Scoping Review of SORMAS and the Electronic Integrated Disease Surveillance and Response System