Jump directly to the Adventure Works Database Download.
Supercharge Excel: When You Learn to Write DAX for Power Pivot is the second edition of my book Learn to Write DAX.
This updated version covers the same learning experience and exercises as covered in my first book but is updated using Excel 2016. This book teaches readers how to get the most out of Power Pivot for Excel 2016 by learning the DAX language. If you are already competent in the DAX content from my first book Learn to Write DAX, then there is no need to read this book. Of course if you want an updated version and/or want to repeat the exercises, then it could be good for you.
If you want to learn DAX using Excel 2013, you can indicate the same in the order notes of this book, and you will get a copy of Learn to Write DAX that is still a good fit for you.
About the Book
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.
Once you have read my book and completed the exercises there will be no stopping you on your path to DAX, Power Pivot and Power BI super stardom. And, you will become a data modeller to get the most of self-service BI.
Excel Power Pivot and Power BI Desktop
Power BI is the self-service BI tool from Microsoft. PowerBI.com became generally available in July 2015 and is following a rapid monthly development cycle – the pace of change is quite astonishing. There is no doubt that Excel users will increasingly want to leverage the sharing and modern visualisation capabilities of PowerBI.com, and learning to write DAX is the foundation of that journey.
The DAX skills that you learn are fully transferable between Excel Power Pivot and Power BI Desktop.
About the Author (me, Matt Allington)
I have taken my 30+ years experience using Excel and also my experience in teaching live Power Pivot classes and distilled this knowledge into a book that will help any Excel user get started with Power Pivot, DAX and Power BI. The challenge with DAX is that it is completely different to the rest of Excel. As a result, you can’t just ‘incrementally learn’ this stuff off the base of your existing Excel skills – you really need to do some formal learning to get started. This book is exactly what you need to get that start.
Purchase Options For You
You can purchase the Paperback from
- My shop (ships within Australia only) – *see bonus offer details below.
- From my publisher Mr Excel (ships within USA only) – *see bonus offer details below.
- Amazon USA and also most other Global Amazon stores.
Bonus Offer*: If you purchase the paperback from my shop or from Mr Excel you will receive a DRM free copy of both the eBooks (Supercharge Excel and Supercharge Power BI) at no extra charge (immediate download). Sorry, this offer is not available from Amazon.
- I sell the digital edition of my book globally from my shop, where you purchase the 2 eBooks (Supercharge Excel and Supercharge Power BI) together at the price of one (offer available in this shop only). If you purchase the paperback from my shop you will receive a DRM free copy of both the eBooks (Supercharge Excel and Supercharge Power BI) at no extra charge (immediate download). There are 3 file formats including a PDF (for your PC) and also a MOBI format (for Kindle). Sorry, the bonus offer is not available from Amazon.
- Alternatively you can purchase the Kindle edition from Amazon.
Do You Want More Guided Learning?
If you want to get a quick start on DAX and run faster to meet your career objectives, you can enroll to my Supercharge Power BI Online training. The training is for 5 weeks and includes study and practice, online videos to explain complex concepts and a weekly live Q&A session with me.
As the DAX skills are transferable across Excel Power Pivot and Power BI Desktop, you can choose any of the two interfaces and guidance will be given for both. You will be given an eBook copy of both books Supercharge Power BI and Supercharge Excel, and you can choose to read which ever version you prefer to participate in the training.
You can find more details here.
Download the Sample Database
You can download the sample database here so that you can complete the practice exercises in the book. If you want to get any value from this book, you simply must complete the exercises.