Pro Data Mashup for Power Bi: Powering Up with Power Query and the M Language to Find, Load, and Transform Data
暫譯: Power BI 專業數據混合：利用 Power Query 和 M 語言尋找、加載及轉換數據

Aspin, Adam

Pro Data Mashup for Power Bi: Powering Up with Power Query and the M Language to Find, Load, and Transform Data
  • 出版商: Apress
  • 出版日期: 2022-08-26
  • 售價: $2,410
  • 貴賓價: 9.5 折 $2,290
  • 語言: 英文
  • 頁數: 485
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484285778
  • ISBN-13: 9781484285770
  • 相關分類: Power BI

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

相關主題

商品描述

This book provides all you need to find data from external sources and load and transform that data into Power BI where you can mine it for business insights and a competitive edge. This ranges from connecting to corporate databases such as Azure SQL and SQL Server to file-based data sources, and cloud- and web-based data sources. The book also explains the use of Direct Query and Live Connect to establish instant connections to databases and data warehouses and avoid loading data.
The book provides detailed guidance on techniques for transforming inbound data into normalized data sets that are easy to query and analyze. This covers data cleansing, data modification, and standardization as well as merging source data into robust data structures that can feed into your data model. You will learn how to pivot and transpose data and extrapolate missing values as well as harness external programs such as R and Python into a Power Query data flow. You also will see how to handle errors in source data and extend basic data ingestion to create robust and parameterized data load and transformation processes.

Everything in this book is aimed at helping you deliver compelling and interactive insight with remarkable ease using Power BI's built-in data load and transformation tools.

What You Will Learn

  • Connect Power BI to a range of external data sources
  • Prepare data from external sources for easy analysis in Power BI
  • Cleanse data from duplicates, outliers, and other bad values
  • Make live connections from which to refresh data quickly and easily
  • Apply advanced techniques to interpolate missing data

Who This Book Is For
All Power BI users from beginners to super users. Any user of the world's leading dashboarding tool can leverage the techniques explained in this book to turbo-charge their data preparation skills and learn how a wide range of external data sources can be harnessed and loaded into Power BI to drive their analytics. No previous knowledge of working with data, databases, or external data sources is required--merely the need to find, transform, and load data into Power BI..

商品描述(中文翻譯)

本書提供了您所需的一切，以從外部來源尋找數據，並將這些數據加載和轉換到 Power BI 中，讓您能夠挖掘商業洞察和獲得競爭優勢。這包括連接到企業數據庫，如 Azure SQL 和 SQL Server，以及基於文件的數據來源、雲端和網路數據來源。本書還解釋了如何使用 Direct Query 和 Live Connect 來建立與數據庫和數據倉庫的即時連接，並避免加載數據。

本書提供了有關將進來的數據轉換為易於查詢和分析的標準化數據集的詳細指導。這涵蓋了數據清理、數據修改和標準化，以及將源數據合併為強健的數據結構，以便能夠供應到您的數據模型中。您將學習如何透視和轉置數據，推斷缺失值，以及如何將外部程序如 R 和 Python 整合到 Power Query 數據流中。您還將看到如何處理源數據中的錯誤，並擴展基本數據攝取，以創建強健且參數化的數據加載和轉換過程。

本書的所有內容旨在幫助您使用 Power BI 的內建數據加載和轉換工具，輕鬆地提供引人注目的互動洞察。

您將學到什麼


  • 將 Power BI 連接到多種外部數據來源

  • 準備來自外部來源的數據，以便在 Power BI 中輕鬆分析

  • 清理數據中的重複值、異常值和其他不良值

  • 建立即時連接，以快速輕鬆地刷新數據

  • 應用高級技術來插值缺失數據

本書適合誰
所有 Power BI 使用者，從初學者到高級使用者。任何使用全球領先的儀表板工具的用戶都可以利用本書中解釋的技術來提升他們的數據準備技能，並學習如何利用各種外部數據來源，將其加載到 Power BI 中以推動分析。不需要具備處理數據、數據庫或外部數據來源的先前知識--僅需有尋找、轉換和將數據加載到 Power BI 的需求。

作者簡介

Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for over 25 years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft Data Platform.

A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe when using SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Azure Data Factory, Azure Synapse and, of course, Power BI.

Business Intelligence has been Adam's principal focus for 20 years. He has applied his skills for a range of clients in a range of industry sectors. He is the author of SQL Server Data Integration Recipes; Pro Power BI Desktop (now in its third edition); Business Intelligence with SQL Server Reporting Services; High Impact Data Visualization; Data Mashup using Microsoft Excel using Power Query and M, and Pro Power BI Theme Creation--all with Apress.

A fluent French speaker, Adam has worked in France and Switzerland for many years.

作者簡介(中文翻譯)

亞當·阿斯平是一位位於英國的獨立商業智慧顧問。他在 SQL Server 上工作超過 25 年。在這段時間內，他基於 Microsoft Data Platform 開發了數十個報告和分析系統。

亞當畢業於牛津大學，最初在出版業開始他的職業生涯，隨後轉入資訊科技領域。資料庫很快成為他的熱情所在，他在這個領域的經驗涵蓋了 dBase、Oracle、Access 和 MySQL，偶爾也涉獵 DB2 的世界。然而，當使用 SQL Server Analysis Services、SQL Server Reporting Services、SQL Server Integration Services、Azure Data Factory、Azure Synapse，以及當然還有 Power BI 時，他最感自在。

商業智慧是亞當 20 年來的主要專注點。他為各行各業的客戶應用他的技能。他是《SQL Server Data Integration Recipes》、《Pro Power BI Desktop》（目前已進入第三版）、《Business Intelligence with SQL Server Reporting Services》、《High Impact Data Visualization》、《Data Mashup using Microsoft Excel using Power Query and M》，以及《Pro Power BI Theme Creation》的作者，這些書籍均由 Apress 出版。

亞當流利地講法語，並在法國和瑞士工作多年。

類似商品