About the Books
Power BI is the self-service BI tool from Microsoft. PowerBI became generally available in July 2015 and is following a rapid monthly development cycle – the pace of change is quite astonishing. Data analysis expressions (DAX) is the data modelling language of Power BI and Excel Power Pivot . DAX language and DAX functions are the same in both Power BI and Excel and hence the knowledge is transferable between the two. The only difference is getting familiarised with the corresponding interfaces. There is no doubt that Excel users will increasingly want to leverage the sharing and modern visualisation capabilities of PowerBI, and learning to write DAX is the foundation of that journey. The DAX skills that you learn are fully transferable between Power BI Desktop and Excel Power Pivot .
Power Query is an important part of the Power BI (Business Intelligence) product suite from Microsoft and Excel Power Pivot, and “M” is the name of the programming language created by the Power Query user interface.
Supercharge Power BI (includes free digital copy)
Supercharge Power BI is the third edition of my book written using Power BI.
I have taken my 30+ years experience using Excel and also my experience in teaching live Power Pivot classes and distilled this knowledge into the book that will help any Excel user get started with DAX, Power BI and Power Pivot.
Master Your Data (includes free digital copy)
Master Your Data is the 2nd edition of M is for Data Monkey written by Ken Puls and Miguel Escobar.
This book shows how to use Power Query, and how to