amadigodswill33/Data-Exploration-in-SQL

Unearth insights into the COVID-19 pandemic. Focused on Nigeria and West Africa, our project utilizes advanced SQL queries for data exploration, employing Excel, SQL Server, and Tableau. Dive into infection rates, death counts, and vaccination strategies. Explore the repository and run the script for a comprehensive understanding of the data. # COVID-19 Data Exploration ## Table of Contents - Project Description - Project Focus - Data Source - Tools - Project Overview - How to Use the Script - Results and Impact - Skills Demonstrated - Conclusion ## Project Description Welcome to the COVID-19 Data Exploration project! This impactful data analytics endeavor utilizes advanced SQL queries to unearth critical insights from the intricate web of COVID-19 data. By synergizing information from the 'Covid Vaccination$' and 'Covid death$' tables, this project seeks to significantly contribute to our understanding of the dynamic nature of the pandemic, with a primary focus on Nigeria and the broader West African region. ## Project Focus The main geographical focus of this analysis revolves around Nigeria and the West African region. ## Data Source The COVID-19 dataset used in this project was retrieved from Kaggle. ## Tools Excel, SQL Server, Tableau ## Project Overview ### 1. Data Cleaning/Preparation (Excel) In this stage, the COVID-19 dataset undergoes meticulous cleaning and preparation using Excel. By addressing the following: - Missing Values - Data cleaning and Standardizing formats ### 2. Exploration Data Analysis (SQL Server) EDA involves thorough exploratory data analysis (EDA) techniques using advanced SQL queries to answer key questions, such as: - What is the total number of cases recorded to date - What is the Infection rate - What is the perspective of COVID-19 in Nigeria (Death count, Infection rate) compared to other West African countries - What is the global perspective of COVID-19 (Death count, people vaccinated, and percentage infected) ### 3. Data Analysis In the final phase, the real power of the project emerges through advanced data analysis techniques. Key objectives encompass understanding: - Infection rates - Death counts - Vaccination strategies, and - Deriving meaningful insights contributing to our comprehension of the COVID-19 pandemic in West Africa and Nigeria. ## How to U …