Skip to content

Latest commit

 

History

History
36 lines (25 loc) · 2.83 KB

README.md

File metadata and controls

36 lines (25 loc) · 2.83 KB

CovidPortfolio-SQL-Tableau 📊

CovidPortfolio-SQL-Tableau is a project that focuses on analyzing and visualizing Covid-19 data using SQL and Tableau. Also is focusing on data-cleaning. The project utilizes SQL queries to extract and analyze data related to Covid-19 cases, deaths, and vaccinations from a database. The analyzed data is then visualized using Tableau to create interactive and informative dashboards. 📈📉

Features 🚀

  • Extract and analyze Covid-19 data from a SQL database 📊
  • Utilize SQL queries to filter, aggregate, and join data 📋
  • Visualize Covid-19 data using Tableau to create interactive dashboards 📈
  • Explore various dimensions of Covid-19 data, such as cases, deaths, vaccinations, and geographic location 🌍
  • Analyze trends, patterns, and correlations in the data using SQL and Tableau 🔍
  • Customize Tableau dashboards to create compelling visualizations for stakeholders 🎨
  • Provide insights and recommendations based on the data analysis for decision-making purposes 📝

Technologies Used 💻

  • SQL: SQL (Structured Query Language) is used to extract, filter, aggregate, and join data from a database. It is used to perform data analysis and retrieval tasks in this project. 🗃️

  • Tableau: Tableau is a powerful data visualization tool that is used to create interactive and visually appealing dashboards. It is used to visualize the Covid-19 data in various formats, such as bar charts, line charts, maps, and tables. 📊

Installation 🛠️

To use the CovidPortfolio-SQL-Tableau project, follow these steps:

  1. Clone the repository from GitHub: https://github.com/perskii/CovidPortfolio-SQL-Tableau- 📥
  2. Install a SQL database management system, such as MySQL or PostgreSQL, and create a database to store the Covid-19 data. 💾
  3. Import the provided Covid-19 data into the database. The data can be found in the excel sheets with COVID-DATA directory of the repository, in CSV format. 📈
  4. Connect to the database using a SQL client or an Integrated Development Environment (IDE) that supports SQL, such as MySQL Workbench or pgAdmin. 🖥️
  5. Execute the SQL queries provided in the SQL queries directory of the repository to analyze the Covid-19 data. The queries can be customized based on the specific data analysis requirements. 📋
  6. Install Tableau Desktop or Tableau Public, and open the Tableau workbook provided in the Tableau directory of the repository. The workbook contains pre-built dashboards that visualize the analyzed Covid-19 data. 📊
  7. Customize the Tableau dashboards based on the specific visualization requirements, such as changing chart types, adding filters, and modifying colors. 🎨
  8. Save the customized Tableau dashboards and share them with stakeholders for insights and decision-making purposes. 💡

Contributing 🤝

If you are interested in