Microsoft sample · a retail chain

Store Sales

The same retail data as Retail Analysis, modelled differently: store and district sales, this year against last year.

tables
7
columns
69
measures
32
pages
3
visuals
13
BPA findings
159
AI Readiness Score
68%
trailsbi "D:\Reports\Store Sales Sample"

What TrailsBI found

  • Unused

    ClusterMappingTable 2 is a calculated table that nothing on any page uses. Along with it, 18 measures and 45 columns are unused.

  • Warning

    Sales[ReportingPeriodID] → Fiscal calendar is inactive and no measure activates it with USERELATIONSHIP.

  • Warning

    The Date table is calculated but not marked as a date table, which affects time-intelligence functions.

Every view, on this model

Store Sales 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.
Store Sales in TrailsBI: Lineage · Detailed View
Lineage · Detailed View. Trace any item from source to visual. Total Sales Var selected: [Sales TY]-[Sales LY], with 10 items feeding it and 20 depending on it. The Details panel lists everything upstream and downstream.
Store Sales 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. Sales TY selected: it reaches 13 visuals on 3 pages, in teal, and what it depends on shows in navy.
Store Sales 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.
Store Sales in TrailsBI: Model · Diagram View
Model · Diagram View. Relationships laid out automatically. Sales selected: its 4 relationships light up and the Details panel lists its columns and relationships. The inactive relationship to Fiscal calendar is dashed. Sales[ReportingPeriodID] relates to both Date and Fiscal calendar.
Store Sales in TrailsBI: Reports View
Reports View. Pages, canvas layout and filters. Three report pages and the fields behind each visual.
Store Sales in TrailsBI: Health
Health. Best Practice Analyzer and lineage checks. 141 warnings, mostly unused measures and columns that could be removed to slim the model.
Store Sales in TrailsBI: AI Readiness
AI Readiness. How ready the model is for Copilot. AI Readiness Score at 68%, the best of the five samples.
Store Sales 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.