Atliq Hardware sales analysis project

Purpose

To unlock sales insights that are not visible before for sales team for decision support and automate them to reduced manual time spent in data gathering.

Tool used

MySql: for Exploratory Data Analysis (EDA)
Tableau: for data modeling, data cleaning and data visualising

Exploratory Data Analysis (EDA) in MySQL

Performed data analysis in mysql to find out different insights.

Data modeling in tableau

Modeled the data by creating the relationship among different tables in which transactions is acting as fact table.

Final Dashboard picture

- Found out top 5 customers and products
- Live data with filter options according to year and month.
- Live total sales quantity and total sales amount.

Findings

- Cities that drive in more revenue should be kept in consideration while building marketing strategies.
- Monthly results can also be comapred in order to find seasonal trends.
- Automated dashboard providing quick and latest sales insights in order to support data driven decision making.