This project identifies $660K in direct profit leakage within a global ecommerce dataset. I developed a diagnostic Power BI dashboard to simulate a 15% Margin Floor policy, allowing executives to pinpoint exactly where high discounting is killing profitability.
- SQL: Cleaned and transformed raw sales data; built complex queries to calculate regional profit margins.
- Power BI: Engineered a dynamic dashboard using DAX, What-If Parameters, and Conditional Formatting.
- GitHub: Maintained a professional repository structure for stakeholder transparency.
| Folder | Description |
|---|---|
| 📂 01_DATA | Raw and processed CSV datasets. |
| 📂 02_SQL_SCRIPTS | Data cleaning and transformation scripts. |
| 📂 03_SQL_REPORTS | Queries for business logic and margin calculations. |
| 📂 04_DASHBOARD | Power BI (.pbix) files and visual exports. |
| 📂 05_RECOMMENDATION | Final business insights and recovery strategies. |
- Identified $659.82K in losses originating from products performing below the strategic 15% margin threshold.
- Created a "Risk Indicator" KPI card that dynamically updates based on policy changes.
- Discovered a direct correlation between high discounting (>20%) and negative profit in the Furniture category.
- Visualized outlier products that are "Profit Villains" using scatter plot trend lines.
- Built a Target Margin Slider that allows managers to simulate the impact of different profit floors on the bottom line.
- Automated Red-Flag Highlighting in the product table for immediate executive action.
- Policy Change: Recommended a hard floor of 15% margin for the Furniture segment to recover $200K+ annually.
- Discount Control: Proposed a tiered discount structure to prevent margin erosion on high-volume items.