A single source of truth on Microsoft Fabric
Sales, inventory, and margin from stores and e-commerce consolidated in OneLake and served to Power BI through Direct Lake.
- Net sales
- $18.42M
- MTD, net of returns
- Gross margin
- 27.8%
- with logistics allocation
- Stockout
- 4.1%
- SKU-store out of stock at the POS
- Average ticket
- $84.20
- consolidated omnichannel receipt
Illustrative figures · fictitious client · under NDA
The challenge
An omnichannel retailer had three versions of the truth, with sales, inventory, and margin living in separate systems for physical stores and e-commerce, so no report agreed.
What we built
We consolidated the sources into OneLake on Microsoft Fabric and served Power BI through Direct Lake, so store and online data meet on one governed model with fast reports.
- A consolidated data platform in OneLake on Microsoft Fabric.
- A governed model unifying store and e-commerce sales, inventory, and margin.
- Power BI on Direct Lake for fast reports without a copy step.
Outcomes
- One source of truth in place of three conflicting ones.
- Store and online performance on the same page.
- Reports that stay fast as data grows.
The dashboard we delivered
Daily net sales
Brick-and-mortar, app, marketplace and telesales consolidated
Net sales by region
Click to open store by store
SKUs in the slice
SKU-store-day granularity, served over Direct Lake
Illustrative dashboard with the structure delivered on the project. Client names and figures are fictitious and under NDA.
Want a dashboard like this on your data?
Tell us your scenario and get a diagnosis and a proposal with an investment range within a few business days.
Start a project