Microsoft sample · a retail chain

Retail Analysis

Sales across stores and districts, this year against last year, plus new store openings.

tables
5
columns
46
measures
32
pages
4
visuals
16
BPA findings
194
AI Readiness Score
42%
trailsbi "D:\Reports\Retail Analysis Sample"

What TrailsBI found

  • Impact

    TotalSales is just [Regular_Sales_Dollars]+[Markdown_Sales_Dollars], yet 15 measures and 29 items in total depend on it.

  • Error

    12 measures reference columns without their table, including Gross Margin This Year and Last Year.

  • Error

    StoreNumber and SellingAreaSize are set to sum, so a visual can add up store numbers.

Every view, on this model

Retail Analysis in TrailsBI: Lineage · Compact View
Lineage · Compact View. The whole model on one screen. All items in one picture, from data sources through tables, columns and measures to the visuals and pages that use them.
Retail Analysis in TrailsBI: Lineage · Detailed View
Lineage · Detailed View. Trace any item from source to visual. TotalSales selected: two Sales columns and two measures feed it; this-year and last-year sales, margins and averages are built on it. The Details panel lists everything upstream and downstream.
Retail Analysis in TrailsBI: Lineage · Graph View
Lineage · Graph View. The whole project in rings. Data sources in the middle, tables with their columns and measures around them, pages and their visuals on the outer ring. TotalSalesTY selected: it reaches 11 visuals on 3 pages, in teal, and what it depends on shows in navy.
Retail Analysis in TrailsBI: Model · Detail View
Model · Detail View. Every table, column and measure. Every table expanded with its columns, measures and hierarchies, keys and hidden objects marked. DAX is one click away and search narrows all of it as you type.
Retail Analysis in TrailsBI: Model · Diagram View
Model · Diagram View. Relationships laid out automatically. Sales selected: its 3 relationships light up and the Details panel lists its columns and relationships. Sales at the centre, filtered by Item, Store and Time, with District hanging off Store.
Retail Analysis in TrailsBI: Reports View
Reports View. Pages, canvas layout and filters. Four report pages, each visual listed with the fields it uses.
Retail Analysis in TrailsBI: Health
Health. Best Practice Analyzer and lineage checks. 19 errors, the most of the five samples, mostly unqualified column references and default summarisation.
Retail Analysis in TrailsBI: AI Readiness
AI Readiness. How ready the model is for Copilot. AI Readiness Score at 42%.
Retail Analysis in TrailsBI: Exported diagram
Exported diagram. Names visible, or hidden for sharing. The same diagram exported twice: names visible on the left, and on the right with table and column names hidden, safe to share outside the team.