Model metadata

The consistent and complete application of metadata properties, such as Default Summarization and Data Category, greatly affect the usability of a dataset. With a solid foundation of tables, column data types, and relationships in place, dataset designers and BI teams should consider all primary metadata properties and their implications for user experience as well as any additional functionality they can provide.

Visibility

Every table, column, and measure that isn't explicitly needed in the Report View should be hidden. This usually includes all relationship columns and any measure support tables and measure expressions. If a column is rarely needed or only needed for a specific report, it can be temporarily...