Download Adventure Works Sample Database used in the Book for Examples and Practice Exercises.
Supercharge Power BI: Power BI is Better When you Learn to Write DAX teaches readers how to get the most out of Power BI by learning the DAX language. You will get to familiarise with Power BI Desktop Interface and practice the examples and the exercises, thus giving you the hands-on experience and confidence to write DAX formulas.
This is the 3rd edition of the book with the latest (Feb 2021) Power BI desktop features and UI. The book also has 2 new chapters added as compared to the 2nd edition.
- Variables in DAX
- RANKX() and TOPN()
Please note that my other book Supercharge Excel that I had written earlier using Excel 2016 covers the same learning experience and hence it can be considered a sister book. 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. Further Power BI is more advanced as compared to Excel and you might find that certain improvements made in Power BI are still not present in Excel.
About the Book
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 difference is getting familiarised with the corresponding interfaces and also some advancements in Power BI.
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 BI and Excel Power Pivot super stardom. And, you will become a data modeller to get the most of self-service BI.
Power BI Desktop and Excel Power Pivot
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 Power BI and Excel Power Pivot and a chapter is devoted in both the books Supercharge Power BI and Supercharge Excel on transferring DAX skills to the other tool.
About the Author (me, Matt Allington)
I have taken my 35+ years experience using Excel and also my experience in teaching live Power BI classes and distilled this knowledge into a book that will help any Excel user get started with Power BI, Power Pivot, and DAX. The challenge with Power BI is that it is very different to 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 Power and Supercharge Excel) 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 Power BI and Supercharge Excel) 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 Power BI and Supercharge Excel) 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 Power BI and run faster to meet your career objectives, we offer more learning opportunities that help you on your Power BI journey.
Download the Sample Database
You can download the sample Adventure Works 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.