CertyFAST v1.2.0

CertyFAST by MAQ Software v1.2.0

Streamlining Power BI model development with automated error detection, DAX measure formatting, and simplified documentation, impact analysis on premium capacity utilization, ensuring top-notch quality and adherence to best practices in enterprises.

Change Log

1. New Capability - CPU Statistics
2. New Insight Rules - Variable Suggestions and Visual Formatting Inconsistency
3. Suppress Insights Errors/Warning
4. Insights Rule Information - Description, Resolution Steps and Impact Area
5. Enhanced PBIR support for report analysis

New Features:

1. CPU Statistics

   1. Feature Details

      1. Pinpoints Performance Bottlenecks: Identifies visuals or pages consuming the highest amount of Server Engine (SE) CPU and executing the maximum number of SE queries.
      2. Provides Granular Performance Insights: Offers detailed SE CPU and query metrics for each individual visual, allowing for in-depth analysis. Enables the download of logs containing specific internal SE queries for targeted optimization efforts.
      3. Prioritizes Optimization Efforts: Streamlines the process for developers and performance review teams to identify and focus on the most impactful visuals for optimization.
      4. Assesses Capacity Impact: Evaluates the influence of report loading on premium capacity utilization, aiding in resource allocation and capacity planning.

      

   2. Steps to get started

      1. Turn on Performance Analyzer in the Power BI Report File
      2. Start Recording and refresh visuals on all the pages of the report
      3. Export performance analyzer data in JSON format
      4. Upload the exported JSON file on CPU Statistics page

   3. Prerequisites

      1. Semantic Model Analysis using PBIX file or XMLA Endpoint connection only
      2. Report UI reference using any of the report analysis file types

2. Insights Enhancements

   1. New Rule - Use Variables: Identifies and highlights redundant DAX expressions that can be optimized by converting them into variables. These expressions, marked in red for easy visibility, can significantly improve report performance by reducing calculation time and memory usage.

      

   2. New Rule - Consistent Visual Formatting: Identifies and flags inconsistencies in visual properties (font, color, size) across common elements (titles, borders, and labels) within various visualizations. Provides insights into the frequency and location of these inconsistencies using locator icon, enabling users to quickly identify and address issues that may impact user experience and professionalism of the report.

      

   3. Suppress Insights: Provides developers with the flexibility to dismiss specific insights categorized as errors or warnings that cannot be immediately resolved due to business or technical limitations. Users can document the rationale for disregarding these insights, and this justification will be preserved and presented in all exported reports. Ignored items are persistently stored for future analyses of the same report on the same machine.

      

      

   4. Rule Information: Offers detailed explanations for each rule to enhance user understanding of rule definitions, potential impacts, and recommended resolution steps. Rule type, impact area, and additional context are prominently displayed beneath the rule name within the insights section. Users can access comprehensive rule descriptions and resolution guidelines by clicking on the information icon adjacent to the rule name.

      

      

3. Support for additional file types

   1. Report UI Analysis - PBIR Folder: Select root folder containing report visualization definition stored in enhanced PBIR format. The folder needs to follow PBIR structure and folder name should follow the naming convention of ReportName.Report