Sales and e-commerce

Power BI · multichannel sales · online store · synthetic data

Business problem

The company sells through distributors and its own online store. Revenue is growing, but nobody knows which channels and products drive it, or whether the store brings in new customers or takes over existing ones.

Questions the report answers

How does revenue change by channel, product and region?
What are the conversion rate and average order value in the online store?
Which customers come back, and which buy only once?

Report

Interactive Power BI report. It loads when you click, so the page opens quickly.

The report runs on generated data that reflects real sales patterns. Best viewed on a computer.

What the data shows

[Finding 1]
[Finding 2]
[Finding 3]

Tools

Power BI: one star schema shared by all four reports
DAX: revenue period over period, conversion rate, average order value
Power Query: preparing and cleaning source data