An interactive Excel dashboard designed to uncover key sales drivers and improve business profitability.
This project demonstrates my ability to turn raw data into clear, actionable insights that drive business decisions.
The goal of this project is to explore sales data and uncover key factors affecting revenue and profit, helping businesses make data-driven decisions.
- Microsoft Excel
- Pivot Tables
- Slicers
- Data Visualization
- High discounts are the primary driver of profit loss, directly impacting overall business performance.
- A small number of categories drive the majority of revenue, indicating concentration risk.
- Profitability varies across segments, highlighting opportunities for optimization.
This analysis helps businesses identify profit leaks and optimize pricing strategies to maximize revenue.
- Reduce excessive discounting to improve profit margins.
- Focus on high-performing and profitable product categories.
- Optimize pricing strategies based on product performance.