Pro Dax with Power Bi: Business Intelligence with Powerpivot and SQL Server Analysis Services Tabular

Seamark, Philip, Martens, Tom

  • 出版商: Apress
  • 出版日期: 2019-12-11
  • 售價: $1,670
  • 貴賓價: 9.5$1,587
  • 語言: 英文
  • 頁數: 280
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484248961
  • ISBN-13: 9781484248966
  • 相關分類: MSSQLPower BISQL
  • 海外代購書籍(需單獨結帳)

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

商品描述

Know the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI, Microsoft's leading self-service business Intelligence application, and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanced applications of DAX to solve complex tasks.

Often a task seems complex due to a lack of understanding, or a misunderstanding of core principles, and how certain components interact with each other. The authors of this book use solutions and examples to teach you how to solve complex problems. They explain the intricate workings of important concepts such as Filter Context and Context Transition. Explanation is given to how, through combining building blocks of DAX (such as measures, table filtering, and data lineage), Power BI can yield impressive analytical power. Throughout Pro Dax with Power BI these building blocks are used to create and compose solutions for advanced DAX problems so you can independently build solutions to your own complex problems, and gain valuable insight from your data.


What You'll Learn

 

 

  • Understand the intricate workings of DAX to solve advanced problems
  • Deconstruct problems into manageable parts in order to create your own recipes
  • Apply predefined solutions for addressing problems, and link back step-by-step to the mechanics of DAX, to know the foundation of this powerful query language
  • Get fully on board with DAX, a new and evolving language, by learning best practices

 

 

 

Who This Book Is For

Anyone who wants to use Power BI to build advanced and complex models. Some experience writing DAX is helpful, but not essential if you have experience with other data query languages such as MDX or SQL.

商品描述(中文翻譯)

了解 DAX 的複雜運作方式以及解決高級 Power BI 挑戰所需的機制。這本書主要介紹 DAX(Data Analysis Expressions),這是 Power BI 的公式語言,也是微軟領先的自助商業智能應用程式,同時也涵蓋了其他產品,如 PowerPivot 和 SQL Server Analysis Services Tabular。您將學習如何運用 DAX 的高級應用來解決複雜任務。

通常,由於對核心原則的理解不足或對某些組件之間的互動方式存在誤解,一項任務似乎很複雜。本書的作者使用解決方案和示例來教導您如何解決複雜問題。他們解釋了重要概念(如篩選內容和內容轉換)的複雜運作方式。說明了如何通過結合 DAX 的構建塊(例如度量、表篩選和數據來源)來實現 Power BI 的強大分析能力。在《Pro Dax with Power BI》中,這些構建塊被用於創建和組合解決方案,以解決高級 DAX 問題,讓您能夠獨立解決自己的複雜問題,並從數據中獲得有價值的洞察。

您將學到什麼

- 了解 DAX 的複雜運作方式,以解決高級問題
- 將問題拆解為可管理的部分,以創建自己的解決方案
- 應用預定義的解決方案來解決問題,並逐步追溯到 DAX 的機制,了解這種強大查詢語言的基礎
- 通過學習最佳實踐,完全掌握 DAX,一種新興且不斷發展的語言

本書適合對象

任何希望使用 Power BI 構建高級和複雜模型的人。如果您具有使用其他數據查詢語言(如 MDX 或 SQL)的經驗,則對於撰寫 DAX 的經驗有所幫助,但不是必需的。

作者簡介

Philip Seamark is an experienced data warehouse (DW) and business intelligence (BI) consultant with a deep understanding of the Microsoft stack and extensive knowledge of DW methodologies and enterprise data modeling. Recognized for his analytical, conceptual, and problem-solving abilities, he has more than 25 years of commercial experience delivering business applications across a broad range of technologies. His expertise runs the gamut from project management, dimensional modeling, performance tuning, ETL design, development and optimization, and report and dashboard design to installation and administration.

In 2017 Philip received a Microsoft Data Platform MVP award for his contributions to the Power BI community site, and in 2018 he was named a top 10 influencer in the Power BI space. He can be found speaking at many data, analytic, and reporting events around the world. He is also the founder and organizer of the Wellington Power BI User Group. He can be reached through Twitter at PhilSeamark.

Thomas Martens has more than 20 years of experience in the fields of BI, DW, and analytics. In his current role as Principal Consultant Business Intelligence and Analytics, he helps large enterprises to implement sustainable analytical applications. He specializes in the visualization of data, and the application of analytical methods to large amounts of data. He recognizes DAX as a powerful query language available in many products and wants to leverage his hard-earned experience in creating solutions to bring DAX users to the next level. He can be reached at Twitter at tommartens68.

 

 

 

作者簡介(中文翻譯)

Philip Seamark 是一位經驗豐富的資料倉儲(DW)和商業智能(BI)顧問,對微軟技術堆疊有深入的了解,並具備廣泛的DW方法論和企業數據建模知識。他以其分析、概念和解決問題的能力而受到認可,在廣泛的技術領域擁有超過25年的商業應用交付經驗。他的專業知識涵蓋項目管理、維度建模、性能調優、ETL設計、開發和優化,以及報表和儀表板設計、安裝和管理。

2017年,Philip因其對Power BI社區網站的貢獻而獲得了微軟數據平台MVP獎,並於2018年被評為Power BI領域的十大影響力人物之一。他經常在世界各地的數據、分析和報告活動上發表演講。他還是Wellington Power BI用戶組的創始人和組織者。您可以通過Twitter聯繫他,帳號是PhilSeamark。

Thomas Martens 在商業智能(BI)、資料倉儲(DW)和分析領域擁有超過20年的經驗。作為首席顧問商業智能和分析,他幫助大型企業實施可持續的分析應用。他專注於數據可視化和對大量數據應用分析方法。他認識到DAX是一種強大的查詢語言,可在許多產品中使用,並希望利用自己的寶貴經驗創建解決方案,將DAX用戶帶到更高的水平。您可以通過Twitter聯繫他,帳號是tommartens68。