Advanced Analytics in Power Bi with R and Python: Ingesting, Transforming, Visualizing
暫譯: 使用 R 和 Python 在 Power BI 中進行進階分析:數據攝取、轉換與視覺化

Wade, Ryan

  • 出版商: Apress
  • 出版日期: 2020-10-13
  • 定價: $1,800
  • 售價: 8.0$1,440
  • 語言: 英文
  • 頁數: 393
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484258282
  • ISBN-13: 9781484258286
  • 相關分類: Power BIPython程式語言R 語言
  • 立即出貨 (庫存=1)

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

相關主題

商品描述

This easy-to-follow guide provides R and Python recipes to help you learn and apply the top languages in the field of data analytics to your work in Microsoft Power BI. Data analytics expert and author Ryan Wade shows you how to use R and Python to perform tasks that are extremely hard to do, if not impossible, using native Power BI tools without Power BI Premium capacity. For example, you will learn to score Power BI data using custom data science models, including powerful models from Microsoft Cognitive Services.
The R and Python languages are powerful complements to Power BI. They enable advanced data transformation techniques that are difficult to perform in Power BI in its default configuration, but become easier through the application of data wrangling features that languages such as R and Python support. If you are a BI developer, business analyst, data analyst, or a data scientist who wants to push Power BI and transform it from being just a business intelligence tool into an advanced data analytics tool, then this is the book to help you to do that.

What You Will Learn

  • Create advanced data visualizations through R using the ggplot2 package
  • Ingest data using R and Python to overcome the limitations of Power Query
  • Apply machine learning models to your data using R and Python
  • Incorporate advanced AI in Power BI via Microsoft Cognitive Services, IBM Watson, and pre-trained models in SQL Server Machine Learning Services
  • Perform string manipulations not otherwise possible in Power BI using R and Python


Who This Book Is For
Power users, data analysts, and data scientists who want to go beyond Power BI's built-in functionality to create advanced visualizations, transform data in ways not otherwise supported, and automate data ingestion from sources such as SQL Server and Excel in a more succinct way

商品描述(中文翻譯)

這本易於遵循的指南提供了 R 和 Python 的範例,幫助您學習並將這些數據分析領域的頂尖語言應用於 Microsoft Power BI 的工作中。數據分析專家及作者 Ryan Wade 向您展示如何使用 R 和 Python 執行在沒有 Power BI Premium 容量的情況下,使用原生 Power BI 工具極其困難甚至不可能完成的任務。例如,您將學會使用自訂數據科學模型對 Power BI 數據進行評分,包括來自 Microsoft Cognitive Services 的強大模型。

R 和 Python 語言是 Power BI 的強大補充。它們使得在 Power BI 的預設配置中難以執行的高級數據轉換技術變得可行,但通過 R 和 Python 等語言所支持的數據處理功能,這些技術變得更容易。如果您是 BI 開發人員、業務分析師、數據分析師或希望推動 Power BI,將其從僅僅是一個商業智能工具轉變為一個高級數據分析工具的數據科學家,那麼這本書將幫助您實現這一目標。

您將學到的內容:

- 使用 ggplot2 套件通過 R 創建高級數據可視化
- 使用 R 和 Python 進行數據攝取,以克服 Power Query 的限制
- 使用 R 和 Python 對您的數據應用機器學習模型
- 通過 Microsoft Cognitive Services、IBM Watson 和 SQL Server Machine Learning Services 中的預訓練模型在 Power BI 中整合高級 AI
- 使用 R 和 Python 執行在 Power BI 中無法實現的字符串操作

這本書適合於:

希望超越 Power BI 內建功能的高級用戶、數據分析師和數據科學家,以創建高級可視化、以不支持的方式轉換數據,並以更簡潔的方式自動從 SQL Server 和 Excel 等來源攝取數據。

作者簡介

Ryan Wade is a data analytic professional with over 20 years of experience. His education and work experience enable him to have a holistic view of analytics from a technical and business viewpoint. He has an MCSE with an emphasis on BI reporting and Microsoft R. He has an advanced understanding of R, Python, DAX, T-SQL, M, and VBA. He knows how to leverage those programming languages for on-premise and cloud-based data analytics solutions using the Microsoft Data Platform.

Ryan is a data analytics enthusiast and has spoken at R meetups, Python meetups, SQLSaturdays, TDWI Conference, and PASS Summit about various data analytics topics. He is the developer of a comprehensive online course for ExcelTv showing how to implement R in Power BI for advanced data analytics and data visualization.

 

作者簡介(中文翻譯)

Ryan Wade 是一位擁有超過 20 年經驗的數據分析專業人士。他的教育背景和工作經驗使他能夠從技術和商業的角度對分析有全面的理解。他擁有 MCSE 認證,專注於商業智慧報告和 Microsoft R。他對 R、Python、DAX、T-SQL、M 和 VBA 有深入的理解。他知道如何利用這些程式語言來實現基於 Microsoft Data Platform 的本地和雲端數據分析解決方案。

Ryan 是一位數據分析愛好者,曾在 R 會議、Python 會議、SQL Saturdays、TDWI 會議和 PASS 峰會上發表有關各種數據分析主題的演講。他是 ExcelTv 的一個綜合在線課程的開發者,該課程展示了如何在 Power BI 中實現 R 以進行高級數據分析和數據可視化。