Pro Data Mashup for Power Bi: Powering Up with Power Query and the M Language to Find, Load, and Transform Data

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，以及基於文件的數據源，雲和基於Web的數據源。該書還解釋了使用直接查詢和即時連接來建立與數據庫和數據倉庫的即時連接，避免加載數據的方法。

該書提供了詳細的指導，介紹了將入站數據轉換為易於查詢和分析的規範化數據集的技術。這包括數據清理、數據修改和標準化，以及將源數據合併到可供餵入數據模型的強大數據結構中。您將學習如何進行數據透視和轉置，推斷缺失值，以及如何將外部程序（如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.

Adam Aspin是一位獨立的商業智能顧問，位於英國。他在SQL Server上工作超過25年。在此期間，他基於Microsoft Data Platform開發了數十個報告和分析系統。

Adam畢業於牛津大學，他的職業生涯始於出版業，後來轉向IT。數據庫很快成為他的熱情所在，他在這個領域的經驗涵蓋了從dBase到Oracle，從Access到MySQL，偶爾也涉足DB2的世界。然而，當使用SQL Server Analysis Services、SQL Server Reporting Services、SQL Server Integration Services、Azure Data Factory、Azure Synapse和當然還有Power BI時，他最為熟悉並且感到最自在。

商業智能一直是Adam的主要關注領域，他將自己的技能應用於各種行業的客戶。他是Apress出版社的《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》的作者。

Adam精通法語，多年來在法國和瑞士工作。