Analyze sales performance, understand discount impact, and surface actionable insights — all in Excel.
- Cleaned and enriched ~10K Superstore records (30 fields)
- Interactive Excel dashboard with slicers & KPIs
- Pivot Tables/Charts, What-If Analysis (Scenario Manager & Goal Seek)
- Lightweight macro automation
- Executive presentation with insights and recommendations
Why: Identify sales trends, evaluate channels, and recommend improvements.
Goals:
- Trend analysis across time, category, region, and segment
- Measure discount impact on revenue & profit
- Highlight top products/channels and seasonality
- Deliver an interactive dashboard for quick decision-making
Dataset: ~9,996 rows × 30 columns (Order ID, Customer ID, Product ID, Category, Sub-Category, Sales, Quantity, Discount, Profit, …)
- Removed duplicates; fixed date types for Order/Ship dates
- Added helper columns:
Year,Month,Quarter,Weekday,End_of_Month - Calculated fields:
Adjusted_Sales = Sales × (1 – Discount)- Validation checks for Sales & Discount consistency
- Shipping: Standard Class generated the highest revenue (~₹1.16M)
- Categories: Technology (~₹713K) and Office Supplies (~₹642K) led performance
- Discounts: Net revenue down by ~₹322K due to high/blanket discounting
- Seasonality: Clear Q4 peaks each year (holiday demand)
- Focus on Technology & Office Supplies to maximize revenue
- Replace blanket discounts with targeted promotions
- Keep Standard Class strong; promote premium shipping via loyalty incentives
- Align inventory & campaigns to Q4 peaks
- Monitor Consumer segment (high revenue, but pressured margins)
- Microsoft Excel: Power Query, Pivot Tables/Charts, Slicers, What-If Analysis, Macros
- PowerPoint: Executive summary & storytelling
- Open
Superstores Analysis.xlsx - Explore the Dashboard sheet (use slicers to filter by categories/segments/regions)
- Review the PPT/PDF for a crisp summary of findings
💫 If you liked this project, please consider giving it a ⭐ on GitHub! 💫
It helps others discover the project and keeps me motivated to share more work.