CertyFAST v1.1.0

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 v1.0.3

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 v1.0.2

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 v1.0.1

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 v1.0.0

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.​