关于此电子书
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.
评分和评价
作者简介
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker, and Consultant. He has more than 20 years of experience in data analysis, BI, databases, programming, and development, mainly on Microsoft technologies. He is a Microsoft Data 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 be found on his blog.
He is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He wrote more than 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-Level Security 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, and user groups. And He is a Microsoft Certified Trainer.
