This project showcases an interactive Sales Dashboard built using Microsoft Excel. The dataset includes information about customer orders, sales, product categories, states, and profits.
The goal of the dashboard is to analyze sales performance, customer behavior, and product insights through visual and interactive elements.
- 🔹 Total Sales and Total Profit
- 🔹 Profit by Year
- 🔹 Sales Trend by Month
- 🔹 Top 5 Customers by Profit
- 🔹 Sales by Category
- 🔹 Sales by State
- 🔹 Customer Count
- 🔹 Interactive Slicers (Category, Year, Month)
- Data Cleaning and Preparation
- Pivot Tables & Pivot Charts
- Slicers for Interactive Filtering
- Data Visualization in Excel
- Business Insight Extraction
- Dashboard Design Principles
- Best-performing categories and regions
- Monthly and yearly sales trends
- High-value customers contributing most to profit
- Profitability distribution across the states
- Microsoft Excel
- Pivot Tables / Charts
- Slicers
- Data Visualization Techniques
Working on this project helped me:
- Enhance my Excel data analysis and dashboarding skills
- Translate raw data into meaningful business insights
- Design clean and interactive reports for non-technical users
