The challenge
The client, a growing e-commerce marketplace, had revenue, order, seller, and customer data spread across disconnected exports and spreadsheets. Finance tracked revenue in one file, operations tracked orders and sellers in another, and nobody had a single place to see state-level performance or customer satisfaction trends together.
Before every leadership review, an analyst spent hours manually pulling numbers from multiple sources, reconciling totals, and rebuilding the same charts from scratch — with no guarantee the figures across teams would even match.
The solution
Vizontra built a live Power BI dashboard that connects customer, order, and seller data into a single semantic model, with DAX measures driving revenue trends, top product categories, state-level performance, and average customer ratings from one shared source of truth.
The layout was designed as a control-room view: top-line KPIs across the top, a monthly revenue trend and top-5 product category breakdown in the middle, and a state-by-state orders and revenue table alongside delivery-day and payment insights — everything the leadership team needs before making a call, in one screen.
Results
- $15.8M in tracked revenue across 99K orders visualized in one live view
- 96K customers segmented across 27 states with city-level breakdowns
- Manual reporting prep reduced from hours to a single filtered click
- Real-time visibility into top 5 product categories and best-selling items
- Delivery status and payment-method insight built directly into the same dashboard
- Replaced static spreadsheet exports with one dashboard the team checks weekly