Extreme DAX : Take your Power BI and Fabric analytics skills to the next level (2ND)

Discover the true power of DAX in Microsoft Power BI and Fabric and build advanced DAX solutions for practical business scenarios

Key Features

Solve complex business problems leveraging Microsoft BI tools including Power BI and Fabric
Develop a conceptual understanding of critical data modeling principles and best practices
Learn the subtleties of DAX calculations, like evaluation context, context transition, and table functions

Book DescriptionThis book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of the modern Microsoft analytics platform based on Power BI and Fabric.
Extreme DAX will first teach you the principles of business intelligence, good model design, semantic model architectures, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, real estate planning, benchmarking, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with semantic models and common mistakes to look out for as you build advanced data aggregations.
You'll deepen your understanding of DAX functions, visual calculations, and measures, and how and when they can be used to derive effective insights. You'll also learn about more advanced techniques like field parameters, calculation groups, user-defined functions and custom calendars. For each chapter, you'll be provided with PBIX files so that you can follow along and explore in your own timeWhat you will learn

Understand storage modes and modeling principles in semantic models
Create reusable visual calculations
Get to grips with the crucial concept of context
Apply advanced context and filtering functions including TREATAS
Implement semi-recursive calculation logic
Work with week-based calendars and implement intra-day intelligence
Implement linear regression and advanced goal-seeking
Secure attributes and aggregation levels

Who this book is forExtreme DAX is written for analysts with some practical experience with DAX in Power BI, Fabric, or other Microsoft analytics tools. It will help you to upgrade your knowledge and work with analytical models more effectively. It explains new features that were recently added to the DAX language by not only introducing concepts but discussing sophisticated business scenarios as well. This way, Extreme DAX will inspire you to apply advanced DAX techniques in your own analytics projects.