Power BI dashboards for e-commerce
An e-commerce dashboard shows how online revenue is trending, where shoppers leave the site, and whether orders ship on time and come back. Three screens cover the online channel. We build them on your own store and order data.
Request the sample pack
What it answers
Three questions every online team is asked
Each screen starts from a question. The figures show where to fix the site, the delivery promise and the returns process first.
- How is online revenue trending?Online revenue, orders, average order value, conversion rate and cart abandonment, with conversion by month and revenue by device.
- Where do shoppers leave the site?Sessions, add-to-cart rate, checkout completion and page load time, with a session-to-order funnel and conversion by device.
- Are orders shipping on time, and why are they returned?On-time delivery, average delivery time, return rate and refunds issued, with returns by reason and category.
The screens
Power BI e-commerce screens
Three screens for the online team. Open one to see it full size. Each comes with filters and drill-through, and we adjust measures, filters and branding to your business.
3 dashboards
Every number on these screens is sample data from a fictional retailer. No client data is shown. Your own logo replaces the AscenWork mark at the top left of each report.
How we define the main e-commerce measures
A dashboard is only trusted if everyone reads the same number. We agree these definitions with you before we build, and write them down at handover.
| Measure | How we calculate it | What to agree first |
|---|---|---|
| Conversion rate | Orders divided by sessions for the period. | Whether repeat sessions from the same visitor are counted once. |
| Average order value | Online revenue divided by the number of orders. | Whether shipping and taxes are included. |
| Cart abandonment | Carts not converted to orders, divided by carts created. | The time window that closes a cart. |
| Return rate | Returned orders divided by orders shipped. | Whether partial returns count as returned orders. |
| On-time delivery | Orders delivered by the promised date, divided by orders shipped. | The promise used, such as the date shown at checkout. |
How it works
From these screens to your live dashboard
In a project, the dashboard connects to your store and order data and refreshes on a schedule. You see working pages early, so you react to something real.
Connect
We link your systems and files, and check the data is complete.
Model
We clean and join the data, and agree each measure with you so everyone reads the same number.
Design
We apply your chosen look and your logo to every page, with a phone layout where it is needed.
Go live
The dashboard runs in Power BI with scheduled refresh, filters, drill-through and access by role.
What we connect
Where the data for these dashboards comes from
We confirm the sources on a short scoping call. These are the common ones for this dashboard.
E-commerce platform
Orders, sessions and carts from your store platform, such as Shopify, Magento or a custom store.
Web analytics
Traffic sources, device data and page load times from your analytics tool.
Order management and carriers
Dispatch and delivery dates from your order system or carrier feeds.
Returns and refunds
Return reasons and refund records from your returns process.
Product catalogue
Products, categories and prices, so returns and sales are grouped correctly.
Our Power BI work
These screens are one part of what we do on Power BI
The same team builds the data model behind the dashboard, designs the report and keeps it running. Pick the part you need.
Power BI development
Data connections, model, measures, row-level security and scheduled refresh, built in your Power BI.
Power BI consulting
A review of your current reports and data, and a plan before you build.
Power BI designing
Clear, fast report design with a consistent look across every page.
Copilot and AI for Power BI
Ask questions of your data in plain language, with the right guardrails.
Case studies
Power BI projects we have delivered
Power BI job life cycle, exception and debtors reports for a freight forwarder
A set of Power BI reports for a freight forwarding and customs clearing company with many branches. They follow every job from creation to closure and flag exceptions, pending billing, debtors and profit.
A freight forwarding and customs clearing company with many branches and a finance team at head office
Read the case study →Power BI · Energy and renewables
Power BI asset performance dashboards for a renewable energy portfolio
A Power BI report that follows generation, losses, breakdowns and module cleaning across every solar plant in a portfolio, from an executive summary down to the inverter.
A renewable energy company operating several solar plants
Read the case study →Power BI · Retail and consumer goods
Power BI sales dashboards for digital channels and prescription sales
Two Power BI reports that bring sales data from every channel into one view. Digital sales covers partners, marketplaces, website and products, and Rx sales covers prescribers, zones, brands and field teams.
A skincare company selling through digital partners, its own website and prescription channels
Read the case study →Trusted by teams at
Power BI e-commerce dashboard questions
What should an e-commerce dashboard show?
Online revenue, conversion, average order value, cart abandonment and the checkout funnel, plus on-time delivery and return rate. Start with the decisions your online team takes each week.
Can it connect to our store platform?
Usually yes. Common store platforms export orders and sessions, and Power BI connects to them directly or through a database. We confirm the route for your platform on a scoping call.
Can we see returns by product?
Yes. Returns can be shown by reason, category and product, so the team can find the lines that come back most often.
Is the sample pack free?
Yes. The design pack is free, and we email it to you as a PDF. Building dashboards on your own data is a scoped, paid engagement, which we quote after a discovery call.
How do we get a price and a timeline?
Book a free call. We learn your data sources, users and questions, then send a proposal with the scope, the assumptions and the price. Timelines depend on the number of sources and dashboards.
Related
More from our Power BI work
All dashboard templates
Fifteen dashboards by function and industry
Sales and marketing dashboards
Target, pipeline, ROAS and funnel
Merchandising dashboards
Range, pricing and discounts
Customer experience dashboards
NPS, cases and resolution
Power BI development
Build a dashboard on your own data
Power BI consulting
Review and plan before you build
Power BI designing
Clear, fast report design
Hire Power BI developers
Developers who join your team
Contact