Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level (Paperback)
暫譯: 極限 DAX：提升你的 Power BI 和 Microsoft 數據分析技能至新境界 (平裝本)

Name: Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level (Paperback)
Price: 1758 TWD
Availability: InStock
Author: 作者 Michiel Rozema , Henk Vlootman
ISBN: 1801078513

作者 Michiel Rozema , Henk Vlootman

出版商: Packt Publishing
出版日期: 2022-01-20
售價: $1,850
貴賓價: 9.5 折 $1,758
語言: 英文
頁數: 470
裝訂: Quality Paper - also called trade paper
ISBN: 1801078513
ISBN-13: 9781801078511
相關分類: Power BI、Data Science

立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

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。