Learn Power Query: A low-code approach to connect and transform data from multiple sources for Power BI and Excel
暫譯: 學習 Power Query：一種低程式碼方法，連接並轉換來自多個來源的數據，以便用於 Power BI 和 Excel

Sparrow, Warren, Foulkes, Linda

Learn Power Query: A low-code approach to connect and transform data from multiple sources for Power BI and Excel
  • 出版商: Packt Publishing
  • 出版日期: 2020-07-17
  • 售價: $1,520
  • 貴賓價: 9.5 折 $1,444
  • 語言: 英文
  • 頁數: 428
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1839219718
  • ISBN-13: 9781839219719
  • 相關分類: Excel、Power BI

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

相關主題

商品描述

Discover how you can combine data from various sources to create data models to suit your business requirements with the help of this clear and concise guide

Key Features

  • Understand how Power Query overcomes the shortcomings of Excel Power Pivot in handling complex data
  • Create customized dashboards and multi-dimensional reports using Power Query and Power BI
  • Learn the Power Query M language and write advanced queries using custom functions

Book Description

Power Query is a data connection technology that allows you to connect, combine, and refine data from multiple sources to meet your business analysis requirements. With this Power Query book, you'll be empowered to work with a variety of data sources to create interactive reports and dashboards using Excel and Power BI.

You'll start by learning how to access Power Query across different versions of Excel and install the Power BI engine. After you've explored Power Pivot, you'll see why Excel users find it challenging to clean data in Power Pivot and learn how Power Query can help to tackle the problem. The book will show you how to transform data using the Query Editor and write functions in Power Query. A dedicated section will focus on functions such as IF, Index, and Modulo, and creating parameters to alter query paths in a table. You'll also work with dashboards, get to grips with multi-dimensional reporting, and create automated reports. As you advance, you'll cover the M formula language in Power Query, delve into the basic M syntax, and write the M query language with the help of examples such as loading all library functions offline in Excel and Power BI. Finally, the book will demonstrate the difference between M and DAX and show how results are produced in M.

By the end of this book, you'll be ready to create impressive dashboards and multi-dimensional reports in Power Query and turn data into valuable insights.

What you will learn

  • Convert worksheet data into a table format ready for query output
  • Create a dynamic connection between an Access database and Excel workbook
  • Reshape tabular data by altering rows, columns, and tables using various Power Query tools
  • Create new columns automatically from filenames and sheet tabs, along with multiple Excel data files
  • Streamline and automate reports from multiple sources
  • Explore different customization options to get the most out of your dashboards
  • Understand the difference between the DAX language and Power Query's M language

Who this book is for

This Power Query book is for business analysts, data analysts, BI professionals, and Excel users looking to take their skills to the next level by learning how to collect, combine, and transform data into insights using Power Query. Working knowledge of Excel and experience in constructing and troubleshooting Excel formulas and functions is expected.

商品描述(中文翻譯)

發現如何結合來自各種來源的數據，以創建符合您業務需求的數據模型，這本清晰簡明的指南將為您提供幫助

主要特點


  • 了解 Power Query 如何克服 Excel Power Pivot 在處理複雜數據方面的不足

  • 使用 Power Query 和 Power BI 創建自定義儀表板和多維報告

  • 學習 Power Query M 語言，並使用自定義函數編寫高級查詢

書籍描述

Power Query 是一種數據連接技術，允許您連接、結合和精煉來自多個來源的數據，以滿足您的業務分析需求。通過這本 Power Query 書籍，您將能夠使用 Excel 和 Power BI 與各種數據來源合作，創建互動式報告和儀表板。

您將首先學習如何在不同版本的 Excel 中訪問 Power Query 並安裝 Power BI 引擎。在探索 Power Pivot 之後，您將了解為什麼 Excel 用戶在 Power Pivot 中清理數據會遇到挑戰，並學習 Power Query 如何幫助解決這個問題。這本書將向您展示如何使用查詢編輯器轉換數據，並在 Power Query 中編寫函數。一個專門的部分將重點介紹 IF、Index 和 Modulo 等函數，以及創建參數以改變表中的查詢路徑。您還將學習儀表板的使用，掌握多維報告，並創建自動化報告。隨著進展，您將涵蓋 Power Query 中的 M 公式語言，深入了解基本的 M 語法，並通過示例編寫 M 查詢語言，例如在 Excel 和 Power BI 中離線加載所有庫函數。最後，這本書將演示 M 和 DAX 之間的區別，並展示如何在 M 中生成結果。

在本書結束時，您將能夠在 Power Query 中創建令人印象深刻的儀表板和多維報告，並將數據轉化為有價值的見解。

您將學到什麼


  • 將工作表數據轉換為準備查詢輸出的表格格式

  • 在 Access 數據庫和 Excel 工作簿之間創建動態連接

  • 使用各種 Power Query 工具重塑表格數據，通過改變行、列和表格

  • 自動從文件名和工作表標籤創建新列，以及多個 Excel 數據文件

  • 簡化和自動化來自多個來源的報告

  • 探索不同的自定義選項，以充分利用您的儀表板

  • 了解 DAX 語言和 Power Query 的 M 語言之間的區別

本書適合誰

這本 Power Query 書籍適合商業分析師、數據分析師、BI 專業人士和希望通過學習如何收集、結合和轉換數據為見解來提升技能的 Excel 用戶。預期具備 Excel 的工作知識以及構建和排除 Excel 公式和函數的經驗。

作者簡介

Linda Foulkes is a Microsoft Office Master Trainer, Certified Educator, and Microsoft Innovative Expert Educator and Trainer with an educational and corporate background spanning over 25 years. As well as being certified as an IT trainer, Linda represented South Africa at the Microsoft Global Forum in Redmond in 2015. She has certified and coached students to compete at the Microsoft Office Specialist Championships in Texas. She has also published Learn Microsoft Office 2019 through Packt. Linda has also presented at conferences and conducted webinars for SchoolNet SA, and hosted TeachMeets and MicrosoftMeets. She has a keen interest in e-learning and has developed e-learning paths and content for the Microsoft Office suite of programs.

Warren Sparrow is a Microsoft, Adobe, and National Geographic Certified Educator. He has been a Microsoft Innovative Expert Educator for the last 6 years, and a fellow in 2015. Warren is regularly invited to be a guest speaker at different global educational events, including the annual Microsoft conference on Office 365 in 2015. His core focus is long-term strategy, training, and technology implementation. He has provided training and development in both the education and corporate sectors. He also played an advisory role to the Western Cape Education Department (South Africa), giving assistance on the roll-out of hardware and software, as well as the training of educators and the implementation of technology in school classrooms

作者簡介(中文翻譯)

琳達·福克斯擁有超過25年的教育和企業背景，是微軟Office大師培訓師、認證教育工作者以及微軟創新專家教育工作者和培訓師。除了獲得IT培訓師認證外，琳達於2015年代表南非參加了在雷德蒙德舉行的微軟全球論壇。她曾認證並指導學生參加在德克薩斯州舉行的微軟Office專家錦標賽。她還通過Packt出版了《學習微軟Office 2019》。琳達曾在會議上發表演講，並為SchoolNet SA舉辦網絡研討會，還主持了TeachMeets和MicrosoftMeets。她對電子學習有濃厚的興趣，並為微軟Office套件開發了電子學習路徑和內容。

沃倫·斯帕羅是微軟、Adobe和國家地理的認證教育工作者。在過去的6年中，他一直是微軟創新專家教育工作者，並於2015年成為研究員。沃倫經常受邀在不同的全球教育活動中擔任嘉賓演講者，包括2015年舉行的微軟Office 365年度會議。他的核心重點是長期策略、培訓和技術實施。他在教育和企業部門提供培訓和發展服務。他還擔任南非西開普省教育部的顧問，協助推動硬體和軟體的部署，以及教育工作者的培訓和技術在學校教室中的實施。

目錄大綱

  1. Installation and Setup
  2. Power Pivot Basics, Inadequacies, and Data Management
  3. Introduction to the Power Query Interface
  4. Connecting to Various Data Sources using Get and Transform
  5. Transforming Power Query Data
  6. Advanced Power Queries and Functions
  7. Automating Reports in Power Query
  8. Creating Dashboards with Power Query
  9. Working with M
  10. Examples of M Usage
  11. Creating a Basic Custom Function
  12. Differences between DAX and M

目錄大綱(中文翻譯)


  1. Installation and Setup

  2. Power Pivot Basics, Inadequacies, and Data Management

  3. Introduction to the Power Query Interface

  4. Connecting to Various Data Sources using Get and Transform

  5. Transforming Power Query Data

  6. Advanced Power Queries and Functions

  7. Automating Reports in Power Query

  8. Creating Dashboards with Power Query

  9. Working with M

  10. Examples of M Usage

  11. Creating a Basic Custom Function

  12. Differences between DAX and M

類似商品