In this extensive project, I embarked on a profound exploration of India's journey through the COVID-19 pandemic. This endeavor involved a multi-faceted approach, encompassing data preprocessing with Python, data analysis with SQL queries, and data visualization using Power BI. The project aimed to extract valuable insights from available datasets, providing a holistic view of India's response to the pandemic.
The project commenced with a critical step: data cleaning. Recognizing the importance of data quality, I meticulously renamed columns within the datasets to ensure uniformity and clarity. Additionally, Python played a vital role in data cleaning and manipulation. Python code was employed to perform various tasks, ensuring that the datasets were primed for in-depth analysis.
The core of this project involved data analysis through SQL queries. These queries were meticulously crafted to address specific problem statements and extract meaningful insights. Here's a closer look at the key areas explored:
I quantified the recovery rate among Indian states, extracting the number of recovered and active cases from the 'statewisedata' table. This analysis shed light on how effectively different regions were managing the pandemic.
Hospital bed availability was a critical concern during the pandemic. By analyzing the 'hospitalbeds' table, I assessed the availability of hospital beds in various states. This involved evaluating both the total population beds and the number of beds available, contributing to informed decision-making regarding healthcare infrastructure.
The 'icmrtestingdata' table provided valuable insights into India's testing efforts. I calculated the total number of samples tested, the total number of positive cases, and the difference between them. This analysis offered a comprehensive view of the testing landscape in the country.
To enhance the project's impact and accessibility, data visualization was conducted using Power BI. The visualizations served as a dynamic means to communicate insights effectively. These interactive visual representations allowed stakeholders and decision-makers to explore the data intuitively, gaining a deeper understanding of India's COVID-19 journey.
Dashboard 1 - 
Dashboard 2 - 
Dashboard 3 - 
Dashboard 4 - 
This project signifies a comprehensive analysis of India's response to the COVID-19 pandemic. The combined use of Python, SQL, and Power BI empowered the extraction of valuable insights from the datasets. These insights can be instrumental in policy-making, healthcare resource allocation, and pandemic management.
By leveraging the strengths of data preprocessing, SQL analysis, and data visualization, this project provides a comprehensive case study of India's COVID-19 situation. It underscores the significance of data-driven decision-making in tackling complex global challenges.