Covid-19 Insights with Tableau and SQL

Overview

This project showcases the use of SQL for data exploration and Tableau for data visualization. The datasets used include COVID-19 deaths data and a company dataset for customer insights. The project aims to demonstrate how data can be transformed into actionable insights using SQL queries and interactive dashboards.

---

Project Components

1. COVID-19 Data Exploration and Visualization

• Dataset: Sourced from Our World in Data
• Process:
  • SQL queries were used for data exploration and filtering.
  • Tableau was used to create visualizations for a better understanding of global COVID-19 trends.
• File(s) Included:
  • SQLQuery1.sql – SQL queries for data exploration.
  • covid-deaths.xlsx – The dataset used for analysis.
  • tableau.PNG – Tableau dashboard screenshot.

---

How to Use the Project

1. SQL Query Execution: Run the SQL queries (SQLQuery1.sql) on a compatible SQL engine (e.g., MySQL, PostgreSQL) to explore the dataset.
2. Tableau Dashboard: Open the Tableau files and connect to the provided datasets to interact with the visualizations.

---

Technologies Used

• SQL – For data extraction and transformation.
• Tableau – For data visualization and dashboard creation.
• Excel/CSV Files – For data storage and manipulation.

---

Future Enhancements

• Integrating real-time data for more dynamic dashboards.
• Expanding customer insights with predictive analytics.
• Automating data updates using SQL scripts.

---

1. COVID-19 Data Exploration and Visualization

• Global Trends: The dataset provides an overview of COVID-19 deaths across different countries, enabling comparative analysis.
• Mortality Rate Analysis: SQL queries help calculate mortality rates and identify countries with the highest impact.
• Temporal Patterns: Tableau visualizations showcase how COVID-19 deaths varied over time, highlighting peaks and troughs.
• Geographical Impact: Choropleth maps or bar charts in Tableau can help identify regions most affected.