Jump directly to the Adventure Works Database Download.
Learn to write DAX – A Practical Guide to Learning Power Pivot for Excel and Power BI is my first book on DAX (now superceded). This book teaches readers how to get the most out of Power Pivot for Excel 2013 by learning the DAX language. This book gained popularity as one of the best books to actually learn the DAX language. You can read the reviews about this at Amazon.
This book has now been updated into the following two versions:
Supercharge Excel: When You Learn to Write DAX for Power Pivot. This updated version covers the same learning experience and exercises as covered in my first book but is updated using Excel 2016.
Supercharge Power BI: Power BI is Better When you Learn to Write DAX covers the same learning experience as covered in Supercharge Excel, and hence it can be considered a sister book. Supercharge Power BI is written using Power BI Desktop.
If you are starting afresh to learn to write DAX using Excel, I suggest to opt for Supercharge Excel. If you are on the path of becoming a master of the self-service tool Power BI Desktop, I suggest to opt for Supercharge Power BI. If you want to learn using Excel 2013, then this book is still a good fit for you. You can purchase the paperback of this book from my shop and you will get an immediate download of the 3 versions of the eBooks (as outlined above) for free.
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.