PBI Analyzer

PBI Analyzer processes a Power BI data model description (tables, relationships, and measures) and computes a set of health metrics. It identifies heavy DAX measures by measuring nesting depth, function calls, and cross-filter complexities; it estimates memory footprint given row counts and column data types. It highlights star schema opportunities, ambiguous relationships, and inefficient bidirectional filters.
Conceptually, it treats the model as a graph of objects and dependencies, then runs lightweight analyses to avoid reading actual data content. It does not execute reports; instead it uses schema metadata and representative workloads to generate risk scores and suggested changes. Outputs are designed for BI developers and governance teams to prioritize optimizations.
Use cases include post-refresh assessments, design reviews, and ongoing optimization programs. Unique value comes from combining DAX complexity analysis, dependency graph insights, and memory footprint estimation to produce actionable recommendations that stay close to the model's structure. Core features include a dependency graph, complexity scoring, memory estimation, risk scoring, and exportable reports.