This product bundle includes the following 2 paper back books as well as a free Digital copy of each.
- Supercharge Excel – Matt Allington
- M is for data monkey – Ken Puls, Miguel Escobar
Supercharge Excel (includes free digital copy)
Supercharge Excel – When You Learn To Write DAX for Power Pivot is the second edition of Learn to Write DAX that was the most preferred DAX book. The first edition was based on Excel 2013 while the second edition is on Excel 2016.
Data analysis expressions (DAX) is the data modelling language of Excel Power Pivot and Power BI. DAX language and DAX functions are the same in both Excel and Power BI and hence the knowledge is transferable between the two. The only difference is getting familiarised with the corresponding interfaces.
Simply reading a regular book is normally not enough to help users to learn DAX skills – you need to complete the exercises and get plenty of practice to make the transition. This book is written to give you exactly that – hands-on practice. Inside you will find explanation of the concepts, sample exercises and then practice questions and answers to maximise learning retention and experience.
M is for Data Monkey (includes free digital copy)
Power Query is an important part of the Power BI (Business Intelligence) product suite from Microsoft, and “M” is the name of the programming language created by the Power Query user interface. As more business intelligence pros begin using Power Pivot, they find they need new ways to clean and reshape the data before importing it into Excel; Power Query makes this a snap.
This book shows how to use Power Query, and how to get difficult data sets into both Excel and Power Pivot.