A full-stack analytics pipeline (Excel → SQL → Python → Power BI) analyzing $12.64M revenue data to uncover profit leakage, customer concentration risks, and pricing inefficiencies.
This project investigates a critical business problem:
Why is profit declining despite strong sales growth?
Using an end-to-end analytics approach, the analysis identifies hidden drivers of profitability, customer behavior patterns, and operational inefficiencies to support data-driven decision-making.
- Total Revenue: $12.64M
- Total Profit: $1.47M
- Profit Margin: ~12%
- Data Scope: Sales, Customers, Products, Regions, Discounts
- Data Quality: Cleaned & validated dataset (>98% consistency)
- Excel: Data cleaning & preprocessing
- SQL: Data extraction, joins, aggregations
- Python: EDA, correlation & trend analysis
- Power BI: Interactive dashboards & executive reporting
- Revenue vs Profit Gap: High sales but low margin (~12%)
- Discount Threshold Impact: Profit drops significantly beyond ~20% discount
- Top Customer Revenue: $40K+ per customer
- Regional Performance Leader: Western Europe
- Weak Regions: Oceania & South Europe (low/negative margins)
- Strong revenue ($12.64M) but relatively low profit ($1.47M)
- Confirms: Sales growth ≠ profitability
- Furniture category shows high sales but low/negative profit
- Indicates:
- High costs
- Inefficient pricing strategy
- Discounts above ~20% lead to sharp margin decline
- Clear evidence of discount-driven profit erosion
- Top customers generate $40K+ each
- Revenue heavily dependent on a small customer segment
- Creates:
- Retention risk
- Revenue volatility
- Top Region: Western Europe → highest revenue & profit
- Weak Regions: Oceania & South Europe → low/negative margins
- Suggests need for:
- Regional pricing optimization
- Cost control strategies
- Most Profitable Product: Canon imageCLASS 2200
- Loss-Making Products:
- Belkin Router
- Cubify 3D Printer
- Highlights portfolio imbalance
⚠️ Hidden Cost Drivers
- Discounts + shipping methods contribute to invisible profit loss
- Operational inefficiencies impact bottom line
- Profitability depends on pricing, cost control, not just sales volume
- Business exposed to customer and product concentration risk
- Discounting strategy directly impacts margin sustainability
- Regional inefficiencies affect overall performance
- Recommended discount control & pricing optimization strategies
- Identified high-value customers for retention focus
- Highlighted profitable vs loss-making products for portfolio decisions
- Delivered executive dashboards enabling real-time decision-making
This project demonstrates how an end-to-end analytics pipeline can transform raw business data into actionable insights, uncover hidden profit leaks, and support sustainable growth strategies.
- Name: [M Usman Javed]
- LinkedIn: [https://www.linkedin.com/in/muhammad-usman-javed-51769b3a9/?skipRedirect=true]