Sales Performance Dashboard – Superstore
Profit Margin & Regional Retail Analysis Across 10,000 Transactions (2014–2017)
Business Problem & Objectives
A US retail chain generated high top-line revenue growth across four geographic regions but experienced unexplained margin erosion in specific product categories. The leadership team needed an interactive executive dashboard to identify where revenue was unprofitable and evaluate discounting impact.
Dataset Overview
Kaggle Superstore Sales Dataset comprising approximately 9,994 transactional order records spanning 4 calendar years (2014–2017) across 3 product categories (Furniture, Office Supplies, Technology) and 17 sub-categories.
Data Preparation & Cleaning Steps
- Ingested 9,994 transaction rows into Google Sheets for data cleaning and schema validation.
- Handled missing shipping values and converted raw date strings to standardized ISO Date formats.
- Engineered calculated fields: Profit Margin % = (Profit / Sales) * 100, Order Processing Lead Time = Ship Date - Order Date.
- Created year-over-year and month-over-month aggregation flags for time-series evaluation.
Analytical Methodology & Core Insights
Methodology Framework
- •Category & Sub-Category Profitability Matrix: Evaluated sales volume vs net profit margin percentage.
- •Geographic Heatmap Analysis: Mapped revenue and margin distribution across US States and Regions (East, West, Central, South).
- •Discount Elasticity Inspection: Analyzed how aggressive promotional discounts (>20%) affected gross margins in Furniture sub-categories.
Analysis Highlights
- •Top-Line vs Bottom-Line Divergence: Technology generated the highest total profit margin (~17.4%), while Furniture suffered from severe margin compression (~2.4%).
- •Sub-Category Loss Leader: Tables and Bookcases consistently operated at a net loss due to excessive discounting (>30%) and high shipping costs.
- •Regional Disparity: The Central region recorded the lowest net profit margin despite generating comparable sales volume to the South.
Key Findings
- Furniture discounting trap: Discounts over 20% on Furniture items consistently yielded negative profit margins.
- Office Supplies stability: Office Supplies generated steady cash flow with over 60% of total order transactions.
- Seasonal peak: Q4 (Nov-Dec) accounts for over 32% of annual sales revenue due to holiday retail demand.
Business Recommendations
- Cap promotional discounts: Restrict maximum allowable discounts on Furniture sub-categories (Tables & Bookcases) to 15%.
- Re-negotiate Central shipping rates: Audit logistics suppliers in Central region to eliminate freight cost overruns.
- Cross-sell Technology accessories: Bundle high-margin Technology items with high-volume Office Supplies.
Related Case Studies
Nepal Tourism Industry Analysis
End-to-end business analytics project analyzing Nepal's international tourist arrivals, revenue patterns, and post-pandemic recovery using official government statistics.
Market AnalysisEcotourism Market Analysis 2025
Business analysis case study investigating why 84% of travelers express demand for sustainable travel but only 33% book it, identifying trust barriers and pricing myths.