Skip to content
KadmoonINC.
Retail

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.

Microsoft FabricOneLakeDirect LakePower BI
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

Commercial Results · Omnichannel Networkgold_vendas_v3 · Direct LakeRefreshed 07/08 06:12Illustrative data
Report pages
Filters
Period
MTD · Aug/2026
Channel
All channels
Banner
All
Hierarchy
Region
Store
SKU
Region · consolidated
Net sales+6.2% LY
$18.42M
MTD, net of returns
Gross margin-0.4 p.p.
27.8%
with logistics allocation
Stockout-1.3 p.p.
4.1%
SKU-store out of stock at the POS
Average ticket+2.8%
$84.20
consolidated omnichannel receipt
Receipts in period
218.4K
Items per receipt
6.4
Returns
1.8%
Stock cover
22 days

Daily net sales

Brick-and-mortar, app, marketplace and telesales consolidated

20262025
$803K$686K$573K$460K
0104071013161922252831

Net sales by region

Click to open store by store

Southeast concentrates 44% of sales and 51% of perishable stockouts.

SKUs in the slice

SKU-store-day granularity, served over Direct Lake

8 of 160 rows
SKU
Category
Net sales
Margin
Stockout
Turnover
Stock
78925655 · Mozzarella cheese kgSP · Store 042 Morumbi
Perishables
$25K
34.9%
8.5%
26 d
1,684
78907417 · Fabric softener 2LSP · Store 042 Morumbi
Cleaning
$27K
30.9%
1.2%
15 d
354
78995511 · Soda 2LPR · Store 311 Batel
Beverages
$10K
32.7%
1.2%
13 d
1,324
78937676 · Frozen chicken kgPR · Store 311 Batel
Perishables
$10K
20.6%
4.1%
14 d
230
78914527 · Frozen chicken kgPE · Store 412 Boa Viagem
Perishables
$4K
36.3%
1.0%
4 d
732
78969142 · Fabric softener 2LPE · Store 412 Boa Viagem
Cleaning
$9K
18.6%
8.5%
24 d
1,434
78906695 · Mozzarella cheese kgDF · Store 501 Asa Sul
Perishables
$5K
29.5%
6.1%
29 d
781
78941373 · Diapers M 40ctDF · Store 501 Asa Sul
Personal care
$6K
21.1%
5.1%
17 d
983

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

More case studies