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

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)

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

$301

Microsoft Power BI 數據可視化與數據分析
$1,980

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI, 2/e (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。