Businesses generate large volumes of sales data, but without proper analysis, it becomes difficult to:
- Identify top-performing products and categories
- Understand customer behavior and trends
- Track profitability across regions and time
- Make data-driven decisions
This project aims to solve these challenges by transforming raw sales data into meaningful insights using an interactive Excel dashboard.
The objective of this project is to analyze sales, profit, customer, and regional data to:
- Identify key business trends
- Evaluate performance across categories and states
- Track growth over time
- Discover high-value customers
- Provide actionable insights to improve profitability
The dataset contains transactional-level sales data with the following fields:
- Order Date / Year
- Customer Name
- State
- Category (Furniture, Office Supplies, Technology)
- Sub-Category
- Product Name
- Sales
- Quantity
- Profit
- Microsoft Excel
- Data Cleaning
- Pivot Tables & Pivot Charts
- Slicers (for Category & Year filtering)
- Dashboard Design
- KPI Cards
The interactive dashboard includes:
- Sales by Category → Identify top-performing product categories
- Profit Over Time (Category-wise) → Track profitability trends
- Sales by State → Regional performance analysis
- Customer Count Over Years → Growth in customer base
- Monthly Sales Trend → Identify seasonality
- Top Customers by Profit → High-value customer analysis
- Office Supplies generate the highest sales volume
- Technology generates the highest profit
- Furniture shows relatively lower profitability
👉 Insight: High sales does not always mean high profit
- Technology category shows consistent profit growth
- Furniture category has lower margins
👉 Insight: Profitability depends on cost and discount strategies
- California, New York, and Texas are top-performing states
👉 Insight: Sales are concentrated in major regions
- Customer count increases steadily over the years
👉 Insight: Business is expanding and acquiring new customers
- Peak sales observed in November and December
- Lower sales in early months like February
👉 Insight: Strong seasonality (likely festive demand)
- A small group of customers contributes a large portion of profit
👉 Insight: High dependency on key customers
- Low profitability in Furniture category
- Over-dependence on specific regions
- Seasonal fluctuations in sales
- Revenue concentration among few customers
- Focus on high-margin Technology products
- Optimize pricing and reduce heavy discounts in Furniture
- Target low-performing states
- Improve logistics and availability
- Retain top customers through loyalty programs
- Offer personalized deals
- Increase inventory before peak months
- Run promotions during low-sales periods
- Bundle high-selling and low-selling products
- Promote profitable categories
This project demonstrates how raw sales data can be transformed into actionable insights using Excel. The analysis highlights key business trends, identifies growth opportunities, and provides strategic recommendations to improve performance.
The dashboard enables stakeholders to make informed decisions by visualizing data across multiple dimensions such as time, category, customer, and region.
- End-to-end data analysis project
- Interactive Excel dashboard
- Real-world business insights
- Data-driven decision-making approach
(Add your dashboard screenshot here)
Mukesh Kumar
Data Analyst skilled in Excel, SQL, Power BI, and Data Visualization
- Add Power BI version of dashboard
- Integrate SQL for large datasets
- Perform advanced statistical analysis
Feel free to fork this repository, report issues, or suggest improvements.
For any queries, reach out via muk.786422@gmail.com.