Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level (Paperback)

Key Features

• Solve complex business problems within Microsoft BI tools including Power BI, SQL Server, and Excel
• Develop a conceptual understanding of critical business data modeling principles
• Learn the subtleties of Power BI data visualizations, evaluation context, context transition, and filtering

Book Description

If you want to get the most out of Microsoft Business Intelligence tools, sooner or later you'll need to master DAX. Extreme DAX enables business analysts to generate powerful and sophisticated analyses from their data.

You'll learn the principles of business intelligence, good model design, 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, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations.

You'll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. Also provided with the book are PBIX files for each chapter for you to follow along with and explore in your own time.

What you will learn

• Understand data modeling concepts and structures before you start working with DAX
• Grasp how relationships in Power BI models are different from those in RDBMSes
• Secure aggregation levels, attributes, and hierarchies using PATH functions and row-level security
• Get to grips with the crucial concept of context
• Apply advanced context and filtering functions including TREATAS, GENERATE, and SUMMARIZE
• Explore dynamically changing visualizations with helper tables and dynamic labels and axes
• Work with week-based calendars and understand standard time-intelligence
• Evaluate investments intelligently with the XNPV and XIRR financial DAX functions

Who this book is for

If you are an analyst with a working knowledge of DAX in MS Power BI or other Microsoft analytics tools, this book will help you upgrade your DAX knowledge and work with analytical models more effectively.

This book is not for beginners and practical experience with DAX is necessary.

主要特點

• 使用Microsoft BI工具（包括Power BI、SQL Server和Excel）解決複雜的業務問題


• 建立對關鍵業務數據建模原則的概念性理解


• 了解Power BI數據可視化、評估上下文、上下文轉換和過濾的細微差別

書籍描述

如果你想充分利用Microsoft商業智能工具，遲早你需要精通DAX。《Extreme DAX》使業務分析師能夠從數據中生成強大而複雜的分析。

你將學習商業智能的原則、良好的模型設計以及DAX如何融入其中。然後，你將深入研究DAX在現實世界業務場景中的詳細示例，例如庫存計算、預測、公司間業務和數據安全性。在每一步中，資深的DAX專家將引導你了解在使用Power BI模型時涉及的細微差別以及在構建高級數據聚合時需要注意的常見錯誤。

你將加深對DAX函數、過濾器和度量的理解，以及它們的使用時機和方法，以獲得有效的洞察力。書中還提供了每章的PBIX文件，供你在自己的時間內跟隨並探索。

你將學到什麼

• 在開始使用DAX之前，了解數據建模的概念和結構


• 理解Power BI模型中的關係與關聯式數據庫管理系統（RDBMS）中的關係的不同之處


• 使用PATH函數和行級安全性來保護聚合級別、屬性和層次結構


• 深入研究關鍵概念「上下文」


• 應用高級上下文和過濾器函數，包括TREATAS、GENERATE和SUMMARIZE


• 使用輔助表和動態標籤和軸線探索動態變化的可視化效果


• 使用基於週的日曆並了解標準時間智能


• 使用XNPV和XIRR等金融DAX函數智能評估投資

適合閱讀對象

如果你是一位對MS Power BI或其他Microsoft分析工具中的DAX有工作經驗的分析師，本書將幫助你提升DAX知識，更有效地使用分析模型。

本書不適合初學者，需要具備DAX的實際經驗。

Michiel Rozema is one of the world’s top Power BI experts, living in the Netherlands. He holds a master’s degree in mathematics and has worked in the IT industry for over 25 years as a consultant and manager. Michiel was the data insight lead at Microsoft Netherlands for 8 years, during which time he launched Power BI in the country. He is the author of two Dutch books on Power Pivot and Power BI. Michiel is one of the founders of the Dutch Power BI user group and the organizer of the Power BI Summer School, and has been a speaker at many conferences on Power BI. He has been awarded the Microsoft MVP award since 2019 and, together with fellow MVP Henk Vlootman, runs the consultancy company Quanto, specialists in Power BI. Henk Vlootman is a senior global Power Platform, Power BI, and Excel business consultant. Every year since 2013, Henk has received the Microsoft MVP award for his outstanding expertise and community leadership. Henk is one of founders of the Dutch Power BI user group and the organizer of the Power BI Summer School, and has been a speaker at many conferences on Power BI all over the world. He is also the author of two Excel and two Power Pivot / Power BI books. He started his career in 1992 with his own company, then as an Excel consultant. Nowadays he runs the consultancy company Quanto, specialists in Power BI, together with fellow MVP Michiel Rozema.

Michiel Rozema是世界頂尖的Power BI專家之一，居住在荷蘭。他擁有數學碩士學位，並在IT行業擔任顧問和經理超過25年。Michiel曾在微軟荷蘭擔任數據洞察主管長達8年，期間他在該國推出了Power BI。他是兩本關於Power Pivot和Power BI的荷蘭書籍的作者。Michiel是荷蘭Power BI用戶組的創始人之一，也是Power BI夏季學校的組織者，並在許多Power BI的會議上擔任演講嘉賓。他自2019年起獲得了微軟MVP獎，並與MVP Henk Vlootman共同經營專注於Power BI的顧問公司Quanto。Henk Vlootman是一位資深的全球Power Platform、Power BI和Excel業務顧問。自2013年以來，Henk每年都獲得微軟MVP獎，以表彰他的卓越專業知識和社群領導能力。Henk是荷蘭Power BI用戶組的創始人之一，也是Power BI夏季學校的組織者，並在世界各地的Power BI會議上擔任演講嘉賓。他還是兩本Excel和兩本Power Pivot / Power BI書籍的作者。他在1992年創立了自己的公司，並擔任Excel顧問。現在，他與MVP Michiel Rozema一起經營專注於Power BI的顧問公司Quanto。

1. DAX in Business Intelligence
2. Model Design
3. Using DAX
4. Context and Filtering
5. Security with DAX
6. Dynamically Changing Visualizations
7. Alternative Calendars
8. Working with AutoExist
9. Intercompany Business
10. Exploring the Future: Forecasting and Future Values
11. Inventory Analysis
12. Personnel Planning

- DAX在商業智能中的應用
- 模型設計
- 使用DAX
- 上下文和篩選
- 使用DAX進行安全性控制
- 動態變更視覺化效果
- 替代日曆
- 使用AutoExist進行工作
- 公司間業務
- 探索未來：預測和未來數值
- 庫存分析
- 人員計劃