Organizations are expected to spend $26 billion on business intelligence initiatives in 2008. Now that all the data is in relational databases, it’s time to start getting value at the organizational level from that data. Microsoft has a host of tools to provide easy access to aggregated business data from multiple back ends and display that data in comprehensive, easy-to-read graphics and reports, namely PerformancePoint Server. This book, written by a Microsoft-employed PerformancePoint expert, walks the reader through the entire product.
Author(s): Philo Janus
Edition: 1
Year: 2008
Language: English
Pages: 472
Contents......Page 6
Foreword......Page 14
About the Author......Page 16
About the Technical Reviewers......Page 17
Acknowledgments......Page 18
Introduction......Page 19
What Is Business Intelligence?......Page 21
Scorecards vs. Dashboards......Page 22
Key Performance Indicators......Page 25
KPIs and Business Process......Page 26
The Law of Unintended Consequences......Page 27
Strategy Maps......Page 28
Data Silos......Page 30
Data Marts......Page 31
The Microsoft Business Intelligence Stack......Page 33
Microsoft Office 2007......Page 34
A Successful Business Intelligence Engagement......Page 35
Conclusion......Page 36
SQL Server......Page 37
SQL Server Analysis Services......Page 38
SQL Server Reporting Services......Page 41
SharePoint Integration......Page 42
Excel Services......Page 44
SharePoint KPI Lists......Page 45
ProClarity 6.3......Page 46
PerformancePoint Server 2007......Page 48
Monitoring and Analytics......Page 49
Modeling and Planning......Page 51
Conclusion......Page 52
SQL Server Editions......Page 53
Express Edition......Page 55
Standard Edition......Page 56
Enterprise Edition......Page 57
Management Studio......Page 58
Business Intelligence Development Studio......Page 60
Profiler......Page 62
Programmability......Page 63
Service Broker......Page 64
Security......Page 65
XQuery and Data Manipulation Language......Page 66
Database Snapshots......Page 67
Reports......Page 68
Data Mining Improvements......Page 69
Data Platform......Page 71
Conclusion......Page 72
Why Integration Services?......Page 73
Data Sources......Page 79
About Data Transformation Services......Page 80
Architecture......Page 82
Getting Integration Services......Page 83
Business Intelligence Development Studio......Page 84
Flows......Page 87
Containers......Page 90
Executing Other Code......Page 91
Data Flow Sources......Page 92
Data Flow Transformations......Page 93
Scripting Tasks......Page 94
Custom Tasks......Page 97
Error Reporting......Page 98
Scalability......Page 99
Deploying and Executing Integration Services Packages......Page 100
Conclusion......Page 102
CHAPTER 5: SQL Server Analysis Services......Page 103
What Is a Cube?......Page 104
Facts and Dimensions......Page 109
Star Schema or Snowflake Schema?......Page 110
Building a Cube......Page 111
Creating the Project......Page 114
Creating a Data Source......Page 116
Creating a Data Source View......Page 119
Dimensions......Page 124
Creating the Cube......Page 134
Key Performance Indicators......Page 142
Conclusion......Page 143
CHAPTER 6: SQL Server Reporting Services......Page 144
Report Server......Page 147
Report Manager......Page 148
Report Designer......Page 149
Report Builder......Page 150
Reporting Services Configuration Manager......Page 151
Extensibility......Page 153
Creating Reports......Page 155
Table and Matrix Reports......Page 156
Reporting Services 2008: Tablix......Page 157
Multidimensional Reports......Page 166
Charts and Graphs......Page 179
SharePoint Integration......Page 182
Conclusion......Page 183
CHAPTER 7: Data Mining......Page 184
SQL Server Implementation......Page 185
Decision Trees......Page 187
Naive Bayes......Page 191
Sequence Clustering......Page 194
Neural Networks......Page 195
Choosing an Algorithm......Page 196
Data Mining in Integration Services......Page 197
SQL Server 2005 SP2 Excel Add-Ins......Page 199
Table Analysis......Page 200
Data Preparation (Data Mining Tab)......Page 202
Data Mining Tools......Page 204
Publishing to Reporting Services......Page 205
Conclusion......Page 206
CHAPTER 8: Business Intelligence in Excel and SharePoint......Page 207
Business Intelligence in Office......Page 208
Excel 2007......Page 209
Data Connections......Page 210
Why Excel Services?......Page 215
Configuring Excel Services......Page 218
Publishing to Excel Services......Page 221
KPI Lists......Page 224
Dashboards......Page 225
Conclusion......Page 228
ProClarity Analytics Server Overview......Page 229
ProClarity Charts......Page 232
Web Standard......Page 240
Web Professional......Page 242
Architecture......Page 243
Using ProClarity Web Professional......Page 246
Publishing and Briefing Books......Page 252
Advanced Visualizations......Page 254
ProClarity and SharePoint......Page 262
Installing ProClarity Analytics Server......Page 264
Conclusion......Page 272
Scorecards......Page 273
Strategy Maps......Page 277
Installation......Page 280
Running Dashboard Designer......Page 287
Tour of Dashboard Designer......Page 289
The Fluent User Interface......Page 290
Connecting to a Monitoring Server......Page 292
The Workspace Browser......Page 293
Editor and Properties......Page 294
Indicators......Page 296
KPIs......Page 299
Scorecards......Page 312
Conclusion......Page 320
ODBC (Access Database File)......Page 321
Excel 2007 Spreadsheets......Page 325
Excel 2007 Scorecards......Page 333
Analysis Services......Page 339
Creating an OLAP Scorecard......Page 345
Conclusion......Page 350
Overview of the Dashboard Editor......Page 351
Reports......Page 354
Analytic Grids......Page 356
Analytic Charts......Page 363
Excel Services......Page 366
PivotChart, PivotTable, and Spreadsheet Reports......Page 367
ProClarity Analytics......Page 368
SQL Server Reports......Page 370
Creating Dashboards......Page 374
Filters......Page 376
Linking Dashboard Items......Page 380
Publishing Dashboards......Page 381
Summary......Page 384
CHAPTER 13: Planning......Page 385
Why Plan?......Page 386
PerformancePoint Planning Server Scenarios......Page 387
Installation......Page 389
PerformancePoint, Windows 2008, and 64 Bits......Page 390
Working with Planning......Page 393
Creating a Model......Page 399
Importing Data......Page 414
Designing Forms......Page 417
Workflow......Page 426
Entering Data......Page 430
Business Rules......Page 435
Conclusion......Page 437
Creating Management Reports......Page 438
Connecting to PerformancePoint Server......Page 448
Conclusion......Page 451
B......Page 452
D......Page 453
E......Page 454
I......Page 455
M......Page 456
P......Page 457
R......Page 458
S......Page 459
T......Page 460
Z......Page 461
