Power Query for Power BI and Excel (Paperback)

Christopher Webb, Crossjoin Consulting Limited

  • 出版商: Apress
  • 出版日期: 2014-06-26
  • 售價: $2,320
  • 貴賓價: 9.5$2,204
  • 語言: 英文
  • 頁數: 272
  • 裝訂: Paperback
  • ISBN: 1430266910
  • ISBN-13: 9781430266914
  • 相關分類: ExcelPower BI
  • 海外代購書籍(需單獨結帳)

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

相關主題

商品描述

Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems.

 

Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren’t going to be possible from just the GUI interface that is covered in most other books. You’ll have full command of the GUI, and you’ll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis. 

  • Teaches the basics of using Power Query to load data into Excel
  • Helps you solve common, data-related problems with Power Query
  • Shows how to write your own solutions in the powerful M language

What you’ll learn


  • Import data from sources including relational databases, text files, web pages, and Excel workbooks.
  • Import from more exotic sources such as Facebook, Windows Azure Marketplace, Wikipedia, and OData feeds within and outside your organization.
  • Build repeatable processes to filter, clean, aggregate, and transform your data.
  • Load your data into an Excel table or directly into the Excel 2013 Data Model.
  • Write complex expressions in Power Query’s M expression language.
  • Share queries and their data with other users in your organization.
  • Position your data for further analysis using Power View, Power Map, Power Pivot, and the rest of Microsoft’s Power BI suite.

Who this book is for

Power Query for Power BI and Excel is aimed at serious Excel and Power BI users who need to import data into a worksheet. Whether you are an analyst, report writer, business intelligence consultant, or just “that guy” whose job it is to prepare the monthly sales dashboard, you’ll learn how Power Query can make your life easier. Power Query for Power BI and Excel is especially important for Excel and BI power users who want to work directly in the M language that underlies all of Power Query’s functionality.

Table of Contents

  1. Power Query and When to Use It
  2. Data Sources
  3. Transformations
  4. Tables and the Excel Data Model
  5. Expressions in the M Language
  6. Multiple Data Sources
  7. Power BI and Sharing
  8. Common Problems Solved

商品描述(中文翻譯)

Power Query for Power BI and Excel 是一本針對厭倦將資料複製貼上到 Excel 工作表的人而設的書籍。Power Query 是 Microsoft Power BI 套件的一部分,它是一個自動化將資料載入 Excel 的工具,可以節省您大量乏味、重複且容易出錯的工作時間!Power Query 讓從多種不同資料來源中提取資料、過濾資料、聚合資料、清理資料和進行計算變得輕鬆,最後將資料載入工作表或直接載入 Power Pivot 使用的新 Excel 2013 資料模型中。這本簡潔實用的書提供了完整的 Power Query 指南,以及如何使用它解決所有 Excel 資料載入問題。

Power Query for Power BI and Excel 不僅僅停留在 Power Query 的表面,它深入探討了底層的 M 語言,向您展示了一些在大多數其他書籍中所涵蓋的 GUI 介面無法實現的驚人功能。您將完全掌握 GUI,並能夠使用 M 語言超越 GUI 提供的功能。這本書的深度使其成為那些在追求商業智能數據分析中將 Power BI 和 Excel 推向極限的人必備的物品。

這本書教授使用 Power Query 將資料載入 Excel 的基礎知識,幫助您解決常見的與資料相關的問題,並展示如何使用強大的 M 語言編寫自己的解決方案。

您將學到以下內容:
- 從包括關聯式資料庫、文字檔案、網頁和 Excel 工作簿在內的來源中匯入資料。
- 從更特殊的來源,如 Facebook、Windows Azure Marketplace、Wikipedia 和組織內外的 OData 資料源中匯入資料。
- 建立可重複使用的過濾、清理、聚合和轉換資料的流程。
- 將資料載入 Excel 表格或直接載入 Excel 2013 資料模型。
- 在 Power Query 的 M 表達式語言中撰寫複雜的表達式。
- 與組織中的其他使用者共享查詢及其資料。