This Dashboard shows the insights of a store sales with every useful detail in data. It breaks down sales by department, year, month, and quarter. It also shows sales by quantity of products sold.
You can take a look at the data as an excel file
Created a data model for clear analysis, Ensured data quality.
- Top Metrics summarize
- Total Sales
- Number of cities
- Count of products & customers
- And a
Statesfilter
-
Profit by department (Pie Chart)
- Displays the top 5 selling departmaents
-
Customer by department (Horizental Bar Chart)
- Compares sales across different departments
-
Sales by department (Bar Chart)
- Displays the top 5 products sold
-
Selling States (Map Chart)
- Shows revenue contributions from different USA states
- Visualizes the amount of products sold for each state
-
Sales value by year and month (Line Chart)
- Demonstrates the relation between the orders value ratio and the times it is ordered
-
Department-Category-Quantity (Table Chart)
- Demonstrates the states of the department - Categories - quantites as a povit table
A relationship schema between every related coulmn in data.
Overall, this dashboard provides a good overview of sales performance for the retail store. It allows managers to see which departments are selling the most, how sales are trending over time, and how many products are being sold. This information can be used to identify areas for improvement and make data-driven decisions about inventory management, marketing, and staffing.