The Ultimate Power Query Cookbook for Power Bi and Excel: Leveraging Power Query for Collecting, Combining and Transforming Your Data

Raimato, Dominick

  • 出版商: BPB Publications
  • 出版日期: 2024-01-22
  • 售價: $1,670
  • 貴賓價: 9.5$1,587
  • 語言: 英文
  • 頁數: 398
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 9355517394
  • ISBN-13: 9789355517395
  • 相關分類: ExcelPower BI
  • 海外代購書籍(需單獨結帳)

相關主題

商品描述

"The Ultimate Power Query Cookbook for Power BI and Excel" serves up easy-to-follow recipes that transform data into meaningful insights. You will learn to clean messy files, combine datasets, and even use AI magic to Power BI and Excel. This book will walk you through the basics of getting connected to data with Power Query. You will understand how to ingest data from files, folders, databases, websites, APIs, and other third party sources. Once connected, you will learn how to transform the data so it is ready for your use. We will clean up columns, filter, replace, extract, and classify data in Power Query to meet your needs. The book offers over 100 practical recipes, ensuring you understand each step with clear explanations and examples.

商品描述(中文翻譯)

「Power BI 和 Excel 的終極 Power Query 食譜」提供易於遵循的食譜,將數據轉化為有意義的洞察力。您將學習如何清理混亂的文件,合併數據集,甚至使用 AI 魔法來處理 Power BI 和 Excel。本書將引導您了解使用 Power Query 連接數據的基礎知識。您將了解如何從文件、文件夾、數據庫、網站、API 和其他第三方來源中提取數據。一旦連接成功,您將學習如何轉換數據,使其符合您的需求。我們將在 Power Query 中清理列、過濾、替換、提取和分類數據。本書提供了超過100個實用的食譜,並通過清晰的解釋和示例確保您理解每一步驟。