PowerPivot for the Data Analyst: Microsoft Excel 2010 (Paperback)
暫譯: 數據分析師的 PowerPivot：Microsoft Excel 2010 (平裝本)

Bill Jelen

PowerPivot for the Data Analyst: Microsoft Excel 2010 (Paperback)
  • 出版商: QUE
  • 出版日期: 2010-06-13
  • 售價: $1,520
  • 貴賓價: 9.5 折 $1,444
  • 語言: 英文
  • 頁數: 336
  • 裝訂: Paperback
  • ISBN: 0789743159
  • ISBN-13: 9780789743152
  • 相關分類: Excel

    • 已過版

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

相關主題

商品描述

ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY!

Use Microsoft’s free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time!

Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more.

Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now—without IT’s help!

 

•  Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources

•  Analyze multiple tables together, without complicated VLOOKUPs

•  Format, sort, and filter data in the PowerPivot window

•  Add calculated columns using new DAX functions

•  Create powerful reports from PowerPivot data–and format them so executives instantly get your point

•  Discover PivotTable tricks that work even better in PowerPivot

•  Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers

•  Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields

•  Compare today’s sales to yesterday’s–or to sales from the parallel period last fiscal year.

•  Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months.

 

About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

•  Dramatically increase your productivity–saving you 50 hours a year, or more

•  Present proven, creative strategies for solving real-world problems

•  Show you how to get great results, no matter how much data you have

•  Help you avoid critical mistakes that even experienced users make

 

 

 

商品描述(中文翻譯)

分析大量商業數據，讓過程更快、更簡單且更準確！

使用微軟免費的 PowerPivot 外掛程式，對 Excel 2010 進行分析，從任何來源分析龐大的數據，輕鬆執行最先進的商業分析，並在更短的時間內做出更好的決策！

簡單的逐步指導將帶您安裝 PowerPivot、導入數據、使用 PowerPivot 的樞紐分析表、使用超強的 DAX 函數和度量、報告以便列印或發佈到 SharePoint，還有更多內容。

無論您對 Excel 數據分析的經驗如何，本書將幫助您使用 PowerPivot 立即獲得正確的答案—無需 IT 的幫助！

• 從電子表格、SQL Server、Access、Oracle、文本文件、Atom 數據源及其他來源導入和整合數據
• 同時分析多個表格，無需複雜的 VLOOKUP
• 在 PowerPivot 窗口中格式化、排序和篩選數據
• 使用新的 DAX 函數添加計算列
• 從 PowerPivot 數據創建強大的報告—並格式化它們，以便高層能立即理解您的要點
• 發現在 PowerPivot 中效果更佳的樞紐分析表技巧
• 在一個工作表上控制多個樞紐分析表元素，使用一組 Excel 2010 切片器
• 使用 DAX Measures 快速執行以前使用計算欄位時困難或不可能的任務
• 將今天的銷售與昨天的銷售進行比較—或與上個財年的同一時期的銷售進行比較
• 使用命名集準備不對稱報告，顯示過去幾個月的實際數據並計劃未來幾個月的數據

關於 MrExcel 圖書館：每本 MrExcel 圖書館的書籍都針對一組特定的關鍵 Excel 任務，並提供專注的技能和範例，以快速有效地執行這些任務。這些書籍由微軟 Excel MVP 及領先 Excel 解決方案網站 MrExcel.com 的創始人 Bill Jelen 精選，將會：

• 顯著提高您的生產力—每年節省您 50 小時或更多
• 提供解決現實問題的經驗豐富且創新的策略
• 向您展示如何獲得優秀的結果，無論您擁有多少數據
• 幫助您避免即使是經驗豐富的用戶也會犯的關鍵錯誤

類似商品