Janus Pro PerformancePoint Server 2007

Building Business Intelligence Solutions
1. ed
ISBN: 978-1-4302-0588-3
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 472 Seiten

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.

Autoren/Hrsg.

Janus, Philo

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;Foreword;14
4;About the Author;16
5;About the Technical Reviewers;17
6;Acknowledgments;18
7;Introduction;19
7.1;Who This Book Is For;19
7.2;How This Book Is Structured;19
7.3;Prerequisites;20
7.4;Downloading the Code;20
7.5;Contacting the Author;20
8;Business Intelligence;21
8.1;What Is Business Intelligence?;21
8.2;Scorecards vs. Dashboards;22
8.3;Key Performance Indicators;25
8.4;Strategy Maps;28
8.5;Data Silos;30
8.6;Data Marts;31
8.7;Why Do I Care?;33
8.8;The Microsoft Business Intelligence Stack;33
8.9;A Successful Business Intelligence Engagement;35
8.10;Conclusion;36
9;Overview of Microsoft’s Business Intelligence Platform;37
9.1;SQL Server;37
9.2;SharePoint Integration;42
9.3;Excel Services;44
9.4;SharePoint KPI Lists;45
9.5;ProClarity 6.3;46
9.6;PerformancePoint Server 2007;48
9.7;Conclusion;52
10;SQL Server;53
10.1;Overview;53
10.2;SQL Server Editions;53
10.3;Tools;58
10.4;Programmability;63
10.5;Security;65
10.6;XML;66
10.7;High Availability;67
10.8;Service Pack 2;68
10.9;SQL Server 2008;71
10.10;Conclusion;72
11;SQL Server Integration Services;73
11.1;Overview;73
11.2;About Data Transformation Services;80
11.3;Architecture;82
11.4;Getting Integration Services;83
11.5;Business Intelligence Development Studio;84
11.6;Flows;87
11.7;Program Flow Components;90
11.8;Data Flow Components;92
11.9;Scripting Tasks;94
11.10;Custom Tasks;97
11.11;Error Reporting;98
11.12;Scalability;99
11.13;Deploying and Executing Integration Services Packages;100
11.14;Conclusion;102
12;SQL Server Analysis Services;103
12.1;What Is a Cube?;104
12.2;Facts and Dimensions;109
12.3;Star Schema or Snowflake Schema?;110
12.4;BIDS and Analysis Services;111
12.5;Building a Cube;111
12.6;Calculated Measures;142
12.7;Multidimensional Expressions;142
12.8;Key Performance Indicators;142
12.9;Perspectives;143
12.10;Conclusion;143
13;SQL Server Reporting Services;144
13.1;Architecture;147
13.2;Creating Reports;155
13.3;SharePoint Integration;182
13.4;Conclusion;183
14;Data Mining;184
14.1;SQL Server Implementation;185
14.2;Data Mining Algorithms;187
14.3;Choosing an Algorithm;196
14.4;Mining Accuracy;197
14.5;Mining Model Prediction;197
14.6;Data Mining in Integration Services;197
14.7;SQL Server 2005 SP2 Excel Add- Ins;199
14.8;Publishing to Reporting Services;205
14.9;Conclusion;206
15;Business Intelligence in Excel and SharePoint;207
15.1;Business Intelligence in Office;208
15.2;Excel 2007;209
15.3;Excel Services;215
15.4;MOSS Business Intelligence;224
15.5;Conclusion;228
16;ProClarity Analytics Server;229
16.1;ProClarity Analytics Server Overview;229
16.2;Advanced Visualizations;254
16.3;ProClarity and SharePoint;262
16.4;Installing ProClarity Analytics Server;264
16.5;Conclusion;272
17;PerformancePoint Monitoring;273
17.1;Scorecards;273
17.2;Strategy Maps;277
17.3;Installing PerformancePoint;280
17.4;Running Dashboard Designer;287
17.5;Tour of Dashboard Designer;289
17.6;Creating a Scorecard;296
17.7;Conclusion;320
18;Advanced Scorecarding;321
18.1;Hooking KPIs to Data;321
18.2;Analysis Services;339
18.3;Reporting Services;350
18.4;Conclusion;350
19;Dashboards and Reports;351
19.1;Overview of the Dashboard Editor;351
19.2;Reports;354
19.3;Creating Dashboards;374
19.4;Publishing Dashboards;381
19.5;Conclusion;384
20;Planning;385
20.1;Installation;389
20.2;Working with Planning;393
20.3;Business Rules;435
20.4;Conclusion;437
21;Management Reporter;438
21.1;Creating Management Reports;438
21.2;Connecting to PerformancePoint Server;448
21.3;Exporting to Reporting Services;451
21.4;Conclusion;451
22;Index;452