Nsengiyumva7/CovidRwanda19-Data-analysis

Covid Rwanda-19 to World # 🇷🇼 COVID-19 Rwanda Data Analysis (SQL Project) ## 📌 Project Overview This project presents a comprehensive SQL-based analysis of COVID-19 data with a focus on **Rwanda**, alongside comparisons with other African countries. The goal of this project is to explore infection trends, death rates, and the impact of vaccination rollout using real-world data. --- ## 🎯 Objectives * Analyze COVID-19 spread in Rwanda * Evaluate the impact of vaccination * Compare Rwanda’s performance with other African countries * Extract meaningful insights for decision-making --- ## 🛠️ Tools Used * SQL Server * Azure Data Studio * CSV Dataset (COVID-19 global data) --- ## 📊 Dataset Description The dataset contains COVID-19 records including: * Total cases * New cases * Total deaths * New deaths * Population * Vaccination data --- ## 🧠 Key Analysis Questions & Answers --- ### 1️⃣ What percentage of Rwanda’s population was infected over time? **Insight:** Rwanda maintained a **very low infection rate (below 0.2%)** throughout the pandemic period. Although total cases increased over time, the proportion of the population affected remained minimal compared to global trends, indicating relatively effective containment. --- ### 2️⃣ What is the death rate trend in Rwanda? **Insight:** The death rate showed a **gradual increase over time**, but without sharp spikes. This suggests that while fatalities rose alongside infections, Rwanda’s healthcare response may have helped prevent extreme mortality surges. --- ### 3️⃣ During which period did Rwanda experience the highest growth in cases? **Insight:** The highest spike in new cases occurred around **January 2021**. This period represents the peak of infection growth, likely influenced by external factors such as policy changes, mobility, or increased testing. --- ### 4️⃣ How does Rwanda compare to other African countries? **Insight:** Rwanda ranked in the **lower-middle range** among African countries, with an infection …