Full SQL and Tableau Sales Project

Dataset: Real-world sales data by CodeBasics


View on Github

View Dashboard on Tableau Public



Project Summary

The purpose of this project is to analyze and build an interactive dashboard for this particular company. We want to see what our biggest clients are and what are some areas we need to improve on in order to make more profit. This can help the company decide if we need to maybe run a promotion in a certain area or to a specific buyer in order to reach our targets. By creating an interactive dashboard we will quickly be able to identify trends and areas we need to improve on.

In this project, MySQL was utilized to clean and analyze the dataset in order to uncover trends and patterns. After the data was cleaned I then transfered all tables to Tableau and made the appropriate joins in order to begin building the dashboard. The dataset consisted of five tables: cutomers, date, markets, products and transactions tables.

Key findings from the analysis include:

  • Overall, Delhi NCR provided the most revenue and contributed to about 48% of the total profit contribution with having 2.30% profit margins.
  • Surat market had the overall highest profit margin (4.86%) but only brought in about 2.61M in revenue and contributed to only 0.51% of the total profit contribution.
  • Prod318 was the overall highest selling product bringing in almost 70M.
  • From 2017 to 2020, overall sales are dropping.
These findings provide valuable insights into what the next steps are in order to increase profits. For example, we noticed that Surat had high profit margins but did not bring in much revenue. So the company can look for ways to generate more business in Surat whether it be more marketing in the area or maybe running promotions.

SQL Code




Tableau Dashboard

Tableau Dashboard Embedding