This project delves into the profound impact of the COVID-19 pandemic using a dataset sourced from Kaggle. Leveraging the robust capabilities of Microsoft SQL Server for data analysis and Tableau for visualization, the objective is to explore the dataset, identify regional disparities in infection rates, and conduct predictive analysis to forecast future trends
Employing Microsoft SQL Server, a series of queries are crafted to extract valuable insights from the COVID-19 dataset. These queries encompass diverse aspects, including total cases vs total deaths, infection rates vs population density, and identifying countries with the highest death count per population. Advanced SQL functionalities such as JOIN operations, Common Table Expressions (CTE), and temporary tables are utilized for efficient data manipulation and analysis.
- Through total cases vs total deaths analysis, significant trends emerge regarding the severity of the pandemic in different regions.
- By juxtaposing infection rates with population density, nuanced insights into the spread of the virus are uncovered, aiding in understanding the impact on densely populated areas.
- Identification of countries with the highest death count per population sheds light on regions facing disproportionate challenges in managing the pandemic.
- Breaking down data by continents facilitates a comprehensive understanding of regional variations in infection rates and mortality rates.
- Delving deeper, users are presented with average overall ratings categorized by aircraft type, complemented by the corresponding number of reviews. This segment facilitates insights into passenger perceptions of different aircraft models and their overall satisfaction levels.
In Tableau, the data is visualized to facilitate intuitive understanding and predictive analysis. The interactive dashboard features global statistics at the forefront, with an emphasis on infection intensity across regions through an interactive map. Additionally, a bar chart illustrates total deaths per continent, providing a comparative perspective on the severity of the pandemic. The dashboard also incorporates a predictive model to forecast future infection rates based on historical data trends, empowering stakeholders with actionable insights for proactive decision-making.
By synergizing the analytical prowess of Microsoft SQL Server with the visualization capabilities of Tableau, this project offers deep insights into the multifaceted impact of the COVID-19 pandemic. The analysis not only illuminates regional disparities in infection rates and mortality but also equips stakeholders with predictive tools to anticipate and mitigate future challenges. In an era marked by unprecedented global health crises, this integrated approach to data analysis and visualization is instrumental in informing evidence-based strategies for combating the pandemic and safeguarding public health.
- Dataset Source: Kaggle
- Tools Used: Microsoft SQL Server, Tableau