: Philo Janus
: Pro PerformancePoint Server 2007 Building Business Intelligence Solutions
: Apress
: 9781430205883
: 1
: CHF 41.20
:
: Allgemeines, Lexika
: English
: 472
: Wasserzeichen/DRM
: PC/MAC/eReader/Tablet
: PDF

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 to 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.



Philo Janus is a senior technology specialist with Microsoft. Over the years, he has presented InfoPath to thousands of users and developers, and assisted with enterprise implementations of InfoPath solutions. With that background, he is particularly sensitive to the difficulties users and developers have had with InfoPath. He graduated from the U.S. Naval Academy with a bachelor of science degree in electrical engineering in 1989 to face a challenging career in the U.S. Navy. After driving an aircraft carrier around the Pacific Ocean and a guided missile frigate through both the Suez and Panama canals, and serving in the U.S. Embassy in Cairo, a small altercation between his bicycle and an auto indicated a change of career (some would say that landing on his head in that accident would explain many things). Philo's software development career started with building a training and budgeting application in Access 2.0 in 1995. Since then, he's worked with Oracle, Visual Basic, SQL Server, and .NET building applications for federal agencies, commercial firms, and conglomerates. In 2003, he joined Microsoft as a technology specialist evangelizing Office as a development platform.
Contents at a Glance5
Contents6
Foreword14
About the Author16
About the Technical Reviewers17
Acknowledgments18
Introduction19
Who This Book Is For19
How This Book Is Structured19
Prerequisites20
Downloading the Code20
Contacting the Author20
Business Intelligence21
What Is Business Intelligence?21
Scorecards vs. Dashboards22
Key Performance Indicators25
Strategy Maps28
Data Silos30
Data Marts31
Why Do I Care?33
The Microsoft Business Intelligence Stack33
A Successful Business Intelligence Engagement35
Conclusion36
Overview of Microsoft s Business Intelligence Platform37
SQL Server37
SharePoint Integration42
Excel Services44
SharePoint KPI Lists45
ProClarity 6.346
PerformancePoint Server 200748
Conclusion52
SQL Server53
Overview53
SQL Server Editions53
Tools58
Programmability63
Security65
XML66
High Availability67
Service Pack 268
SQL Server 200871
Conclusion72
SQL Server Integration Services73
Overview73
About Data Transformation Services80
Architecture82
Getting Integration Services83
Business Intelligence Development Studio84
Flows87
Program Flow Components90
Data Flow Components92
Scripting Tasks94
Custom Tasks97
Error Reporting98
Scalability99
Deploying and Executing Integration Services Packages100
Conclusion102
SQL Server Analysis Services103
What Is a Cube?104
Facts and Dimensions109
Star Schema or Snowflake Schema?110
BIDS and Analysis Services111
Building a Cube111
Calculated Measures142
Multidimensional Expressions142
Key Performance Indicators142
Perspectives143
Conclusion143
SQL Server Reporting Services144
Architecture147
Creating Reports155
SharePoint Integration182
Conclusion183
Data Mining184
SQL Server Implementation185
Data Mining Algorithms187
Choosing an Algorithm196
Mining Accuracy197
Mining Model Prediction197
Data Mining in Integration Services197
SQL Server 2005 SP2 Excel Add- Ins199
Publishing to Reporting Services205
Conclusion206
Business Intelligence in Excel and SharePoint207
Business Intelligence in Office208
Excel 2007209
Excel Services215
MOSS Business Intelligence224
Conclusion228
ProClarity Analytics Server229
ProClarity Analytics Server Overview229
Advanced Visualizations254
ProClarity and SharePoint262
Installing ProClarity Analytics Server264
Conclusion272
PerformancePoint Monitoring273
Scorecards273
Strategy Maps277
Installing PerformancePoint280
Running Dashboard Designer287
Tour of Dashboard Designer289
Creating a Scorecard296
Conclusion320
Advanced Scorecarding321
Hooking KPIs to Data321
Analysis Services339
Reporting Services350
Conclusion350
Dashboards and Reports351
Overview of the Dashboard Editor351
Reports354
Creating Dashboards374
Publishing Dashboards381
Conclusion384
Planning385
Installation389
Working with Planning393
Business Rules435
Conclusion437
Management Reporter438
Creating Management Reports438
Connecting to PerformancePoint Server448
Exporting to Reporting Services451
Conclusion451
Index452