Microsoft ® Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop (Paperback)
暫譯: Microsoft® Office 2007 商業智慧：桌面報告、分析與衡量 (平裝本)

Doug Harts

Microsoft ® Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop (Paperback)
  • 出版商: McGraw-Hill Education
  • 出版日期: 2008-01-01
  • 定價: $1,240
  • 售價: 1.6 折 $199
  • 語言: 英文
  • 頁數: 444
  • 裝訂: Paperback
  • ISBN: 0071494243
  • ISBN-13: 9780071494243
  • 相關分類: Excel、Microsoft Azure、SharePoint

    • 立即出貨(限量) (庫存=1)

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

商品描述

Description

This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today's networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you're already using to help you in your everyday work.

  • Create Excel PivotTables and PivotCharts and apply Conditional Formatting
  • Convert Excel spreadsheets into Excel Tables with Conditional Formatting and Charting
  • Connect external data to Excel using Office Data Connections and SharePoint
  • Create SharePoint dashboards that display data from multiple sources
  • Add Key Performance Indicators and Excel Services reports to your dashboards
  • Harness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster Diagrams
  • Generate integrated PerformancePoint Scorecards
  • Create Visio PivotDiagrams and Windows Mobile spreadsheets

Table of Contents

Foreword
Preface
Acknowledgments
Chapter 1. Introduction to Microsoft Office BI Concepts
Chapter 2. PivotTables, PivotCharts, and Conditional Formatting
Chapter 3. Excel Tables: Conditional Formatting, What-If and Statistics, and Charts
Chapter 4. Excel and External Data: Files, Databases, Cubes, and Data from the Internet
Chapter 5. Excel and SharePoint: Reports, Key Performance Indicators, and Dashboards
Chapter 6. Excel and Data Mining: Key Influencers, Categories, and Forecasting
Chapter 7. PerformancePoint: Dashboards, Scorecards, and Key Performance Indicators
Chapter 8. Office BI: Office, Visio, Windows Mobile, Office Online, SQL Server, and Virtual Earth
Index

商品描述(中文翻譯)

**描述**

這本權威的書籍是一本實用指南，介紹了 Office 2007 中強大的新協作商業智慧工具。透過真實世界的範例和清晰的解釋，《Microsoft Office 2007 商業智慧：桌面報告、分析與衡量》將教您如何在當今網絡化的辦公室中，使用 Excel、Excel Services、SharePoint 和 PerformancePoint，處理各種獨立和外部數據。您將學會如何分析數據並生成報告、計分卡和儀表板，利用您日常工作中已經使用的 Office 工具。

- 創建 Excel 樞紐分析表和樞紐分析圖，並應用條件格式
- 將 Excel 試算表轉換為具有條件格式和圖表的 Excel 表格
- 使用 Office 數據連接和 SharePoint 將外部數據連接到 Excel
- 創建顯示來自多個來源數據的 SharePoint 儀表板
- 將關鍵績效指標和 Excel Services 報告添加到您的儀表板
- 利用 Excel 數據挖掘附加元件和 Visio 群集圖，駕馭高級 SQL Server 2005 數據分析工具
- 生成集成的 PerformancePoint 計分卡
- 創建 Visio 樞紐圖和 Windows Mobile 試算表

**目錄**

前言
序言
致謝
第 1 章：Microsoft Office BI 概念介紹
第 2 章：樞紐分析表、樞紐分析圖和條件格式
第 3 章：Excel 表格：條件格式、假設分析和統計、圖表
第 4 章：Excel 與外部數據：文件、數據庫、立方體和來自互聯網的數據
第 5 章：Excel 與 SharePoint：報告、關鍵績效指標和儀表板
第 6 章：Excel 與數據挖掘：關鍵影響因素、類別和預測
第 7 章：PerformancePoint：儀表板、計分卡和關鍵績效指標
第 8 章：Office BI：Office、Visio、Windows Mobile、Office Online、SQL Server 和 Virtual Earth
索引

類似商品