Excel Power Pivot & Power Query for Dummies
暫譯: Excel Power Pivot 與 Power Query 入門指南

Alexander, Michael

Excel Power Pivot & Power Query for Dummies
  • 出版商: For Dummies
  • 出版日期: 2022-03-02
  • 售價: $1,600
  • 貴賓價: 9.5 折 $1,520
  • 語言: 英文
  • 頁數: 288
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1119844487
  • ISBN-13: 9781119844488
  • 相關分類: Excel

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

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

相關主題

商品描述

Learn to crunch huge amounts of data with PowerPivot and Power Query

Do you have a ton of data you need to make sense of? Microsoft's Excel program can handle amazingly large data sets, but you'll need to get familiar with PowerPivot and Power Query to get started.

And that's where Dummies comes in. With step-by-step instructions--accompanied by ample screenshots--Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization's data. Then use PowerPivot to model it in Excel. You'll also learn to:

  • Make use of databases to store large amounts of data
  • Use custom functions to extend and enhance Power Query
  • Add the functionality of formulas to PowerPivot and publish data to SharePoint

If you're expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly.

商品描述(中文翻譯)

學習使用 PowerPivot 和 Power Query 處理大量數據

你是否有大量數據需要理解？微軟的 Excel 程式可以處理驚人的大型數據集，但你需要熟悉 PowerPivot 和 Power Query 才能開始。

這就是 Dummies 的用武之地。通過逐步的指導—配合豐富的截圖—Excel PowerPivot & Power Query For Dummies 將教你如何節省時間、簡化流程，並增強數據分析和報告。使用 Power Query 發現、連接並導入你組織的數據。然後使用 PowerPivot 在 Excel 中建模。你還將學會：


  • 利用數據庫存儲大量數據

  • 使用自定義函數擴展和增強 Power Query

  • 將公式的功能添加到 PowerPivot 並將數據發佈到 SharePoint

如果你需要處理、解釋和報告大量數據，Excel PowerPivot & Power Query For Dummies 為你提供了快速上手所需的工具。

作者簡介

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years' experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.

作者簡介(中文翻譯)

邁克爾·亞歷山大是Slalom Consulting的高級顧問，擁有超過15年的數據管理和報告經驗。他是多本關於使用Microsoft Excel進行商業分析的書籍的作者，並因其對Excel社群的貢獻而被評選為Microsoft Excel MVP。

類似商品