topic Re: AdventureWorks Data Model Decomposition in Data Stories Gallery

AdventureWorks Data Model Decomposition

BhaveshPatel — Tue, 03 Jul 2018 05:26:45 GMT

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.

Re: AdventureWorks Data Model Decomposition

eduardo_alda — Thu, 25 Oct 2018 23:55:44 GMT

Could you share the pbix?

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

Thank you!

Re: AdventureWorks Data Model Decomposition

slc7456 — Fri, 26 Oct 2018 19:25:01 GMT

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?

Re: AdventureWorks Data Model Decomposition

BhaveshPatel — Sat, 27 Oct 2018 05:22:01 GMT

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

Re: AdventureWorks Data Model Decomposition

krambhia — Wed, 26 Jun 2019 20:55:09 GMT

Hello,

Could you share the pbix please?

Thank you

Kiran.

Re: AdventureWorks Data Model Decomposition

tmogoswane — Tue, 02 Jul 2019 10:45:35 GMT

are you able to share the file?

Re: AdventureWorks Data Model Decomposition

Ramakrishnay — Thu, 08 Aug 2019 00:15:48 GMT

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

Re: AdventureWorks Data Model Decomposition

Johnno — Thu, 22 Aug 2019 22:49:58 GMT

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/

Re: AdventureWorks Data Model Decomposition

Anonymous — Sat, 26 Dec 2020 12:12:46 GMT

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.