SQL Data Analysis & Data Visualizaiton Projects

Compilation of SQL, Tableau related projects and challenges where I practice those skills.

Built with

• SQL Languages

  • SQL
  • MySQL
  • SQLite
  • Microsoft SQL

• Tools

  • MySQL Workbench
  • Microsoft SQL Sever Managment Studio
  • MS Excel

• Python

  • jupyter notebook

Projects & Challenges

Covid-19 Analysis Project

MSSQL data analysis project in forecasting the occurence of Covid-19 based on the collected data.

• perform data exploration through MSSQL from the collected data
• cleaning the data with help of Ms Excel and MSSQL
• find out the highest infection rate and death rate of major country
• discover insights and viz the data through Tableau

Nashville Housing

MSSQL data cleaning and analysis project

• cleaning the data with help of Ms Excel and MSSQL
• perform data exploration through MSSQL from the collected and cleaned data

Ultimate MySQL

• data analysis challenges for Books and Authors
• Udemy Course: The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Mid Summer Night Dream Project

MySQL and python project for analyzing Shakespeare's Mid Summer Night Dream play texts and characters

• loading information for analyzing purpose
• calcuating performance different queriy types such as SELECT, INSERT, UPDATE, DELETE
• manipulating plays and characters

License

This project is licensed under the MIT License - see the LICENSE.md file for details