This project presents an interactive Sales Performance Dashboard developed in Microsoft Excel to analyze the performance of sales executives across different regions. The dashboard helps monitor sales performance, compare actual sales against targets, and identify top and bottom performers through dynamic visualizations and KPI tracking.
- Analyze sales performance of each sales executive.
- Compare actual sales with assigned targets.
- Measure target achievement percentage.
- Identify executives who exceeded or missed their targets.
- Analyze sales performance by region.
- Create an interactive dashboard for business decision-making.
The dataset contains sales information for multiple sales executives.
- Emp Code
- Sales Executive
- Region
- Day1
- Day2
- Day3
- Day4
- Day5
- Total Sales
- Target
- Target Hit %
- Away From Target %
- KPI Cards
- Sales by Region
- Sales by Executive
- Target vs Actual Sales
- Target Achievement %
- Top Performers
- Interactive Slicers
- Dynamic Charts
- Microsoft Excel
- Pivot Tables
- Pivot Charts
- Slicers
- Conditional Formatting
- Data Validation
- Data Visualization
- Total Sales
- Total Target
- Target Achievement %
- Average Sales
- Number of Sales Executives
- Identify high-performing sales executives.
- Track regional sales performance.
- Compare sales against business targets.
- Monitor overall sales trends.
- Support data-driven business decisions.
Preview Of Dashboard
Muhammad Shah
Aspiring Data Analyst
Skills:
- Excel
- SQL
- Python
- Power BI
- Statistics