How to optimize your data model in Power BI

[BIfanatic]

Dear all,

Since we are quite new to Power BI we could use some more information about how you can design a data model that is optimal for Power BI (e.g. cases, documentation, videos). It's an amazing tool but requires a brand new way of thinking with regards to our current dashboards in Excel.

Any help is appreciated!

[TomMartens · Accepted solution]

This most simple thing to start with Power BI is just reading these two books:

1. https://www.amazon.com/Analyzing-Power-Pivot-Business-Skills/dp/150930276X/ref=sr_1_1?ie=UTF8&qid=15...
2. https://www.amazon.com/Definitive-Guide-DAX-intelligence-Microsoft/dp/073569835X/ref=sr_1_2?ie=UTF8&...

There is also this online course on edx.org  - free of charge

https://www.edx.org/course/analyzing-visualizing-data-power-bi-microsoft-dat207x-6

You should look for videos on youtube from GuyInACube

I'm pretty sure that this gets you started, and do not forget the guided learning material from here

https://powerbi.microsoft.com/en-us/guided-learning/

Regards