DAX Cookbook

Deckler, Greg

DAX Cookbook
  • 出版商: Packt Publishing
  • 出版日期: 2020-03-19
  • 定價: $1,520
  • 售價: 9.0 折 $1,368
  • 語言: 英文
  • 頁數: 552
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1839217073
  • ISBN-13: 9781839217074
  • 相關分類: 大數據 Big-data、Data Science

    • 立即出貨 (庫存=1)

商品描述

DAX provides an extra edge by extracting key information from the data that is already present in your model. Filled with examples of practical, real-world calculations geared toward business metrics and key performance indicators, this cookbook features solutions that you can apply for your own business analysis needs.

You'll learn to write various DAX expressions and functions to understand how DAX queries work. The book also covers sections on dates, time, and duration to help you deal with working days, time zones, and shifts. You'll then discover how to manipulate text and numbers to create dynamic titles and ranks, and deal with measure totals. Later, you'll explore common business metrics for finance, customers, employees, and projects. The book will also show you how to implement common industry metrics such as days of supply, mean time between failure, order cycle time and overall equipment effectiveness. In the concluding chapters, you'll learn to apply statistical formulas for covariance, kurtosis, and skewness. Finally, you'll explore advanced DAX patterns for interpolation, inverse aggregators, inverse slicers, and even forecasting with a deseasonalized correlation coefficient.

By the end of this book, you'll have the skills you need to use DAX's functionality and flexibility in business intelligence and data analytics.

商品描述(中文翻譯)

DAX 提供了一個額外的優勢，可以從已經存在於模型中的數據中提取關鍵信息。這本食譜書充滿了針對業務指標和關鍵績效指標的實用、現實世界的計算示例，其中包含了您可以應用於自己的業務分析需求的解決方案。

您將學習撰寫各種 DAX 表達式和函數，以了解 DAX 查詢的工作原理。本書還涵蓋了日期、時間和持續時間等部分，以幫助您處理工作日、時區和班次。然後，您將學習如何操作文本和數字，以創建動態標題和排名，並處理度量總數。隨後，您將探索財務、客戶、員工和項目的常見業務指標。本書還將向您展示如何實施常見的行業指標，例如供應天數、故障間平均時間、訂單週期時間和整體設備效率。在結尾的章節中，您將學習應用於協方差、峰度和偏度的統計公式。最後，您將探索用於插值、反向聚合器、反向切片器甚至是去季節化相關係數的高級 DAX 模式。

通過閱讀本書，您將具備在商業智能和數據分析中使用 DAX 功能和靈活性所需的技能。

作者簡介

Greg Deckler is Vice President of the Microsoft Practice at Fusion Alliance and has been a professional technology systems consultant for over 25 years. Internationally recognized as an expert in Power BI, Greg Deckler is a Microsoft MVP for Data Platform and a superuser within the Power BI community with over 100,000 messages read, more than 11,000 replies, over 2,300 answers, and more than 75 entries in the Quick Measures Gallery. Greg founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and presents at numerous conferences and events, including SQL Saturday, DogFood, and the Dynamic Communities User Group/Power Platform Summit

作者簡介(中文翻譯)

Greg Deckler是Fusion Alliance的Microsoft實踐副總裁，擁有超過25年的專業技術系統顧問經驗。作為Power BI的國際知名專家，Greg Deckler是Microsoft Data Platform的MVP（最有價值專家），並且在Power BI社群中是一位超級用戶，閱讀了超過100,000條訊息，回覆了超過11,000次，提供了超過2,300個答案，並在Quick Measures Gallery中有超過75個條目。Greg創立了哥倫布Azure ML和Power BI用戶組（CAMLPUG），並在許多會議和活動中進行演講，包括SQL Saturday、DogFood和Dynamic Communities User Group/Power Platform Summit。

目錄大綱

  1. Thinking in DAX
  2. Dealing with Dates and Calendars
  3. Tangling with Time and Duration
  4. Transforming Text and Numbers
  5. Figuring Financial Rates and Revenues
  6. Computing Customers KPIs
  7. Evaluating Employment Measures
  8. Processing Project Performance
  9. Calculating Common Industry Metrics
  10. Using Uncommon DAX Patterns
  11. Solving Statistical and Mathematical Formulas
  12. Applying Advanced DAX Patterns
  13. Debugging and Optimizing DAX

目錄大綱(中文翻譯)

1. 深入理解 DAX
2. 處理日期和日曆
3. 處理時間和持續時間
4. 轉換文字和數字
5. 計算財務利率和收益
6. 計算客戶關鍵績效指標
7. 評估就業指標
8. 處理專案績效
9. 計算常見行業指標
10. 使用不常見的 DAX 模式
11. 解決統計和數學公式
12. 應用高級 DAX 模式
13. 調試和優化 DAX

類似商品