Microsoft ® Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the DesktopExtract and analyze mission-critical enterprise data using Microsoft Office 2007 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.
|
Contents
| 1 | |
| 13 | |
Conditional Formatting WhatIf and Statistics and Charts | 87 |
Files Databases Cubes and Data from the Internet | 143 |
Reports Key Performance Indicators and Dashboards | 207 |
Key Influencers Categories and Forecasting | 273 |
Dashboards Scorecards and Key Performance Indicators | 321 |
Office Visio Windows Mobile Office Online SQL Server and Virtual Earth | 371 |
Index | 431 |
Other editions - View all
Microsoft ® Office 2007 Business Intelligence: Reporting, Analysis, and ... Doug Harts No preview available - 2007 |
Common terms and phrases
able Access actual allows Analysis Services analytic applications automatically bring business intelligence button cell chapter chart checkbox choices Choose click OK color column components conditional formatting configuration create dashboard Data Connection data elements Data Mining database desired desktop dialog box discussion display drag drop-down control easy Enter example Excel Services Excel table explore external data field Figure Filter format going hold icon important Indicators interface Labels Library look menu group menu options Microsoft mouse Name Note Office OLAP cube option organization pane PerformancePoint Phone PivotChart PivotTable planning pop-up menu presentation published Query Report result Ribbon menu rows Save Scorecard screen SharePoint 2007 shown shows simply spreadsheet SQL Server steps subtotals understand Unit users values Visio visual Windows
Popular passages
Page 152 - Characters such as commas or tabs separate each field. Fixed width - Fields are aligned in columns with spaces between each field. Start import at row: File origin: 437 : OEM United States Preview of file C:\Documents and 5ettings\gcourter...
Page 420 - There are no usable controls in this group. Drag an item onto this text to add it to the toolbox.
Page 120 - Format only cells that contain *' Format only top or bottom ranked values ^ Format only values that are above or below average *- Format only unique or duplicate values > Use a formula to determine which cells to format Edit the Rule Description: Format only cells with: JErrors Lv ^~ Preview: No Format Set Format.
Page 213 - View the sample dashboard and workbook to understand some of the capabilities of this Report Center If the samples do not work correctly ask an administrator to ensure that Excel Services are enabled and that this Report Center is a Trusted Location If you plan to use Excel to analyze information from existing data servers , create and upload data connection [QDCJ flies to the Data Connection Library. If you want users to create new KPI Lists then add them to the *Dwnersr group. Users in the "Members...
Page 377 - Update this feed with the publisher's recommendation, Send/Receive groups do not update more frequently than the recommended limit to prevent your RSS feed from possibly being cancelled by the content provider. Current provider limit...
Page 174 - The Query Wizard can not continue because it can not join the tables in your query. You must join the tables manually in Microsoft Query by dragging the fields to join between the tables.
Page 154 - Text Import Wizard Step 3 of 3 This screen lets you select each column and set the Data Format. Column data format © General 'General1 converts numeric values to numbers, date O lext values to dates, and all remaining values to text. .-. D [,My v O Do not import column (skip) Advanced...
Page 173 - Import data into Excel as a Table or PivotTable report. From XML Data Import Open or map a XML file into Excel. From Data Connection Wizard Import data for an unlisted format by using the Data Connection Wizard and OLEDB.
Page 385 - Pastes the contents of the Clipboard into your presentation so that you can activate it using Microsoft Office Excel 2003. Here's what those choices mean: • Microsoft Office Excel Worksheet Object pastes the range as a table, including the entire workbook, so that you can edit the range in place as an Excel object.