Suggestions on a Power Query, DAX, Power Pivot, and the typical data modelling book?

[Anonymous]

Hi,

I'm looking for a book to explain the subjects of Power Query, DAX, Power Pivot, and the typical data modelling scenarios.

If a book only mentions one subject then I will not get to understand the overlap between them. If I were to find a book that explains each of these subjects then it will also explain the overlapping and identify what subject/skill you should use for which task. Therefore, preferably, I would like a book that contains each subject.

I am not no so concerned with a book on the Power BI visual features and formatting as, in my experience, it will probably be out of date by now as Power BI is changing fast. The key for me is the modelling and shaping of data. So I would like a book that explains the common scenarios on the data in its raw form and how to shape it to produce the optimal data model for reporting.

I have reviewed the books are Amazon but as there are so many I cannot single one out - hence coming to you for your suggestions.

Please can anyone suggest a book that meets this requirement or maybe training videos that provide the above?

Thanks.

[marcorusso · Accepted solution]

I and Alberto Ferrari wrote this book about data modeling for Power BI and Power Pivot:

http://www.sqlbi.com/books/analyzing-data-with-microsoft-power-bi-and-power-pivot-for-excel/

I hope it helps!

Marco Russo - SQLBI

[Anonymous]

Thanks both, ordered!

[v-ljerr-msft]

Hi @Anonymous,

Great to hear you have found a good book. Could you accept the helpful reply as solution to close this thread? 

Regards

[MFelix]

Hi @Anonymous,

Try the site https://www.sqlbi.com, it as a lot's of information, training and also books that you can have.

One of the authors is now connected on the Community so you can also contact him @AlbertoFerrari.

Regards,

MFelix