ebook ebooks e-book e-books downloaden bei MyEbooks.ch downloaden

Pro PerformancePoint Server 2007 Building Business Intelligence Solutions

:	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 Glance	5
	Contents	6
	Foreword	14
	About the Author	16
	About the Technical Reviewers	17
	Acknowledgments	18
	Introduction	19
	Who This Book Is For	19
	How This Book Is Structured	19
	Prerequisites	20
	Downloading the Code	20
	Contacting the Author	20
	Business Intelligence	21
	What Is Business Intelligence?	21
	Scorecards vs. Dashboards	22
	Key Performance Indicators	25
	Strategy Maps	28
	Data Silos	30
	Data Marts	31
	Why Do I Care?	33
	The Microsoft Business Intelligence Stack	33
	A Successful Business Intelligence Engagement	35
	Conclusion	36
	Overview of Microsoft s Business Intelligence Platform	37
	SQL Server	37
	SharePoint Integration	42
	Excel Services	44
	SharePoint KPI Lists	45
	ProClarity 6.3	46
	PerformancePoint Server 2007	48
	Conclusion	52
	SQL Server	53
	Overview	53
	SQL Server Editions	53
	Tools	58
	Programmability	63
	Security	65
	XML	66
	High Availability	67
	Service Pack 2	68
	SQL Server 2008	71
	Conclusion	72
	SQL Server Integration Services	73
	Overview	73
	About Data Transformation Services	80
	Architecture	82
	Getting Integration Services	83
	Business Intelligence Development Studio	84
	Flows	87
	Program Flow Components	90
	Data Flow Components	92
	Scripting Tasks	94
	Custom Tasks	97
	Error Reporting	98
	Scalability	99
	Deploying and Executing Integration Services Packages	100
	Conclusion	102
	SQL Server Analysis Services	103
	What Is a Cube?	104
	Facts and Dimensions	109
	Star Schema or Snowflake Schema?	110
	BIDS and Analysis Services	111
	Building a Cube	111
	Calculated Measures	142
	Multidimensional Expressions	142
	Key Performance Indicators	142
	Perspectives	143
	Conclusion	143
	SQL Server Reporting Services	144
	Architecture	147
	Creating Reports	155
	SharePoint Integration	182
	Conclusion	183
	Data Mining	184
	SQL Server Implementation	185
	Data Mining Algorithms	187
	Choosing an Algorithm	196
	Mining Accuracy	197
	Mining Model Prediction	197
	Data Mining in Integration Services	197
	SQL Server 2005 SP2 Excel Add- Ins	199
	Publishing to Reporting Services	205
	Conclusion	206
	Business Intelligence in Excel and SharePoint	207
	Business Intelligence in Office	208
	Excel 2007	209
	Excel Services	215
	MOSS Business Intelligence	224
	Conclusion	228
	ProClarity Analytics Server	229
	ProClarity Analytics Server Overview	229
	Advanced Visualizations	254
	ProClarity and SharePoint	262
	Installing ProClarity Analytics Server	264
	Conclusion	272
	PerformancePoint Monitoring	273
	Scorecards	273
	Strategy Maps	277
	Installing PerformancePoint	280
	Running Dashboard Designer	287
	Tour of Dashboard Designer	289
	Creating a Scorecard	296
	Conclusion	320
	Advanced Scorecarding	321
	Hooking KPIs to Data	321
	Analysis Services	339
	Reporting Services	350
	Conclusion	350
	Dashboards and Reports	351
	Overview of the Dashboard Editor	351
	Reports	354
	Creating Dashboards	374
	Publishing Dashboards	381
	Conclusion	384
	Planning	385
	Installation	389
	Working with Planning	393
	Business Rules	435
	Conclusion	437
	Management Reporter	438
	Creating Management Reports	438
	Connecting to PerformancePoint Server	448
	Exporting to Reporting Services	451
	Conclusion	451
	Index	452