Best Practice Analysis
Best Practice Analyzer Report
Analyze
Overview
Features
Prompts
Troubleshooting
Key Features
You export BPA results from Tabular Editor and get a CSV with dozens of violations — some critical, some informational, all listed the same way. Cross-referencing each finding against Microsoft's 71-rule catalog, figuring out severity, and prioritizing what to fix first takes an afternoon. This skill parses your export, matches every rule, sorts by severity, and generates a structured report in under a minute.
How it works
Loads Microsoft's full 71-rule BPA catalog (auto-downloads if missing)
Parses your Tabular Editor CSV export
Matches every rule — violated rules get flagged with severity, passed rules get confirmed
Sorts findings by severity (Critical > Warning > Informational) then by object count
Generates a summary with total rules evaluated, violations found, and objects affected
What you get
Full report (.md) — every violation with all affected objects listed
Compact report (.md) — max 3 objects per rule with overflow counts, ready for stakeholder review
Structured data (.json) — machine-readable output for further automation
All files follow consistent naming: {project}_bpa_analysis_{date}_{time}.md
Explore more in this category
Bookmark Analysis
Analyze
Simulate bookmark navigation, detect visual leaks, and fix show/hide issues across bookmark chains.
Color Analysis
Analyze
Extract every color assignment across all visuals, resolve theme colors to hex, and flag discrepancies.
Interactions Matrix
Analyze
Generate, edit, and compare visual interaction matrices showing who affects whom on each page.
Measure Killer Analysis
Analyze
Identify unused measures, DAX complexity issues, and dependency health across your entire model.