🚨 $2.04M in revenue. 6,000

🚨 $2.04M in revenue. 6,000 orders. But what’s really happening inside the business? I recently completed a simulated e-commerce analytics case study focused on commercial performance and operations. The objective was simple: Turn transactional data into a clear decision-making tool for management. Using Power BI, SQL & Excel, I analyzed the business across revenue, products, orders, customers, fulfillment and operational performance. And the analysis uncovered several issues that could easily be missed in a traditional spreadsheet: 🔴 Revenue concentration: Electronics generated $1.1M+, while Laptop Pro 15 dominated product revenue creating significant dependency on a single category and product. 📉 Revenue decline: Monthly revenue peaked at $89.8K in February 2025 before trending downward through the latest 2026 periods. ⚠️ Order attrition: 6.91% cancellations + 3.76% refunds = 10.67% of placed orders not retained as completed sales. ⭐ Customer experience: 74% of rated orders received 4–5 stars, but roughly 1 in 4 ratings were 3 stars or below. 🚚 Operations: Average delivery time was 5.07 days, with only a 0.4-day spread across major cities suggesting delivery consistency was not the most pressing issue. 📊 The solution I built a 2-page Commercial & Operational Performance Dashboard: Page 1 — Commercial Performance Revenue • Orders • AOV • Units • Monthly Trends • Category & Product Performance • Acquisition Channels Page 2 — Logistics & Operations Delivery Performance • Cancellations & Refunds • Customer Ratings • Payment Method & Order Status But the dashboard doesn't just display what happened. It creates a single view of where performance is strong, where revenue may be at risk, and which areas require deeper investigation. Management can quickly identify: • Where revenue is concentrated • Where sales are being lost • Which products and channels are performing • Whether operational performance is becoming a concern • Where further investigation should be prioritized • That's the real value of business analytics: Turning data into clarity for better decisions. I'm building my expertise as an E-commerce & Operations Data Analyst, helping businesses use their data to understand performance, identify risks and make better operational decisions. If your business has data but you're not getting clear answers from it, let's change that. 📩 DM me “ANALYZE” and let's discuss what your data could uncover.