Sample Reports from Microsoft, explored using TrailsBI

Reports get generated completely offline. No cookies, no analytics or usage stats, nothing leaves your machine, ever!

TablesColumnsMeasuresPagesVisualsBPA findingsAI Readiness Score

Microsoft sample · VanArsdel Ltd

Competitive Marketing Analysis

A CMO's view of a fictitious manufacturer: market share, product volume, sales and sentiment against competitors.

trailsbi "D:\Reports\Competitive Marketing Analysis"

Error
A visual on Top 10 Regions sorts by Sales[Total Category Volume], which doesn't exist in the model. Power BI drops the sort silently; TrailsBI flags it.
Lineage
All 23 measures live in a Calculations table with one placeholder column. TrailsBI counts them as that table's own, so the table is never suggested for deletion.
Impact
Revenue is a one-line SUM, yet 10 measures and 12 items in total depend on it.

Microsoft sample · an HR department

New hires, active employees and separations, to spot trends in hiring strategy and potential bias.

trailsbi "D:\Reports\Human Resources Sample"

Error
7 measures reference columns without their table, for example ROUND(AVERAGE([Age]), 0).
Error
Year, Qtr, Day, MonthNumber and PeriodNumber are set to sum by default, so a visual can add up years.
Reports
The Info page has text and images but no data visuals. The Reports view shows that at a glance.

Microsoft sample · Contoso

A sales manager's view of which products and regions drive revenue, built on Dynamics 365 Sales data.

trailsbi "D:\Reports\Regional Sales Sample"

In Microsoft's file the Excel source sits in a personal OneDrive folder. For this demo only that address was changed, to contoso.sharepoint.com.

Error
A Key Influencers visual explains by Accounts[Industry], [Territory] and [Region]. None of those columns exist.
Error
A page filter uses Opportunities[Opportunity Owner Name], which is also missing from the model.
Impact
Revenue Won feeds 36 items: measures, visuals across 11 pages and the filters that use it.

Microsoft sample · a retail chain

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

trailsbi "D:\Reports\Retail Analysis Sample"

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.

Microsoft sample · a retail chain

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

trailsbi "D:\Reports\Store Sales Sample"

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.