Microsoft ® Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop (Paperback)

Doug Harts

  • 出版商: McGraw-Hill Education
  • 出版日期: 2008-01-01
  • 定價: $1,240
  • 售價: 1.6$199
  • 語言: 英文
  • 頁數: 444
  • 裝訂: Paperback
  • ISBN: 0071494243
  • ISBN-13: 9780071494243
  • 相關分類: ExcelMicrosoft AzureSharePoint
  • 立即出貨(限量) (庫存=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 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop》向您展示如何使用Excel、Excel Services、SharePoint和PerformancePoint來處理當今辦公室中各種獨立和外部數據。您將學習如何使用您已經在日常工作中使用的Office工具來分析數據並生成報告、記分卡和儀表板。


  • 創建Excel PivotTables和PivotCharts並應用條件格式

  • 將Excel電子表格轉換為具有條件格式和圖表的Excel表格

  • 使用Office數據連接和SharePoint將外部數據連接到Excel

  • 創建顯示來自多個來源的數據的SharePoint儀表板

  • 將關鍵績效指標和Excel Services報告添加到您的儀表板中

  • 利用Excel數據挖掘插件和Visio集群圖表來使用高級SQL Server 2005數據分析工具

  • 生成集成的PerformancePoint記分卡

  • 創建Visio PivotDiagrams和Windows Mobile電子表格

目錄

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