01 — Sales Data
The first worksheet contains 51 sales records with Date, Sales Person, Region, Product, Units Sold, Unit Price, Cost of Goods, Total Sales and Profit.
DATA ANALYTICS PROJECT 04
Sales Analysis – Excel Dashboard
Interactive Microsoft Excel dashboard built to analyze sales performance, profitability, product performance, regional sales and salesperson performance.
Project Overview
This project analyzes a 51-record sales dataset and converts the raw records into an interactive Excel dashboard. The workbook is organized into three stages: raw sales data, PivotTable-based analysis, and the final dashboard.
The analysis focuses on sales volume, revenue, profitability, product performance, regional performance and salesperson performance.
Key Performance Indicators
Rs. 1,29,44,500Total Sales
Rs. 2,58,890Average Sales
4,705Units Sold
Rs. 38,34,400Total Profit
Project Process
02 — Pivot Table Analysis
PivotTables summarize sales by region, product and salesperson, while slicers provide interactive filtering for Region, Product and Sales Person.
03 — Final Dashboard
The final dashboard combines KPI cards, product analysis, regional sales, units sold and salesperson performance into an interactive view.
Business Analysis
What the Dashboard Analyzes
- Overall sales and average sales performance.
- Total units sold across products.
- Product-wise sales performance.
- Region-wise sales performance.
- Salesperson-wise sales performance.
- Total profit generated from sales.
Interactive Features
- Region slicer for East, North, South and West.
- Product slicer for seven product categories.
- Sales Person slicer for salesperson-level analysis.
- PivotTable-driven charts for summarized analysis.
- Dashboard visuals update based on slicer selections.
Key Results
Sales Performance
- Total Sales: Rs. 1,29,44,500
- Total Profit: Rs. 38,34,400
- Units Sold: 4,705
- Average Sales: Rs. 2,58,890
Analysis Highlights
The dashboard enables quick comparison of products, regions and salespeople. From the displayed analysis, West has the highest regional sales, while Sneakers has the highest product sales among the displayed categories.
Tools & Technologies
Project Outcome
Created a structured Excel analytics workflow that transforms raw sales records into an interactive dashboard for faster performance monitoring and business analysis.
View GitHub ↗