CertyFAST by MAQ Software v1.4.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 – Copilot Readiness
2. Enhanced Capability – Accessibility Insights (checks for AA and ADA compliance)
3. Documentation Enhancements - Base Tables and Columns field for measures
4. CPU Enhancements - Optimizations and Bug Fixes

New Features:

Copilot Readiness

Feature Details: Unlock seamless Copilot enablement with intelligent readiness insights:

1. Copilot Readiness Checks: Instantly detects schema issues, ambiguous definitions, filter misuse, missing descriptions, and more.
2. Structured Analysis: Groups errors and warnings for easy prioritization.
3. Actionable Insights: Flags unused fields, hierarchy gaps, and naming inconsistencies to accelerate remediation.

Accessibility Insights (AA and ADA compliance check)

Feature Details: Enhance compliance and usability with advanced accessibility insights:

1. Expanded Ruleset: Broader compliance checks for WCAG and inclusive design standards.
2. Granular Reporting: Detailed error grouping with severity indicators for easy prioritization.
3. Comprehensive Coverage: Includes color palettes, contrast, structure, and ADA criteria.
4. Standards-Based Guidance: Recommendations aligned with industry best practices.

Documentation Enhancements

1. Enhanced Measure Documentation: Added a new column showing base columns used in each measure.
2. Improved Traceability: Quickly understand measure logic and dependencies at a glance

CPU Enhancements

1. Smooth Visual Experience: Prevents visuals from dropping due to heavy semantic queries.
2. Real-Time Feedback: Animated loaders indicate ongoing CPU stats fetch.
3. Clear Progress Indicators: Displays featched and total visuals to indicate overall progress.

CertyFAST by MAQ Software v1.3.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 – Scorecard
2. New Capability – Accessibility Insights
3. New Settings – Custom Scoring Mechanism and Max Score Definition
4. Lineage Enhancements - Properties Pane
5. Documentation Enhancements - Visual Field Categorization and Direct Lake models tables identification

New Features:

1. Scorecard

   1. Feature Details: Provides a consolidated compliance score for the selected model and report UI. Users can:

      1. View scores grouped by rule category or impact area
      2. Quickly assess overall adherence to best practices

      

   2. Custom Scoring Mechanism: Users can configure how each rule is scored via the settings page:

      1. Absolute Scoring: Assigns binary values (0 or 1)
      2. Relative Scoring: Allows a range-based score (e.g., 0 to max score)
      3. Customize the maximum score per rule

      

2. Accessibility Insights

   Detects and displays accessibility issues such as:

   1. Tab order
   2. Alt text presence
   3. Data labels, titles, and tooltips
   4. Color blindness
   5. Background contrast compliance

   

3. Lineage Enhancements

   When a node in the lineage view is selected, a new pane displays:

   1. All relevant metadata and properties of the selected node
   2. Simplifies tracing and understanding model dependencies

   

CertyFAST by MAQ Software v1.2.1

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. Performance improvement and bug fixes

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

CertyFAST by MAQ Software v1.1.0

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

Change Log

1. Support for additional file types (TMDL, XMLA Endpoint)
2. Enhancements to lineage view
3. Walkthrough screens for new users

What's New:

1. Support for additional file types

   1. Semantic Model Analysis
      1. TMDL - Select the TMDL root folder containing semantic model definition. The folder needs to follow TMDL structure and folder name should follow the naming convention of ReportName.SemanticModel
      2. XMLA Endpoint - Provide XMLA connection string for your workspace and click on connect. After authentication, list of semantic models present in the workspace will be listed in the dropdown
   2. Report UI Analysis
      1. Report Folder - Select the folder containing all the reports (pbix file) connected to a single semantic model. This option enables project teams to perform report analysis for all the report together and get accurate information about the fields and measures not used in any of the report. All the tool features will show datapoints from all the reports.

2. Lineage view enhancements

   1. Field Parameters and Calculated Tables - Team members can now easily visualize the fields used to create a field parameter or calculated table. It also enables an easy view to understand the visuals making use of field parameters

      

   2. Grid view - Switch to grid view to understand the impact of a certain field in a simple tabular information. Filter to a specific field which you are looking for and get details of all the objects used to create the field or the objects which uses the selected field.

      

   3. Highlight unused fields - Identify unused fields (columns and measures) directly from the lineage view by clicking on the View Unused Objects checkbox. Once the checkbox is selected, all the fields not used in your model are highlighted for easy identification of users.

      

   4. Layout ordering - Changed the ordering of connecting semantic model fields to the visual to remove redundant page nodes and make it easy for users to understand the lineage. Now, columns/measures will be directly connected to the visual nodes where they are used, and all the visual nodes will connect to respective page node

      

3. Documentation enhancements

   1. Added field parameter value for table type column to easily identify the tables auto created as part of field parameters
   2. Added source details information to surface the upstream source type along with server/file details and tables used in the query.

   

   Note - Currently, we support limited sources for accurate identification of source information and we will be enhancing the list in future releases.

CertyFAST by MAQ Software v1.0.3

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

Change Log

1. Performance improvement and bug fixes

CertyFAST by MAQ Software v1.0.2

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

Change Log

1. Customize insight rules
2. Performance improvement for lineage and unused fields
3. What's new section to highlight new features

What's New:

1. Customize Insight Rules

   Add new rules for the insights pane based on the standards and practices followed by your project or organization. Export the updated rules as JSON file and share with other team members to use the same rules. Navigate to settings -> Insights Rules to start customization

   

2. Performance improvement for lineage and unused fields identification

CertyFAST by MAQ Software v1.0.1

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

Change Log

1. Support for dark mode
2. Support for measures created in live connected report
3. Added new rules in insights section

What's New:

1. Dark mode

   Update the appearance configuration from the settings pane to dark mode or use system default to have the appearance match system settings of your machine

   

2. Verified Publisher

   Users will no longer receive unsafe file/unverified publisher warning while downloading or installing the tool. Windows will recognize MAQ LLC is verified publisher for the tool.

   

3. Measures created in report

   All the measures created in live connected reports are documented in the documentation section under measures tab. Can easily be identified using the Origin column having value as Report UI.
   They are also available in the lineage section and are considered while identifying unused fields

   ![image](https://github.com/maqsoftware/CertyFAST/assets/34050132/4fda8121-1196-46a5-80cd-ab42ddf56110)
   

4. New rules for semantic model insights

   • Duplicate columns/measures - Fields which are exact copy of other field and can be deleted

   • Repeated expression across measures - DAX expressions which are repeated across measures and can be replaced by base measures. If there is already a base measure present in the model, it will be highlighted in the Base Measure column. (Measures using variables are currently not supported)

     

   • Hide internal columns - Surface possible list of internal columns which should be hidden in your models. Fields used in relationships or sort by columns are currently considered

   • Without measure table - List of all the measures which are not present in a separate measure table and available in existing dims/fact tables

   • Hide fact table - List of possible fact tables which are not hidden

5. Document conditional formatting rules

   Conditional formatting rules for tables and matrix visuals available in the documentation section under visuals tab

   

6. Enhanced layout for PDF export

CertyFAST by MAQ Software v1.0.0

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

Key Features:

• Insights: Automatically checks how well report follows the organization standards and find gaps that affect report size, performance, or usability for end users.
• Lineage: Find out how any field depends on other parts of the semantic model and report visuals to understand the impact across the report.​
• Alignment: Showcases visual alignment problems in the report that affect user experience.​
• Documentation: Detailed documentation of semantic model and report visuals, helping developers to create knowledge documents consistently and easily.​
• Export: Export all information related to semantic model and report visuals in preferred format – Excel or PDF.​