27.7 Helpful Tools
| Tool | Use |
|---|---|
| Performance Analyzer (built-in) | Time per visual |
| DAX query view (built-in) | Run and test DAX queries |
| DAX Studio (free, community) | Query timings, server timings, VertiPaq Analyzer (size per column) |
| Tabular Editor (community/commercial) | Model editing, Best Practice Analyzer rules |
| Best Practice Analyzer / Memory Analyzer notebooks (Fabric) | Automated model checks |
Checklist before publishing
Unused columns removed · Auto date/time off · Star schema with single-direction relationships · Date table marked · Measures formatted and in folders · IDs hidden · Performance Analyzer shows no visual taking unusually long.
Ravindra Bagale's Tip
Mitrano, khup students install DAX Studio or Tabular Editor and make changes without a backup. Save a copy of your PBIX (or use PBIP with Git) before changing a model with external tools, and follow your organisation's rules on which tools are allowed. Chuk karu naka!
Thodkyaat sangaycha tar (quick recap)
Aadhi measure, mag fix; columns aani cardinality (दोन तक्त्यांतील ओळी किती-किती जुळतात याचे प्रमाण) kami kara; star schema theva; aani ekach page var khup visuals taaku naka. Aata pudhe jaauya – purna project karuya!