Extreme DAX

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 time What 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 for

Extreme 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.