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

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:

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

ptyadana/SQL-Data-Analysis-and-Visualization-Projects

ptyadana

Reviews

Repository Details