✨ Executive Summary

This case study presents an interactive Excel dashboard built on the Superstore dataset (~10,000 transactions, $2.3M in sales, $286K in profit) to monitor performance across regions, product categories, and customer segments.

The dashboard consolidates key metrics — Total Sales, Profit, Quantity Sold, and Profit Margin — into a single view, enabling business teams to track performance and make data‑driven decisions.

Analysis revealed that:

• West and East regions generate the highest sales, but profitability varies by region.
• Technology drives the most revenue, while Furniture struggles with profitability due to heavy discounting.
• Discounts above 30% often result in negative profit margins.
• A small group of top customers and products contribute disproportionately to overall sales.

These insights provide a roadmap for improving profitability through smarter discounting, regional strategy, and targeted customer retention programs.

📌 Project Overview

This project demonstrates how Excel can be used to transform raw transactional data into a business‑ready dashboard that supports decision‑making. The dashboard enables sales managers to monitor KPIs in real time, identify underperforming regions, and optimize discounting strategies.

• Domain: Retail & Sales Analytics
• Dataset: Superstore Sales (~10,000 transactions with fields for Order Date, Region, Category, Sub‑Category, Sales, Profit, Quantity, Discount, Customer, and Product)
• Tools Used: Excel (Pivot Tables, Pivot Charts, Slicers, Conditional Formatting, Formulas)
• Deliverables: Clean dataset, interactive Excel dashboard, executive summary, dashboard screenshots, and optional slide deck

Scope: The dashboard provides a consolidated view of sales performance across multiple dimensions (time, region, product, customer).

❓ Business Question