Index
A
actions, availability of, 294-295
Actions section (PowerPivot Management Dashboard), 183
Add Measure Filters screen, 114
Add Subscriptions page, 65-66
Add Trusted Content Location link, 97
Add Trusted Data Source Location link, 96
add-ins, Reporting Services Add-In for SharePoint, 39-42, 283-285
Alert Me function, 53
Allow External Data Using REST option (Excel Services), 25
Analysis Services data connections, 102-104, 251
Analysis Services template, 102
Analytic Chart reports, 117-119, 260
Analytic Grid report, 119-121
analyzing PowerPivot traces, 300
Application Settings (PerformancePoint Services), 91-92
B
banding methods, 111
BI (business intelligence) tools, 1
BI End to End Solution dashboard
building and deploying, 263
interacting with, 266-268
BIDS, deploying reports from, 47-51
Blank Drawing template, 198
Blank KPIs (key performance indicators), creating, 110-113
blogs, RDA BI/SQL Server Practice Group Blog, 3
browsing Visio web drawings, 213-214
Business Intelligence Center, 3-7
choosing BI tools, 8
creating with Business Intelligence Center template, 9-10
reviewing, 9-13
server prerequisites and licensing considerations, 7-8
site collection, creating, 235-236
subsites, creating with Business Intelligence Center site template, 13-14
C
cache, workbook cache, 21
Cache setting (PerformancePoint Services), 92
Caching of Unused Files setting (Excel Services), 21
calculated fields, adding to PowerPivot for Excel, 160
calculation behavior, configuring in Excel Services, 23-25
Calendar Year custom list, 271-276
Central Administration
PerformancePoint Services, adding, 89-90
Reporting Services integration, 40-42
trusted content locations, configuring, 97
trusted data source locations, configuring, 96
Check Out function, 53
Choice Filter, 78
choosing BI (business intelligence) tools, 8
Closer to Target Is Better scoring pattern, 111
Comments setting (PerformancePoint Services), 92
Company Returns Objective KPI, 258
Company Sales Objective KPI,
Configure Connection dialog, 79-80, 218
Configure Service Application Associations menu, 90
configuring
Excel Services, 17-18
calculation behavior, 23-25
external data, 21-22
load balancing, 19-20
memory utilization, 20-21
security, 19
session management, 20
trusted data connection libraries, 26-27
trusted data providers, 25-26
trusted file locations, 22-23
user-defined functions, 27-28
workbook cache, 21
workbook properties, 23
PerformancePoint Services, 84-89, 239, 287-288
application settings, 91-92
enabling non-Business Intelligence Center sites, 92-95
Secure Store Service, 90-91
trusted content locations, 97
trusted data source locations, 96
Report Viewer web part, 71-75
Reporting Services, 40-42, 239
Secure Store Service, 287-288
Visio Graphics Service
global settings, 189-190
trusted data providers, 191-193, 224-225
Connection Encryption setting (Excel Services), 19
connections (Report Viewer web part), 77-81
Content Types, adding to document libraries, 42-45
Continents custom list, 276-277
ContosoRetailDW database, downloading, 198
ContosoSalesByChannel.vdw drawing
developing, 198-211
embedding into SharePoint page with Visio Web Access web part, 214-217
Create Connection menu, 130-131
Create Group button, 145
Create Relationship dialog, 159
Create Site Collections link, 9
cube actions, availability of, 294-295
Current User Filter, 78
custom data providers, 220
Custom Table filter, 127
customizing navigation, 237-239
D
Dashboard Designer, 99-102
objects, 101-102
opening, 100
redirecting to from content list, 100
Dashboard Page Template screen, 127
dashboards
BI End to End Solution
building and deploying, 263
interacting with, 266-268
connecting filters to dashboard content objects, 130
dashboard connection formula, 289-292
deployed BI solution, 239-240
deploying to SharePoint, 135
insufficient security for dashboard deployment, troubleshooting, 293-294
multiple pages in, 134
PowerPivot Management Dashboard, 183-184
data, importing into PowerPivot for Excel, 152-154
from database, 154-157
from flat file, 157
data connection libraries, creating, 92-95
Data Connection Wizard, 201-204
data connections
Analysis Services data connections, 102-104, 251
Excel Services data connections, 104-105
Import from Excel Workbook data connections, 106-107
SharePoint List data connections, 107-108
SQL Server Table data connections, 108-109
Data Connections category (Dashboard Designer), 101
data exposure, controlling, 181-182
data filtering. See filters
data providers
custom data providers, 220
data provider not found error message, 306
trusted data providers. See trusted data providers
untrusted data provider requests, 306
data refresh options
for PowerPivot for SharePoint, 179-180
for reports, 58-59
for Visio Graphics Service, 214, 305-306
Data Refresh section (PowerPivot Management Dashboard), 183
data sources, 60-62
creating, 241-242
trusted data source locations, 96
Visio Graphics Service
external data sources, 224
internal data sources, 223-224
Data Sources setting (PerformancePoint Services), 92
database not found error message, 306
databases
ContosoRetailDW database, down-loading, 198
database not found error message, 306
exporting data into PowerPivot for Excel, 154-157
DataConnections Library for PerformancePoint option, 92
data-driven subscriptions, 67
datasets
creating, 241-245
Date Filter, 78
Decomposition Tree, 92, 137-138
Decreasing Is Better scoring pattern, 111
delegating data sources, 141-144, 226-229
Delete Item function, 53
Delivery Options page, 67-69
deploying
BI End to End Solution dashboard, 263
dashboards, 135
reports, 48
from BIDS, 49-51
to document library, 48
from Report Builder, 51-53
development with PerformancePoint Services. See PerformancePoint Services
disabling PowerPivot tracing, 299
displaying Getting Started dialog, 282-283
document libraries. See libraries
downloading ContosoRetailDW database, 198
drilling with Decomposition Tree, 137-138
E
ECS (Excel Calculation Services), stopping, 175
Edit Items function, 53
Edit Trusted Content Location screen, 97-98
Edit Trusted Data Source Location screen, 96-97
editing shared datasets, 63
embedding Visio web drawings into SharePoint pages, 214-217
enabling
Decomposition Tree, 137-138
non-Business Intelligence Center sites, 92-95
PowerPivot tracing, 298-299
Report Builder, 283
Report Server Integration, 285
error messages. See troubleshooting
Event ID errors. See Visio Graphics Service, troubleshooting
Excel Calculation Services (ECS), stopping, 175
Excel Service Authentication Settings window, 230
Excel Services, 13-17
configuring, 17-18
calculation behavior, 23-25
external data, 21-22
load balancing, 19-20
memory utilization, 20-21
security, 19
session management, 20
trusted data connection libraries, 26-27
trusted data providers, 25-26
trusted file locations, 22-23
user-defined functions, 27-28
workbook cache, 21
workbook properties, 23
data connections, 104-105
Excel Services template, 104
Excel Web Access web part, 31-32
integrating with Visio Graphics Service, 268-271
deployed solution, 271
Visio web drawing, creating with Microsoft Visio 2010 Premium Edition, 271-277
libraries, creating for workbooks, 28-29
PowerPivot. See PowerPivot for Excel
reports, 123
workbooks
accessing from libraries, 31
adding to libraries, 29-30
Excel Web Access warning, 302
Excel Web Access web part, 31-32
External Data Cache Lifetime setting (Excel Services), 25
external data, configuring in Excel Services, 21-22
External Data setting (Visio Graphics Service), 190
external data sources (Visio Graphics Service), 224
F
Farm Configuration Wizard, 187-188
fields
calculated fields, adding to PowerPivot for Excel, 160
unwanted fields, hiding, 161
file loading errors, 306
files
file loading errors, 306
ODC files, publishing, 229-231
Filter Actions, 78
filters, 126
connecting to dashboard content objects, 130
creating, 262
Custom Table, 127
filter web parts, 77-79
MDX Query, 127
Member Selection, 127
Named Set, 127
Time Intelligence Connection, 127
Filters setting (PerformancePoint Services), 92
flat files, exporting into PowerPivot for Excel, 157
functions
built-in SharePoint functions, 53-54
volatile functions, 23
G
Generate New Key menu, 91
Get Filter Results From connection action, 220
Get Shape to View From connection action, 220
Get Shapes to Highlight From connection action, 218
Get Web Drawing URL and Page Name From connection action, 220
Getting Started dialog, 245, 282-283
Global Settings
Excel Services, 18
External Data settings, 21-22
Load Balancing settings, 19-20
Memory Utilization settings, 20-21
Security settings, 19
Workbook Cache settings, 20, 21
Visio Graphics Service, 189-190
graphics. See Visio Graphics Service
groups, site groups, 145
H-I
hiding fields in PowerPivot for Excel, 161
hierarchies (PowerPivot), 302
Import from Excel Workbook data connections, 106-107
Import from Excel Workbook template, 106
importing into PowerPivot for Excel, 152-154
from database, 154-157
from flat file, 157
Increasing Is Better scoring pattern, 111
Infrastructure - Server Health section (PowerPivot Management Dashboard), 183
installing
PowerPivot for Excel, 152, 302
PowerPivot for SharePoint, 168
multiserver farm install, 171-175
single-server install, 169-171
Reporting Services, 38-40
internal data sources (Visio Graphics Service), 223-224
invalid endpoints, troubleshooting, 306
J-K
Kerberos, 175
key performance indicators. See KPIs (key performance indicators)
KPI Details reports
creating, 122-123
linking to scorecards, 133-134
KPIs (key performance indicators), 109
Blank KPIs, creating, 110-113
creating, 252-258
KPI Details reports
creating, 122-123
linking to scorecards, 133-134
Objectives, 111
L
libraries
accessing workbooks from, 31
adding Content Types to, 42-45
adding workbooks to, 29-30
creating for Excel workbooks, 28-29
data connection libraries, 92-95
Library Settings page, 54
publishing Visio web drawings to, 211-213
trusted data connection libraries, 26-27
uploading reports to, 47
Library Settings page, 42-43, 54
licensing, 7-8
load balancing, configuring in Excel Services, 19-20
loading VertiPaq engine, 298-299
Local option (ECS Load Balancing), 20
locations
nontrusted content location, 292-293
trusted content locations, 97
trusted data source locations, 96
logs, ULS (Unified Logging Service) logs, 300-301
M
Manage Copies function, 53
Manage Permissions function, 53
Manage Report Parameters page, 64-65
Manage Shared Datasets page, 63
management dashboards, 231-235
Maximum Cache Agesetting (Visio Graphics Service), 189
Maximum Concurrent Queries per Session setting (Excel Services), 25
Maximum Private Bytes setting (ECS Memory Utilization), 20
Maximum Recalc Duration setting (Visio Graphics Service), 190
Maximum Request Duration setting (Excel Services), 22-23
Maximum Size of Workbook Cache setting (Excel Services), 21
Maximum Unused Object Age setting (ECS Memory Utilization), 21
Maximum Web Drawing Size setting (Visio Graphics Service), 189
MDX Query filter, 127
MDX tuple formulas, 111
Member Selection filter, 127
memory, configuring in Excel Services, 20-21
Memory Cache Threshold setting (ECS Memory Utilization), 20-21
Microsoft BI website, 3
Microsoft Office Developer Center, 3
Microsoft scorecard templates, 114
Microsoft SharePoint 2010 website, 3
Minimum Cache Agesetting (Visio Graphics Service), 189
monitoring PowerPivot for SharePoint, 182
multiple pages, creating in dashboards, 134
multiserver farm install (PowerPivot for SharePoint), 171-175
N
Named Set filter, 127
native mode web parts, 81-85
navigation, customizing, 237-239
non-Business Intelligence Center sites, enabling with PerformancePoint Services, 92-95
nontrusted content location, 292-293
O
Objectives, creating, 111
ODC files, publishing, 229-231
office data connectivity files. See ODC files
opening Dashboard Designer, 100
P
Page Field Filter, 78
parameters (report), 64-65
PerformancePoint Content category (Dashboard Designer), 101-102
PerformancePoint Services, 84-89, 97-99, 250-251, 261
adding, 89-90
application settings, 91-92
configuring, 239
connecting to Reporting Services reports, 261
Dashboard Designer, 99-102
objects, 101-102
opening, 100
redirecting to from content list, 100
dashboards
building, 263
connecting filters to dashboard content objects, 130
creating, 127-130
deploying to SharePoint, 135
interacting with, 266-268
linking KPI Details reports to scorecards, 133-134
multiple pages in, 134
data connection libraries, creating, 92-95
data connections
Analysis Services data connections, 102-104, 251
Excel Services data connections, 104-105
Import from Excel Workbook data connections, 106-107
SharePoint List data connections, 107-108
SQL Server Table data connections, 108-109
Decomposition Tree, enabling, 137-138
filters, 126
connecting to dashboard content objects, 130
creating, 262
Custom Table, 127
MDX Query, 127
Member Selection, 127
Named Set, 127
Time Intelligence, 127
Time Intelligence Connection, 127
KPIs (key performance indicators), 109
Blank KPIs, 110-113
creating, 252-258
Objectives, 111
non-Business Intelligence Center sites, enabling, 92-95
reports, 117
Analytic Chart, 117-119
analytic chart reports, 260
Analytic Grid, 119-121
Excel Services, 123
ProClarity Analytics Server Page, 123
Reporting Services, 123
Strategy Map, 121-122
Web Page, 126
scorecards
defined, 111
Secure Store Service, configuring, 90-91
security, 137-141
data source delegation, 141-144
SharePoint permissions, 144-145
troubleshooting, 286-287
configuration, 287-288
cube action not available, 294-295
dashboard connection formula, 289-292
insufficient security for dashboard deployment, 293-294
nontrusted content location, 292-293
trusted content locations, configuring, 97
trusted data source locations, configuring, 96
permissions (PerformancePoint Services), 144-145
PivotTables, creating in PowerPivot for Excel, 162
planning Business Intelligence Center, 7-8
PowerPivot for Excel
calculated fields, adding, 160
importing data into, 154-155
importing from database, 154-157
importing from flat file, 157
installing, 152
overview, 145-154
PivotTables, creating, 162
relationships, creating between tables, 159
troubleshooting, 297-303
analyzing traces, 300
disabling tracing, 299
enabling tracing, 298-299
Excel Web Access warning, 302
hierarchies, 302
installation, 302
relationships, 302
SharePoint list data, 302
user credential delegation errors, 302-303
unwanted fields, hiding, 161
PowerPivot for SharePoint
data exposure, controlling, 181-182
data refresh options, 179-180
hardware and software requirements, 168
installing, 168
multiserver farm install, 171-175
single-server install, 169-171
monitoring, 182
overview, 162-168
PowerPivot Gallery, 175-177
PowerPivot Management Dashboard, 183-184
snapshots, 179-180
spreadmarts, 181-182
troubleshooting, 300-301
Excel Web Access warning, 302
hierarchies, 302
installation, 302
relationships, 302
SharePoint list data, 302
user credential delegation errors, 302-303
workbooks, publishing, 180-181
PowerPivot Gallery, 175-177
PowerPivot Management Dashboard, 183-184
PowerShell, configuring Visio Graphics Service with, 190
processing
data refresh options, 58-59
data snapshot options, 59
processing timeout, 59
reports, 58-59
ProClarity Analytics Server Page reports, 123
properties
report project properties, 51
Report Viewer web part properties, 75-77
workbook properties, configuring in Excel Services, 23
proxy initiation failure, troubleshooting, 306
publishing
ODC files, 229-231
Visio web drawings, 211-213
workbooks with PowerPivot for SharePoint, 180-181
Q-R
Query String (URL) Filter, 78
RDA BI/SQL Server Practice Group Blog, 3
redirecting to Dashboard Designer from content list, 100
refresh options. See data refresh options
relationships
creating between tables, 159
in PowerPivot, 302
Report Builder, 45
creating reports with, 240-250
deploying reports from, 51-53
enabling, 283
Report Explorer web part, 81-85
Report Library template, 28-29
Report Server Integration, enabling, 285
Report Viewer web part, 81-85
configuring, 71-75
connections, 77-81
native mode web parts, 81-85
properties, 75-77
Reporting Services, 32-38, 283-285. See also reports
configuring, 239
connecting to, 261
Content Types, adding to document libraries, 42-45
installing, 38-39
Report Builder, enabling, 283
Reporting Services Add-In for SharePoint
configuring, 40-42
installing, 39-40
troubleshooting, 283-285
SharePoint integration, 40-42
troubleshooting, 277-281
Getting Started dialog, 282-283
report artifacts, 285
Report Builder, 283
report project settings, 286
Report Server Integration, 285
Reporting Services add-in, 283-285
shared datasets, 281
web parts. See web parts
Analytic Grid, 119-121
built-in SharePoint functions, 53-54
creating with Report Builder 3.0, 240-250
datasets, 241-245
deploying, 47
from BIDS, 47-51
from Report Builder, 51-53
uploading to document library, 47
Excel Services, 123
KPI Details
creating, 122-123
linking to scorecards, 133-134
parameters, 64-65
processing options, 58-59
data refresh options, 58-59
data snapshot options, 59
processing timeout, 59
ProClarity Analytics Server Page, 123
report artifacts, 285
report project settings, 286
Reporting Services. See Reporting Services
shared datasets, 62-64
shared schedules, 55-58
sparklines, 249-250
Strategy Map, 121-122
subscriptions, 65-69
data-driven subscriptions, 67
delivery options, 67-69
Web Page, 126
Reports section (PowerPivot Management Dashboard), 184
repositories, Visio Process Repository site template, 191-195
Return Amount KPI, 252
Return Quantity KPI, 252
reviewing Business Intelligence Center, 9-13
Round Robin with Health Check option (ECS Load Balancing), 20
S
Sales Amount KPI, 252
Sales Quantity KPI, 252
schedules, shared, 55-58
scorecards
defined, 111
linking KPI Details reports to, 133-134
Scoring Patterns, 111
Secure Store Application Secure Store Service menu, 91
Secure Store Service
configuring for PerformancePoint Services, 90-91, 287-288
configuring for Visio Graphics Service, 226-229
publishing ODC files to SharePoint 2010, 229-231
Excel Services, 19
insufficient security for dashboard deployment, troubleshooting, 293-294
PerformancePoint Services, 137-141
data source delegation, 141-144
SharePoint permissions, 144-145
Visio Graphics Service, 220-223
external data sources, 224
internal data sources, 223-224
Select a Scorecard Template screen, 114
Select an Item dialog, 72
Select Measure Control setting (PerformancePoint Services), 92
Send Shape Data To connection action, 220
services
Excel Services. See Excel Services
PerformancePoint Services. See PerformancePoint Services
Reporting Services, 32-38
configuring, 239
installing, 38-39
Reporting Services Add-In for SharePoint, 39-42
SharePoint integration, 40-42
Secure Store Service, 288
Usage and Health Data Collection, 182
Visio Graphics Service. See Visio Graphics Service
session management (Excel Services), 20
Session Timeout setting (Excel Services), 22
shared schedules, 55-58
SharePoint Central Administration
PerformancePoint Services, adding, 89-90
Reporting Services integration, configuring, 40-42
trusted content locations, configuring, 97
trusted data source locations, configuring, 96
SharePoint List data connections, 107-108
SharePoint list data, in PowerPivot, 302
SharePoint List Filter, 78
SharePoint List template, 107
SharePoint Unified Logging Service (ULS) logs, 300-301
Show Details setting (PerformancePoint Services), 92
Silverlight, 175
single-server install (PowerPivot for SharePoint), 169-171
site collection, 92-94, 235-236
site groups, 145
Site Settings page, 55-57
site templates. See templates
sites, enabling with PerformancePoint Services, 92-95
snapshots
PowerPivot for SharePoint, 179-180
reports, 59
sparklines, 249-250
spreadmarts, 181-182
SQL Server Analysis Services (SSAS)
data sources, delegating, 142
Filter, 78
SQL Server Table data connections, 108-109
SQL Server Table template, 108
SSAS (SQL Server Analysis Services)
data sources, delegating, 142
Filter, 78
Standard scorecard templates, 114
Stop When Refresh on Open Fails setting (Excel Services), 24-25
stopping Excel Calculation Services (ECS), 175
Strategy Map reports, 121-122
subscriptions (reports), 65-69
data-driven subscriptions, 67
delivery options, 67-69
subsites, creating with Business Intelligence Center template, 13-14
T
Table or Matrix Wizard, 245
tables
PivotTables. See PivotTables
relationships, creating, 159
Tabular scorecard templates, 114
TargetDatasetFolder property, 51
TargetDataSourceFolder property, 51
TargetReportFolder property, 51
TargetReportPartFolder property, 51
TargetServerURL property, 51, 286
templates
Analysis Services, 102
Blank Drawing template, 198
Business Intelligence Center site template, 13-14
Excel Services, 104
Import from Excel Workbook, 106
Report Library, 28-29
SharePoint List, 107
SQL Server Table, 108
Visio Process Repository site template, 191-195
Time Intelligence Connection filter, 127
Time Intelligence filter, 110, 127
Time Member Associations menu, 102
Time tab (Analysis Services), 102-103
timeouts (report processing), 59
tracing (PowerPivot)
disabling, 299
enabling, 298-299
troubleshooting
PerformancePoint Services, 286-287
configuration, 287-288
cube action not available, 294-295
dashboard connection formula, 289-292
insufficient security for dashboard deployment, 293-294
nontrusted content location, 292-293
PowerPivot, 295-297
analyzing traces, 300
disabling tracing, 299
enabling tracing, 298-299
Excel Web Access warning, 302
hierarchies, 302
installation, 302
PowerPivot for Excel, 297-300
PowerPivot for SharePoint, 300-301
relationships, 302
SharePoint list data, 302
user credential delegation errors, 302-303
Reporting Services, 277-281
Getting Started dialog, 282-283
report artifacts, 285
Report Builder, 283
report project settings, 286
Report Server Integration, 285
Reporting Services add-in, 283-285
shared datasets, 281
Visio Graphics Service, 303-305
data provider not found, 306
data refresh failure, 305-306
database not found, 306
failure to generate diagram, 306
file loading errors, 306
invalid endpoint, 306
proxy initiation failure, 306
untrusted data provider request, 306
trusted content locations, configuring, 97
trusted data connection libraries, configuring in Excel Services, 26-27
trusted data providers
Excel Services, 25-26
Visio Graphics Service
adding, 224-225
list of, 191-193
trusted data source locations, configuring, 96
Trusted Data Source Locations link, 96
trusted file locations, configuring in Excel Services, 22-23
U
ULS (Unified Logging Service) logs, 300-301
untrusted data provider requests, 306
unwanted fields, hiding, 161
Upload Document dialog, 30, 47-49
uploading reports to document library, 47
Usage and Health Data Collection, 182
user credential delegation errors, troubleshooting, 302-303
user-defined functions, configuring in Excel Services, 27-28
V
VDW files. See Visio web drawings
Version History function, 53
VertiPaq engine, loading, 298-299
Visio Graphics Service, 184-187, 194-197
adding, 187-188
custom data providers, 220
global settings, 189-190
integrating with Excel Services, 268-271
deployed solution, 271
Visio web drawing, creating with Microsoft Visio 2010 Premium Edition, 271-277
prerequisites, 197-198
publishing ODC files to SharePoint 2010, 229-231
security, 220-223
data source delegation, 226-229
external data sources, 224
internal data sources, 223-224
Secure Store Service, 226-229
troubleshooting, 305
data provider not found, 306
data refresh failure, 305-306
database not found, 306
failure to generate diagram, 306
file loading errors, 306
invalid endpoint, 306
proxy initiation failure, 306
untrusted data provider request, 306
trusted data providers
adding, 224-225
list of, 191-193
Visio Process Repository site template, 191-195
Visio Web Access web part
embedding drawings with, 214-217
interaction with other SharePoint 2010 applications, 218-220
Visio web drawings
browsing, 213-214
creating with Microsoft Visio Premium Edition, 271-277
developing, 198-211
embedding into SharePoint page with Visio Web Access web part, 214-217
publishing to document library, 211-213
refreshing data in, 214
Visio Process Repository site template, 191-195
Visio Web Access web part
embedding drawings with, 214-217
interaction with other SharePoint 2010 applications, 218-220
Volatile Function Cache Lifetime setting (Excel Services), 23
volatile functions, 23
W-X-Y-Z
Warn on Refresh option (Excel Services), 24
web drawings (Visio)
browsing, 213-214
creating with Microsoft Visio Premium Edition, 271-277
developing, 198-211
embedding into SharePoint page with Visio Web Access web part, 214-217
publishing to document library, 211-213
refreshing data in, 214
Web File Properties window, 230-231
Web Page reports, 126
web parts, 69-71
Excel Web Access, 31-32
filter web parts, 77-79
Report Explorer, native mode web parts, 81-85
Report Viewer, 71-75
configuring, 71-75
connections, 77-81
native mode web parts, 81-85
properties, 75-77
Visio Graphics Service, interaction with other SharePoint 2010 applications, 218-220
Visio Web Access web part, embedding drawings with, 214-217
websites
Microsoft BI website, 3
Microsoft Office Developer Center, 3
Microsoft SharePoint 2010 website, 3
Windows PowerShell, configuring Visio Graphics Service with, 190
wizards
Data Connection Wizard, 201-204
Farm Configuration Wizard, 187-188
Table or Matrix Wizard, 245
Workbook Activity section (PowerPivot Management Dashboard), 183
workbook cache, configuring in Excel Services, 21
Workbook Cache Location setting (Excel Services), 21
Workbook Calculation Mode (Excel Services), 23-24
Workbook URL option (ECS Load Balancing), 20
workbooks
accessing from libraries, 31
adding to libraries, 29-30
creating libraries for, 28-29
properties, 23
publishing in PowerPivot for SharePoint, 180-181