Microsoft Power BI Cookbook

Brett Powell

商品描述

Key Features

  • From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all
  • Over 90 hands-on, technical examples, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications
  • Proven development techniques and guidance for implementing custom solutions with DAX and M languages

Book Description

This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence.

This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.

What you will learn

  • Cleanse, stage, and integrate your data sources with Power BI
  • Abstract data complexities and provide users with intuitive, self-service BI capabilities
  • Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations
  • Take advantage of the analytics and predictive capabilities of Power BI
  • Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security
  • Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refresh
  • Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI Solution

商品描述(中文翻譯)

主要特點



  • 從連接數據源到開發和部署沉浸式、適用於移動設備的儀表板和可視化,本書涵蓋了所有內容

  • 超過90個實用的技術示例、提示和用例,涵蓋了Power BI平台的各個方面,包括Power BI服務和移動應用程序

  • 證實的開發技巧和指南,用於使用DAX和M語言實現自定義解決方案


書籍描述


本書將提供使用所有主要Power BI工具和功能的詳細技術示例,並展示利用和整合這些技術和服務的高影響端到端解決方案。熟悉Power BI開發工具和服務,深入了解數據連接和轉換、建模、可視化和分析能力,並看到Power BI的DAX和M功能編程語言如何提供強大的解決方案,以應對商業智能中常見且具有挑戰性的場景。


本書將通過詳細的示例、高級設計和開發技巧以及改進現有Power BI項目的指南,激發並賦予您更多的Power BI能力。


您將學到什麼



  • 使用Power BI對數據源進行清理、分階段和集成

  • 抽象數據複雜性,為用戶提供直觀的自助商業智能能力

  • 通過DAX編程語言和動態、適用於儀表板的計算,構建業務邏輯和分析能力

  • 利用Power BI的分析和預測能力

  • 使解決方案更具動態性和用戶特定性和/或定義性,包括參數、函數和行級安全性的用例

  • 了解DirectQuery、實時連接和導入模式Power BI數據集的差異和影響,以及如何將內容部署到Power BI服務並安排刷新

  • 將其他Microsoft數據工具(如Excel和SQL Server Reporting Services)集成到您的Power BI解決方案中