Semantic Model Certification Rules
Below is the demonstration certification rules list used at the Microsoft Fabric Conference, along with help links where appropriate.
When creating your own rules, Kurt from Data Goblins has a similar approach that we recommend you check out:
https://data-goblins.com/dataset-checklist
For a better understanding of Delta and Parquet, see this video.
| Section | Rule | Helpful Links |
|---|---|---|
| Formatting | ||
| Folders have been set up for DIMS, FACTS, FUNCTIONS, and any other necessary items. Non-foldable steps are documented. | ||
| DAX has been formatted. Comments have been added to DAX code where needed. | ||
| All measures are in the correct folder/subfolder. Columns are in folders. Necessary columns have been hidden. | ||
| All tables, columns, and measures have business-friendly names and are correctly capitalized. | ||
| All measures and tables have a description. Columns that may be confusing have a description. | ||
| Relevant hierarchies have been created. | Hierarchies | |
| Data Dictionary | ||
| A data dictionary has been created. | ||
| Optimization | ||
| Relevant BPA rules have been run. Any failed rules have been documented with reasons for exceptions. | BPA Rules | |
| VertiPaq Analyzer has been run, and relevant actions have been taken. | VertiPaq Analyzer | |
| Model | ||
| If any tables are more than one relationship away from a fact table, the exception has been documented. | Modeling in Power BI | |
| Any relationships that are not one-to-many have been documented with reasons for exceptions. | Modeling in Power BI | |
| Lifecycle | ||
| Relevant version control has been set up. | Version Control | |
| Refresh and ownership are delegated to the correct accounts, such as Service Principals. | ||
📱 Rules table is viewable from desktop browsers only.