AdventureWorks Data Model Decomposition 06-26-2019 13:55 PM

[BhaveshPatel]

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

[tmogoswane]

are you able to share the file?

[krambhia]

Hello,

Could you share the pbix please?

Thank you

Kiran.

[slc7456]

Is this directly related to a tabular model? Meaning you could change the connection string to a differnt cube and the file would automatically work? 

[BhaveshPatel]

Yes it does. 

You can point the connection parameters to the different cube and it will refresh with the metadata of the model.

You can use it to document Power BI, SSAS Tabular and Power Pivot Data Models.

Thanks

Bhavesh

[PBI-Padawan]

Would you mind giving a little more detail on what is meant by "point the connection to the different cube"? Also, which AdventureWorks db version is being used in the analysis?

I like the overall approach to the analysis.

[Ramakrishnay]

Hello,

Could you share the pbix please?

Thank you

Ramakrishna

---

@BhaveshPatel wrote:

Yes it does. 

You can point the connection parameters to the different cube and it will refresh with the metadata of the model.

You can use it to document Power BI, SSAS Tabular and Power Pivot Data Models.

Thanks

Bhavesh

---

.

[eduardo_alda]

Could you share the pbix?

Would like to study how you made some of the visuals.

Thank you!

[Johnno]

If you're looking for the inspiration for creating your own version, which includes a downloadable Power BI Template, I'd suggest a visit to https://datasavvy.me/2017/09/19/the-tabular-model-documenter-is-now-a-power-bi-template/