A dynamic and metrics-driven Excel dashboard designed to analyze retail product performance, revenue growth, and profit margins, with a special focus on the impact of discounts on overall profitability.
Key Metrics Tracked (KPIs with Growth Trends):
Total Sales: $2.30M (with a positive trend indicator).
Total Profit: $286.40K (highlighting net business earnings).
Total Quantity Sold: 37.87K units.
Average Discount Rate: 15.62% (monitoring promotional impacts).
Visualizations & Insights Included:
Sales by Sub-Category: A detailed horizontal bar chart tracking revenue across diverse product segments (including Chairs, Phones, Storage, Tables, Binders, Accessories, and Copiers).
Monthly Sales & Profit Trends: A dual-axis combo chart (Line and Column) showing the month-over-month relationship between gross sales and net profit to identify seasonal peaks.
Segment Sales Distribution: A clean pie chart breakdown illustrating revenue shares from different market segments (Consumer, Corporate, and Home Office).
Regional & Category Sales: Analytical visual elements segmenting performance across geographical regions (Central, East, South, West) and main categories (Technology, Furniture, Office Supplies).
Technical Features:
Built with an advanced analytical structure combining custom KPI trend signals.
Fully interactive interface with automated data visualization workflows.
Clean, executive white-and-blue theme designed for retail managers and business development teams to optimize pricing and discount strategies
