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 unhidden to allow for this report to be developed and then hidden again to maximize usability. Numeric fact table columns that are referenced by DAX Measures (for example, quantity) should be hidden from the fields list, as the measures can be used for visualizing this...