E-Commerce Sales & Profitability Dashboard

Overview

We have to analyze with two years of raw transaction data and a simple but important question: which parts of their business were actually making money, not just generating sales. We took that raw data and turned it into a single, interactive dashboard that let their team see, at a glance, which product categories and regions were driving real profit, whether their discounting strategy was working, and why returns were piling up in one particular category. What used to sit buried in spreadsheets became something their team could open every morning and actually use to make decisions.

Our analysis found that Electronics was generating the largest share of revenue but delivering the weakest profit margin of any category, meaning strong sales volume wasn't translating into real profit. Clothing stood out for a different reason: its return rate was nearly double the average across all other categories, a pattern typically driven by sizing and fit issues rather than product quality. We also found that discount levels were fairly consistent across the board, which ruled out heavy discounting as the cause of Electronics' weak margins and pointed instead to deeper pricing or cost issues within that category. On the marketing side, certain acquisition channels were consistently bringing in higher-value customers than others, a distinction the client hadn't been able to see clearly before this analysis.

Based on these findings, we recommended the client take a closer look at pricing and cost structure within their highest-revenue category, since fixing even a small margin gap there would have an outsized impact given its volume. We also suggested adding clearer sizing guidance to reduce return-driven losses in their highest-return category, shifting a portion of marketing budget toward the channels already proven to bring in higher-value customers, and pulling back investment from a category that was quietly operating at a loss. Together, these recommendations gave the client a clear, prioritized action plan instead of just a set of numbers to interpret on their own.

That's the value we bring to every client. Raw data on its own doesn't tell you anything — it takes the right questions, the right structure, and the right visuals to turn numbers into direction. Whether it's sales performance, customer behavior, marketing spend, or operational data, we build dashboards that don't just look good, but actually answer the questions, and give you a clear next step instead of just another report to read.

Note: For demonstration purposes, this dashboard is built on a synthetic dataset and does not represent real data.

Raw Data

The dataset contains 12,836 transaction line items across 6,500 orders, 1,451 customers, and 200 products, spanning January 2024 to December 2025, with 27 columns covering order details (ID, date, status, payment, marketing channel, delivery time), customer information (ID, name, demographics, segment, location), product details (ID, name, category, sub-category), and transaction financials (price, quantity, discount, revenue, cost, profit, rating).

Dashboard