Best Practice Analysis

Best Practice Analyzer Report

Analyze

Analyze

bpa-analysis

Overview

Features

Prompts

Help

Key Features

Tabular Editor's Best Practice Analyzer is great at finding issues, but the export it hands you is a flat list of violations — no sense of which ones matter, no grouping, no priority. Working out what's serious means cross-referencing each line against Microsoft's 71-rule catalog and sorting it by hand, and there goes your afternoon. This skill reads the export for you, matches every finding to its rule, ranks them by severity, and hands back a clean report — critical issues first, the small stuff last, ready to share — run it with /bpa-analysis.

How it works

Before you start — this skill reads a BPA export, so you make that in Tabular Editor first (the free Tabular Editor 2 works fine). Open your model in Tabular Editor, go to Tools → Manage BPA Rules, and add Microsoft's rule set with Include Rule File from URL — paste https://raw.githubusercontent.com/microsoft/Analysis-Services/master/BestPracticeRules/BPARules.json, then untick the other rule collections so only these run. Run Tools → Best Practice Analyzer, expand every rule (the expand-all control is at the top right), select all the rows (Ctrl+A) and copy them, paste into Excel, and Save As → CSV (UTF-8, comma or semicolon delimited). Put that CSV in inputs/bpa/, or just tell Claude where you saved it and it'll move it for you.

Then type /bpa-analysis, point it to your BPA export, and the skill handles everything:

  1. Loads Microsoft's full 71-rule BPA catalog (auto-downloads if missing)

  2. Parses your Tabular Editor CSV export

  3. Matches every rule — violated rules get flagged with severity, passed rules get confirmed

  4. Sorts findings by severity (Critical > Warning > Informational) then by object count

  5. 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) — up to 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

Tool Information

Skill

39 USD

Bundle (All skills)

129 USD

Category

Analyze

Version

Version 2.2.2.2

or log in if you already have an account