📊 Sales Data Analysis Dashboard

📌 Project Overview

This project focuses on analyzing sales data using Microsoft Excel to understand business performance, sales trends, and profitability. The analysis transforms raw sales records into meaningful insights that can support data-driven business decisions.

The project explores sales performance across different years, months, states, customers, product categories, and sub-categories through data analysis, pivot tables, and dashboard-oriented reporting.

🎯 Project Objectives

• Analyze overall sales and profit performance.
• Identify monthly and yearly sales trends.
• Compare sales across states and product categories.
• Identify the most profitable customers.
• Evaluate product and sub-category performance.
• Support business decision-making through data visualization.

🛠️ Tools and Technologies

• Microsoft Excel — Data analysis and reporting
• Pivot Tables — Summarizing and aggregating sales data
• Charts and Data Visualization — Presenting trends and comparisons
• Data Cleaning — Preparing data for analysis
• Business Intelligence — Converting data into actionable insights

📂 Dataset Overview

The dataset contains 9,993 sales records with 11 columns, including:

• Order Date
• Month and Year
• Customer Name
• State
• Category and Sub-Category
• Product Name
• Sales
• Quantity
• Profit

The records cover the period from January 2020 to December 2023.

📈 Key Performance Indicators (KPIs)

• Total Sales: 2,296,919.70
• Total Profit: 286,409.85
• Total Quantity Sold: 37,871
• Total Customers: 793 unique customer names
• Total Products: 1,850 unique product names
• Product Categories: 3

Note: Monetary values are presented in the dataset's original units; the currency is not specified.

🔍 Key Analysis Areas

1. Sales by State

Compare sales across states to identify high-performing geographical markets.

2. Top Profitable Customers

Identify customers contributing the most profit to the business.

3. Yearly Profit Analysis

Evaluate annual profitability and compare performance across product categories.

4. Monthly Sales Analysis

Explore monthly sales patterns and identify seasonal trends.

5. Category and Sub-Category Analysis

Compare sales across Furniture, Office Supplies, and Technology, as well as individual product sub-categories.

6. Sales Dashboard

Bring important performance indicators and analytical views together for easier business reporting.

💡 Business Value

This project demonstrates how spreadsheet-based analysis can help businesses monitor performance, identify profitable customers, compare product categories, understand regional sales patterns, and make informed decisions.

📚 Skills Demonstrated

• Data Analysis
• Microsoft Excel
• Pivot Tables
• Data Summarization
• Sales and Profit Analysis
• KPI Reporting
• Data Visualization
• Business Insight Generation

📁 Repository Structure

Sales-Data-Analysis-Dashboard/
│
├── SALES DATA.xlsx
└── README.md

🚀 How to Use This Project

1. Download or clone this repository.
2. Open SALES DATA.xlsx in Microsoft Excel.
3. Explore the worksheets containing sales records and summarized analyses.
4. Review the state-wise sales, yearly profit, monthly sales, customer profitability, and category analysis.
5. Use the findings to understand the business performance.

👨‍💻 Author

Shubham Kumar
Aspiring Data Analyst | Microsoft Excel | SQL | Python | Power BI

⭐ Acknowledgment

This project was created as part of my data analytics learning journey to develop practical skills in sales analysis, reporting, and business intelligence.

If you find this project useful, consider giving the repository a star!