AdventureWorks Data Model Decomposition

This Power BI Dashboard is showing the structure of AdventureWorks Analysis Services Tabular Models. It can also be used to document tabular models created in Power BI, SSAS or Excel Power Pivot. Furthermore, the dashboard provides in depth analysis of where Analysis Services model optimization is required.

 

 

 

The model includes:

---> Tables & its relationships & associated meta data

---> Columns & its relationships & associated meta data

---> Relationships, its cardinality & associated keys

---> Measures, its dependencies & DAX Code

---> Security & its management

---> Power Query definitions & its M Code

---> Calculated Columns & its DAX Code

---> Calculated Tables & its DAX Code

---> User Hierarchies

---> Encoding, Compression & its meta data

---> Data Types etc.

 

 

 

 

See the subsequent pages in this report for detailed information.

 

eyJrIjoiYmM1Y2IyYTItYjk4Mi00NDgyLTgzOWYtYjAzODAwMTdjYWU4IiwidCI6ImEwZTZmOTIyLThhZWQtNDdhYi1hOWZlLWI4YzYwZWIyYThjYSJ9