SQL Data Analysis & Data Visualizaiton Projects

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

Built with

• SQL Languages

  • SQL
  • MySQL
  • PostgreSQL
  • SQLite

• Tools

  • MySQL Workbench
  • pgAdmin
  • DB Browser for SQLite

• Apache Spark

  • Spark with pySpark
  • databricks

• Python

  • psycopg2
  • jupyter notebook

Projects & Challenges

Instagram Clone Project

MySQL project which is a cloned mimic version of Instagram database. It is used to perform data analysis for real world business related questions and scenarios such as

• find out the rewarding system for the loyal users
• launching campaign to target the weekdays with the most user registerations
• encouraging inactive users to log in back to the system
• etc.

Film Rental Store Project

MySQL data analysis project in helping Film Rental Store to

• perform data analysis for user behaviours
• discover marketing stats
• find actionable customer/business insights
• measure and track marketing efforts
• etc.

Company Employees - SQL & Tableau Visualization Project

MySQL & Tableau integration project for analyzing employee data and visualizing the findings across the departments for management including

• What is breakdown between the male and female employees working in the company each year, starting from 1990?
• What is the number of male managers to the number of female managers from different departments for each year, starting from 1990?
• What is the average salary of female versus male employees in the entire company until year 2002? Need to filter out by departments.
• etc.

Parch & Posey - Data Analysis Project

PostgreSQL project for helping fictional company called Parch & Posey for

• managing the Orders,
• finding out the relationship with different Accounts
• monitoring the performance of Sales Reps
• etc.

Digital Music Store - Data Analysis Project

PostgreSQL Data Analysis project to help Chinook Digital Music Store to help how they can optimize their business opportunities and to help answering business related questions.

• countries with most invoices
• city with best customers
• finding out who the best customer is
• etc.

Restaurant & Library - Information & Patrons Project

SQLite project for

• In the Restaurant - helping the Restaurant to manage customer information, reservations, orders and party invities in for Restaurant 20th Anniversary.
• At the Library - helping the Library to manage the books statistics, check out and loan process, managing on due loans, encouraging patrons, etc.

California Population Project

MySQL project for analyzing Californa population projection data

• getting population data and loading for data analysis
• finidng out male and female populations per county for 2014

California Education Project

MySQL project for analyzing Population Projection and Education data

• initital cleaning for education data
• finding the percentage of education attainment for each category across differnent age group
• getting demographics based on education data and age group
• finding out projection of education demand for each age group based on Population Projection and Education data

UK Road Safty Accidents 2015 Project

MySQL and python project for analyzing UK road safty data, accidents and severity level

• finding out what is meadian severity value of accidents caused by various Motrocycle
• Accident Severity and Total Accidents per Vehicle Type
• Average Severity by vehicle type
• Average Severity and Total Accidents by Motorcyle

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

Project - Analyze International Debt Statistics

PostgreSQL project in Jupyter notebook for analyzing international debt statistics using data from world bank.

• What is the average debt across countries?
• What is the maximum debt indicator?
• Which country has the highest debt in which debt indicator
• etc.

Tableau

• My Tableau Public Profile
• Tableau Badges
• Data Science with Tableau
• Analytics Best Practices
• Dashboard Design: Visual Best Practices
• Visual Analytics
• Desktop III: Advanced
• Desktop II: Intermediate
• Desktop I: Fundamentals
• Getting Started with Tableau Desktop
• Tableau_2020_A-Z_Hands-On
• SQL - MySQL for Data Analytics and Business Intelligence
• Introduction to Tableau by 365 Data Science

SQL

Ultimate MySQL

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

Complete SQL Mastery

• handling and analyzing Large Ecommerce Store for clients, payments, invoices, products and shipping information.
• Course: Complete SQL Mastery

SQL Code Challenges

• In the Restaurant - helping the Restaurant to manage customer information, reservations, orders and party invities in for Restaurant 20th Anniversary.
• At the Library - helping the Library to manage the books statistics, check out and loan process, managing on due loans, encouraging patrons, etc.
• Lynda Course: SQL Code Challenges

SQL 30 Questions

• challeges your SQL knowledge with those SQL questions
• Skillshare Course: 30 Simple SQL Interview Queries

SQL Queries - Practice your SQL Knowledge

• challeges your knowledge with those SQL questions
• Skillshare Course: SQL Queries: Practice your SQL Knowledge!

SQL for Data Analysis - Weekender Crash Course

• beginner challenges with fun instructors.
• Udemy Course: SQL for Data Analysis: Weekender Crash Course

Complete SQL & Databases - ZTM

Advancing SQL Journey - (In Progress)

To skill up my SQL related skills in specific areas and topics:

• Advanced SQL for Application Development
• Advanced SQL for Data Science - Time Series
• Advanced SQL for Query Tuning and Performance Optimization
• Advanced SQL for Data Scientists
• SQL for Statistics Essential Training
• SQL for Exploratory Data Analysis Essential Training
• MySQL Development - Lynda
• MySQL Configurations
• SQL Code Challenges - Lynda
• Database Clinics - MySQL

Apache Spark & PySpark

• Intro to Spark SQL and DataFrames
• Apache Spark Essential Training
• Spark for Machine Learning & AI
• Apache PySpark by Example
• Apache Spark Deep Learning Essential Training

License

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