An interactive Excel Dashboard that provides insights into sales trends, customer behavior, and product performance. Ideal for store managers, sales teams, and analysts seeking to monitor and understand business performance at a glance.
This dashboard offers visualizations and key metrics to help identify growth opportunities and sales patterns. It includes:
-
Sales Over Time (Line Chart)
Tracks trends in sales across the four main product categories: Bookcases, Chairs, Furnishings, and Tables. -
Sales by Region
Compares total sales across different geographic regions: Central, East, South, and West. -
Top Performing States
Highlights states with the highest sales. -
Top Performing Cities
Displays the cities generating the most revenue. -
Top Customers
Lists the highest-value customers by sales volume. -
Top 10 Purchased Items
Showcases the most frequently sold products.
Filter and slice data to explore targeted insights:
- Date — Select a specific time range on this timeline.
- Item Category — Filter by product type.
- Region — Focus on sales by region.
- Segment — Analyze data by customer segments (Consumer, Corporate, Home Office).
Data used in this dashboard comes from this Kaggle dataset - https://www.kaggle.com/datasets/zahraaalaatageldein/sales-for-furniture-store.