SQL Projects

Covid-19 Data in SQL and Visualization in Tableau

• The raw dataset can be downloaded from here.

• Analyze and clean Covid-19 deaths and vaccination data from January 2020 to September 2023 in Microsoft SQL Server using CTE and Temp Table.

• Build a dashboard in Tableau showing global death percentage, death toll per continent, infection rate per country, infection prediction into 2025, new cases and new deaths daily in each country.

  View the project here ✔

  View visualization here ✔

Housing Data Cleaning and analysis in SQL

• The dataset contains over 50,000 records about the housing market in Nashville.

• Clean data (populated missing data, split data into new columns, removed unnecessary columns) in SQL Server.

• Analyze and derive insights from the dataset to understand the factors influencing property prices and explore trends in the real estate market.

  View the project here ✔

Healthcare Data in SQL and Visualization in Tableau

• The sample data is generated from Synthea and not associated with a specific electronic healthcare record platform.

• Explore various use cases such as patient volumes, emergency room throughput, procedures, and cost of care in SQL Server.

• Build four dashboards in Tableau showing flu shots immunization, ER visits, and encounters.

  View the project and visualization here ✔