About the Book Bundle
This book bundle contains the digital copies of the most read books in DAX, Power Pivot, Power BI, and Power Query in 3 different DRM Free formats (PDF, MOBI and ePub) for immediate download:
- Supercharge Power BI by Matt Allington
- Supercharge Excel by Matt Allington
- The Foundations of Power BI by Matt Allington
- DAX Language Quick Reference Guide by Matt Allington
- Power Pivot and Power BI by Rob Collie, Avichal Singh
- M is for (Data) Monkey by Ken Puls, Miguel Escobar
- PowerPivot Alchemy by Rob Collie, Bill Jelen
1. Supercharge Power BI by Matt Allington
Supercharge Power BI: Power BI is Better When you Learn to Write DAX covers the same learning experience as covered in my other book Supercharge Excel, and hence it can be considered a sister book. Supercharge Power BI is updated using Power BI Desktop. This book teaches readers how to get the most out of Power BI by learning the DAX language.
These two books use the same content, teaching, and practice format but with different software versions, as indicated in the titles. You should choose the best book for you given which software product you want to use.
Of course if you want to familiarize with both Excel 2016 and Power BI Desktop Interfaces to write DAX, you can read both.
2. Supercharge Excel by Matt Allington
Supercharge Excel: When You Learn To Write DAX For Power Pivot is the second edition of my book Learn to Write DAX that was written using Excel 2013. Supercharge Excel is written using Excel 2016.
3. The Foundations of Power BI by Matt Allington
The Foundations of Power BI is an aggregation of more than 3 years of my (Matt Allington) hard work in understanding and sharing concepts with people on my website. This book is a curated compilation of many of these blog articles I have written over the years. I decided to turn my material into a Book so readers can get a focused and concentrated dose of knowledge and information in a logical, easy to consume and well-structured format. I have edited the content from my blog articles where necessary to make it a standalone book that will take you on a journey from discovery to a point where you can confidently commence to use the tools Power BI, Power Pivot and Power Query.
What this book will not do (and does not set out to do) is teach you how to use Power Pivot or Power Query (Get Data), or indeed how to build reports in Power BI. This book covers the foundation knowledge that everyone should know if they want to understand and be good at using Power BI.
Although most of this material is available in one form or another on my website, the material and this book are copyright material and must not be reproduced. Anyone that wants to benefit from the hundreds of hours of effort I have put into the content in this book can simply purchase a copy for a very reasonable price from here.
4. DAX Language Quick Reference Guide by Matt Allington
DAX Language Quick Reference Guide covers every function across the DAX language all nicely laid out to make the functions easy to find. It contains a list of all the current DAX functions in a summarised and easy to use format. You can print the document and/or use the search features for PDF documents to search for the function you are looking for.
This reference guide is not designed to be a comprehensive language reference, but more of a quick reference to help you find and understand which functions exist and how they can be used. You will find the syntax of each DAX function and what the function does in just a glance. For DAX complex functions, more information about the function and in some cases examples are also added.
This document is a supplement and is not intended to replace the more detailed documentation that is available online.
5. Power Pivot and Power BI by Rob Collie, Avichal Singh
Power Pivot and Power BI – The Excel User’s Guide to DAX, Power Query, Power BI, & Power Pivot in Excel 2010 – 2016 is the second edition of the number 1 selling Power Pivot Book – printed in full colour. This expanded 2nd edition includes DAX, Power Query, Power BI Desktop, PowerBI.com and also covers Excel 2010 through Excel 2016.
Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data. We have repeatedly witnessed the “Power tools’” transformative impact on the bottom line – far more robust and elegant than Excel alone, and much more agile and affordable than traditional BI tools. Their shared state of the art calculation engines (DAX and M) turn any PC into an analytical supercomputer, but the real secret is people – these tools are 100% learnable by today’s users of Excel. The data revolution lays not in the hands of an elite few, but in YOUR hands, and we want to help you seize that opportunity.
6. M is for (Data) Monkey by Ken Puls, Miguel Escobar
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.
7. PowerPivot Alchemy by Rob Collie, Bill Jelen
Power Pivot Alchemy – Patterns and Techniques for Excel was written by Rob Collie (best selling PowerPivot author of DAX Formulas) and Bill Jelen (aka Mr Excel). It is a natural follow on for anyone that has read Rob’s first book. Alchemy is a book that covers various patterns and techniques that can be used to make your PowerPivot workbooks rock. This book is ideal for someone that is already familiar with DAX but wants to take it to the next level.