---

💼 The Business Problem

A US Superstore is generating high revenue but facing critical margin pressure. Traditional analysis looks at Sales, but this project engineers financial metrics to find the True Profit.

🚨 Problem	💡 Solution Engineered	🎯 Goal
Negative Margins	Calculated COGS (Cost of Goods Sold) to identify products costing more than they earn.	Stop bleeding cash on bad products.
Discount Traps	Correlated Discount % vs Profit to find the exact "tipping point" where deals become losses.	Optimize pricing strategy.
Regional Bloat	Segmented performance by Region to find areas with high volume but low ROI.	Fix supply chain inefficiencies.

---

🧩 System Architecture

Stucture/flow The data flows through a structured BI pipeline:

graph LR
    A[Raw Transaction Data] -->|Pandas| B(Data Cleaning & Audit)
    B --> C{Feature Engineering}
    C -->|Calculate| D[COGS & Margin %]
    C -->|Extract| E[Temporal Trends]
    D --> F[Visual Analysis]
    E --> F
    F --> G[Strategic Report]
    style C fill:#363795,stroke:#005C97,stroke-width:2px,color:#fff
    style G fill:#005C97,stroke:#363795,stroke-width:2px,color:#fff

Loading