Excel Power Pivot & Power Query for Dummies

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才能開始使用。

這就是《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.

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