Power BI DAX Simplified: DAX and calculation language of Power BI demystified by practical examples - Softcover

Rad, Reza

Softcover

ISBN 13: 9798538933952

Publisher: Independently published, 2021

Synopsis

DAX is the language of data analysis in Microsoft Power BI, Azure Analysis Services, and Excel Power Pivot. DAX is a powerful language that can quickly empower you to analyze year-over-year or rolling 12 months calculations. It is rare to find an analytics solution using Microsoft technologies (especially Power BI) that doesn’t require some calculations to be written by DAX.
As a Power BI (or Microsoft BI) developer, it is essential to learn this language and master it. Learning a language is not just learning the structure and functions. It is learning how, where, and when to use it so that you can solve real-world problems with it.
In my training and consulting experience on Power BI, I realized that DAX is the weak point for many Power BI users. DAX itself is not a complex language. It is merely a language of expression. The complexity of learning DAX is not the formula or the functions. It is how to use it in real-world scenarios and how it performs on a dataset or visual.
I have been writing many blogs about DAX for many years. My blog articles are all coming from my experience working with Power BI. I found it helpful to compile them all in a book. Because my blog articles practically explain things, I thought it better to title it as a practical way of learning DAX by examples.
Indeed, there are books, articles, and Microsoft documentation on how each function works where and how. However, learning these through an example would bring a new way of understanding it.
A good analytics solution is a combined outcome of a good data model, good data preparation, and good analytics and calculations. I have written another book about the Basics of modeling in Power BI. This book is covering the calculation and DAX aspects of it.
This book is for you if you are building a Power BI solution. Even if you are just visualizing the data, calculations are an essential part of analytics. You do need to have the calculation ready before visualizing it.
This is not a book to explain every single function in DAX. The approach in this book is to have practical examples. Every chapter is based on real-world examples of using a combination of functions to solve a challenge. You can start from any chapter and finish at any chapter. The order of chapters suggested in this book is just a guideline to help you have a smooth flow of topics. Each chapter can be read without needing other chapters. Examples of this book are designed in a way that you can use the learning straight away in your Power BI file.

About this title

About the Author

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker, and Consultant. He has more than 20 yearsof experience in data analysis, BI, databases, programming, and development,mainly on Microsoft technologies. He is a MicrosoftData Platform MVP for 11 straight years (from 2011 till now).Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of the Difinity conference in New Zealand, and the PowerBI Summit (the biggest Power BI conference)

• CEO at RADACAD
• Chairman and Director at Power BI Summit
• Chairman and Director at Difinity conference (Since 2017)
• Microsoft Regional Director (Since 2018)
• Microsoft Data Platform MVP (Since 2011)
• Leader of Power BI user group in Auckland, New Zealand
• Power BI All-Star award winner
• Microsoft Power Platform Fast Track Solution Architect - Power BI
• Dynamic Communities Emerald award winner
• Author of more than ten books on BI, analytics, and Power BI
• Speaker at many conferences such as Ignite, Microsoft Business Applications Summit, PASS, etc.
• Blogger and content creator
• Consultant and trainer
• Microsoft Certified trainer
• Microsoft Certified professional

His articles on different aspects of technologies, mainly on BI, can befound on his blog.
He is an MCP, MCSE, and MCITP of BI. He is the leader of theNew Zealand Business Intelligence users group. He wrote morethan 10 books. He is also the author of the very popular book PowerBI from Rookie to Rock Star, and the PowerBI Pro Architecture. He also wrote a book on Row-LevelSecurity in Power BI and Basics of PowerBI modeling, which are valuable assets for Power BI users.
He is an International Speaker in Microsoft Ignite, Microsoft BusinessApplications Summit, Data Insight Summit, PASS Summit, SQL Saturday, anduser groups. And He is a Microsoft Certified Trainer.

Edition details

• Publisher: Independently published
• Publication date: 2021
• Language: English
• ISBN 13: 9798538933952
• Binding: Paperback
• Number of pages: 496