Pro Dax with Power Bi: Business Intelligence with Powerpivot and SQL Server Analysis Services Tabular
暫譯: 專業 DAX 與 Power BI：使用 Powerpivot 和 SQL Server 分析服務的商業智慧

Seamark, Philip, Martens, Tom

Pro Dax with Power Bi: Business Intelligence with Powerpivot and SQL Server Analysis Services Tabular
  • 出版商: Apress
  • 出版日期: 2019-12-11
  • 售價: $2,040
  • 貴賓價: 9.5 折 $1,938
  • 語言: 英文
  • 頁數: 280
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484248961
  • ISBN-13: 9781484248966
  • 相關分類: MSSQL、Power BI、SQL

    • 海外代購書籍(需單獨結帳)

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

相關主題

商品描述

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（數據分析表達式），這是 Power BI 中使用的公式語言，Power BI 是微軟領先的自助式商業智慧應用程式，並涵蓋其他產品，如 PowerPivot 和 SQL Server Analysis Services Tabular。您將學習如何利用 DAX 的進階應用來解決複雜的任務。

任務之所以看起來複雜，往往是因為缺乏理解或對核心原則的誤解，以及某些組件之間的互動方式。本書的作者使用解決方案和範例來教您如何解決複雜的問題。他們解釋了重要概念的複雜運作，例如過濾上下文（Filter Context）和上下文轉換（Context Transition）。解釋了如何通過結合 DAX 的基本構建塊（如度量值、表格過濾和數據來源），使 Power BI 能夠產生令人印象深刻的分析能力。在《Pro Dax with Power BI》中，這些構建塊被用來創建和組合解決方案，以應對進階 DAX 問題，讓您能夠獨立構建解決方案來解決自己的複雜問題，並從數據中獲得有價值的見解。

您將學到什麼


  • 理解 DAX 的複雜運作以解決進階問題

  • 將問題拆解為可管理的部分，以創建自己的解決方案

  • 應用預定義的解決方案來解決問題，並逐步回溯到 DAX 的機制，以了解這種強大查詢語言的基礎

  • 通過學習最佳實踐，全面掌握 DAX，這是一種新興的語言

本書適合誰

任何希望使用 Power BI 建立進階和複雜模型的人。有一些撰寫 DAX 的經驗會有所幫助，但如果您有其他數據查詢語言（如 MDX 或 SQL）的經驗，則不必是必需的。

作者簡介

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) 顧問，對 Microsoft 技術堆疊有深入的理解，並擁有廣泛的 DW 方法論和企業資料建模知識。他因其分析、概念和解決問題的能力而受到認可，擁有超過 25 年的商業經驗，提供各種技術的商業應用。他的專業範疇涵蓋專案管理、維度建模、效能調優、ETL 設計、開發和優化，以及報告和儀表板設計到安裝和管理。

在 2017 年，Philip 因對 Power BI 社群網站的貢獻而獲得 Microsoft Data Platform MVP 獎，並在 2018 年被評選為 Power BI 領域的前 10 大影響者。他經常在全球各地的資料、分析和報告活動中發表演講。他也是惠靈頓 Power BI 使用者小組的創辦人和組織者。您可以透過 Twitter 聯繫他，帳號為 PhilSeamark。

Thomas Martens 在 BI、DW 和分析領域擁有超過 20 年的經驗。在他目前擔任商業智慧和分析首席顧問的角色中，他幫助大型企業實施可持續的分析應用程式。他專注於資料的可視化，以及將分析方法應用於大量資料。他認為 DAX 是許多產品中可用的強大查詢語言，並希望利用他辛苦獲得的經驗來創建解決方案，幫助 DAX 使用者提升到更高的水平。您可以透過 Twitter 聯繫他，帳號為 tommartens68。

類似商品