Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence

Philip Seamark

  • 出版商: Apress
  • 出版日期: 2018-03-31
  • 售價: $1,980
  • 貴賓價: 9.5$1,881
  • 語言: 英文
  • 頁數: 284
  • 裝訂: Paperback
  • ISBN: 1484234766
  • ISBN-13: 9781484234761
  • 相關分類: Power BISQL
  • 海外代購書籍(需單獨結帳)

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

商品描述

Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges.

Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario.

What You’ll Learn

 

  • Turbocharge your Power BI model by adding advanced DAX programming techniques
  • Know when to use calculated measures versus calculated columns
  • Generate new tables on the fly from existing data
  • Optimize, monitor, and tune Power BI to improve performance of your models
  • Discover new ideas, tricks, and time-saving techniques for better models

 

Who This Book Is For

Business intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios.

商品描述(中文翻譯)

親愛的所有SQL專家,DAX不僅僅用於編寫基於Excel的公式!透過《Beginning DAX with Power BI》,您可以親身體驗並獲得專家建議,學習如何運用DAX語言的強大功能來解決常見的數據建模挑戰。

本書將教授關鍵概念,例如從SQL到DAX的映射技巧、過濾、分組、連接、樞紐分析以及使用臨時表等,所有內容都針對SQL專業人士。作者Philip Seamark將帶領您進入典型的商業數據轉換場景和挑戰,並逐步教您如何使用DAX解決這些挑戰。書中包含並解釋了許多技巧、技巧和快捷方式,並提供了SQL等效的示例,以加速學習。書中的示例從初級到高級,每個場景都有詳細的解釋。

您將學到什麼

- 通過添加高級DAX編程技巧,加速您的Power BI模型
- 知道何時使用計算度量值和計算列
- 從現有數據中即時生成新表
- 優化、監控和調整Power BI,提高模型性能
- 發現更多關於模型的新想法、技巧和節省時間的技巧

本書適合對象

本書適合商業智能開發人員、業務分析師或任何希望將Power BI作為報告工具的SQL用戶。建議具備扎實的SQL理解能力,因為書中的示例包括SQL問題/解決方案場景的DAX等效方法。