Company-Sales-Data-Analysis-and-Visualization-using-Tableau

A MySQL server data was hooked with tableau, necessary data analysis and data cleaning was performed. In the end, all the data was used to build interactive dashboards on Tableau.

In the 'Sales' database, there are in total 5 tables. They are:

1. customers
2. date
3. markets
4. products
5. transactions

Necessary data cleaning was done, for example: remove the empty rows, change the date format, currency conversion etc.

db_dump_version_2.sql was used to make analysis and that data was hooked with Tableau for making Dashboards.

DASHBOARD - Revenue Analysis

DASHBOARD - Profit Analysis

DASHBOARD - Profit Analysis on October 2019

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Fact Table Relation

Revenue by Markets

Profit Margin by Markets

Sales Quantity by Market

Revenue by Years

Profit Margin Trend

Note: The Tableau online publishing link isn't available right now because of subscription issues. I'll add that online link soon, so anyone can open it and interact with it as the whole thing is very dynamic.