Ecommerce Revenue Analysis
Explore orders, returns, products and recorded gross margin.
The problem.
Revenue alone hides returns and differences between product costs.
Illustrative business scenario only. No real organisation, client result or confidential record is represented.
The process.
Use deterministic order inputs, separate returned orders and calculate margin only for products with recorded unit costs.
Synthetic input data
Inspect the source records and download the demonstration assets in the interactive workspace below. Transformations run locally in your browser.
The result.
Use the filters, inspect the records and compare the calculated outputs.
Data-quality notes & limitations.
Gross margin excludes delivery, payment fees, tax and overhead. Orders without cost data are excluded from margin and explicitly counted.
Findings are calculated from the selected synthetic records in the workspace above. They describe these inputs only and do not predict business outcomes. A real engagement requires agreed definitions, source checks and a factual review.
Need something like this?
Discuss your files, reporting goals and the decisions you need to support.