Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources
暫譯: 使用 Power Query 和 M 在 Microsoft Excel 中進行資料混合：尋找、轉換和載入來自外部來源的資料
Aspin, Adam
相關主題
商品描述
Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel's Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to find data and pull that data into your local spreadsheet for further analysis. Leading databases are covered, including Microsoft Azure data sources and web sources, and you will learn how to access those sources from your Microsoft Excel spreadsheets.
Getting data into Excel is a prerequisite for using Excel's analytics capabilities. This book takes you beyond copying and pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server, and other sources.
Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows you how to create datasets and transformations. For advanced problems, there is help on the M language that is built into Excel, specifically to support mashing up data in support of business intelligence and analysis. If you are an Excel user, you won't want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world's leading analytics tool.
What You Will Learn
- Connect to a range of external data, from databases to Azure sources
- Ingest data directly into your spreadsheets, or into PowerPivot data models
- Cleanse and prepare external data so it can be used inside Excel
- Refresh data quickly and easily to always have the latest information
- Transform data into ready-to-use structures that fit the spreadsheet format
- Execute M language functions for complex data transformations
Who This Book Is For
Excel users who want to access data from external sources--including the Microsoft Azure platform--in order to create business intelligence reporting, dashboards, and visualizations. For Excel users needing to cleanse and rearrange such data to meet their own, specific needs.
商品描述(中文翻譯)
掌握將外部數據載入 Excel 的技巧，以便用於報告、圖表、儀表板和商業智慧。本書提供了 Microsoft Excel 的「取得與轉換」功能集的完整而徹底的解釋，展示了如何連接到各種外部數據庫和其他數據來源，以查找數據並將這些數據提取到本地電子表格中進行進一步分析。本書涵蓋了主要的數據庫，包括 Microsoft Azure 數據來源和網絡來源，您將學習如何從 Microsoft Excel 電子表格中訪問這些來源。
將數據導入 Excel 是使用 Excel 分析功能的前提。本書不僅僅是教您複製和粘貼，而是展示如何連接到托管在 Azure 雲端的企業數據庫，以及如何從 Oracle Database 和 SQL Server 等其他來源提取數據。
訪問數據僅是問題的一半，另一半涉及清理和重新排列數據，以使其在電子表格中變得有用。作者 Adam Aspin 將向您展示如何創建數據集和轉換。對於高級問題，本書提供了內建於 Excel 的 M 語言的幫助，特別是用於支持商業智慧和分析的數據整合。如果您是 Excel 用戶，您不會想錯過這本教您提取和準備外部數據以便在這個無疑是全球領先的分析工具中使用的書籍。
您將學到的內容：
- 連接到各種外部數據，從數據庫到 Azure 來源
- 直接將數據導入您的電子表格或 PowerPivot 數據模型
- 清理和準備外部數據，以便在 Excel 中使用
- 快速輕鬆地刷新數據，以始終擁有最新信息
- 將數據轉換為適合電子表格格式的可用結構
- 執行 M 語言函數以進行複雜的數據轉換
本書適合對象：
希望從外部來源（包括 Microsoft Azure 平台）訪問數據的 Excel 用戶，以創建商業智慧報告、儀表板和可視化。對於需要清理和重新排列這些數據以滿足自身特定需求的 Excel 用戶。
作者簡介
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 analytics stack.
Business intelligence has been Adam's principal focus for the last 20 years. He has applied his skills for a variety of clients in a range of industry sectors. He is the author of Apress books: SQL Server Data Integration Recipes, Pro Power BI Desktop (now in its third edition), Business Intelligence with SQL Server Reporting Services, and High Impact Data Visualization.
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, and SQL Server Integration Services and Power BI (both on-premise and in Azure).
A fluent French speaker, Adam has worked in France and Switzerland for many years.
作者簡介(中文翻譯)
亞當·阿斯平（Adam Aspin）是一位位於英國的獨立商業智慧顧問。他在 SQL Server 上工作超過 25 年。在這段時間內，他基於微軟分析堆疊開發了數十個報告和分析系統。
商業智慧是亞當過去 20 年的主要專注領域。他為各種行業的多位客戶應用他的技能。他是 Apress 出版的書籍作者，包括：SQL Server 數據整合食譜、Pro Power BI Desktop（目前已進入第三版）、使用 SQL Server Reporting Services 的商業智慧，以及 高影響力數據視覺化。
亞當畢業於牛津大學，最初在出版業開始他的職業生涯，隨後轉入資訊科技領域。數據庫很快成為他的熱情所在，他在這個領域的經驗涵蓋了 dBase、Oracle、Access 和 MySQL，偶爾也涉獵 DB2 的世界。然而，當使用 SQL Server Analysis Services、SQL Server Reporting Services 和 SQL Server Integration Services 以及 Power BI（無論是本地還是在 Azure 上）時，他最感自在。
亞當流利地講法語，並在法國和瑞士工作多年。
