Microsoft sample · VanArsdel Ltd
Competitive Marketing Analysis
A CMO's view of a fictitious manufacturer: market share, product volume, sales and sentiment against competitors.
- tables
- 9
- columns
- 52
- measures
- 23
- pages
- 5
- visuals
- 20
- BPA findings
- 128
- AI Readiness Score
- 48%
trailsbi "D:\Reports\Competitive Marketing Analysis"What TrailsBI found
- 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
Revenueis a one-lineSUM, yet 10 measures and 12 items in total depend on it.
Every view, on this model
Sales[Revenue] via one SQL source; teal lines show the 10 measures and the visuals built on it. The Details panel lists everything upstream and downstream.







