Excel Power Query and PowerPivot For Dummies(Paperback)

Michael Alexander

  • 出版商: For Dummies
  • 出版日期: 2016-04-04
  • 定價: $1,050
  • 售價: 6.0$630
  • 語言: 英文
  • 頁數: 288
  • 裝訂: Paperback
  • ISBN: 111921064X
  • ISBN-13: 9781119210641
  • 相關分類: Excel
  • 立即出貨(限量) (庫存=1)

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

商品描述

A guide to PowerPivot and Power Query no data cruncher should be without!

Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities.

Gone are the days of relatively small amounts of data—today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting.

  • Demonstrates how Power Query is used to discover, connect to, and import your data
  • Shows you how to use PowerPivot to model data once it's been imported
  • Offers guidance on using these tools to make analyzing data easier
  • Written by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brand

If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life—and work—easier.

商品描述(中文翻譯)

一本不可或缺的 PowerPivot 和 Power Query 指南,任何數據分析師都不能錯過!

想要熟悉 Microsoft Excel 提供的豐富工具和報表功能,包括 PowerPivot 和 Power Query 嗎?不用再找了!《Excel PowerPivot & Power Query For Dummies》將向您展示如何利用這套強大的新工具更有效地來源和整合「大數據」商業智能和儀表板報表。您將發現 PowerPivot 和 Power Query 不僅可以節省時間和簡化流程,還能大幅提升數據分析和報表能力。

相較於過去處理相對較小數量的數據的日子,當今的數據環境對商業分析師的要求更高。現在,有了這本友善且實用的指南,您將學會如何使用 PowerPivot 和 Power Query 將您的技能從單維度的試算表擴展到新的領域,如關聯式數據庫、數據整合和多維度報表。


  • 演示了如何使用 Power Query 發現、連接和導入數據

  • 向您展示了如何使用 PowerPivot 對導入的數據進行建模

  • 提供了使用這些工具使數據分析更輕鬆的指導

  • 由一位 Microsoft MVP 撰寫,以 For Dummies 品牌一貫的輕鬆有趣風格呈現

如果您每天都在分析數據,《Excel PowerPivot & Power Query For Dummies》將讓您快速上手使用 Excel 提供的豐富工具和報表功能,讓您的生活和工作更輕鬆。