Written by members of the Analysis Services product team at Microsoft, this timely and authoritative book shows you how to use Analysis Services along with SQL Server components like Integration Services, Data Mining, and Reporting Services to provide comprehensive, end–to–end solutions. Ultimately you'll learn to solve business problems by leveraging all the tools that SQL Server 2005 has to offer.
What you will learn from this book
Who this book is for
This book is for database and data warehouse developers and administrators interested in exploiting the power of BI and leveraging the SQL Server 2005 tool set.
Wrox Professional guides are planned and written by working programmers to meet the real–world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Part One: Introduction.
Chapter 1: Introduction to Data Warehousing and Analysis Services 2005.
Chapter 2: First Look at Analysis Services 2005.
Chapter 3: Introduction to MDX.
Chapter 4: Working with Data Sources and Data Source Views.
Chapter 5: Dimension Design.
Chapter 6: Cube Design.
Part Two: Advanced Topics.
Chapter 7: Advanced Topics in MDX.
Chapter 8: Advanced Dimension Design.
Chapter 9: Advanced Cube Design.
Chapter 10: Extending MDX using External Functions.
Part Three: Administration, Performance Tuning Integration.
Chapter 11: Updating Your UDM Data.
Chapter 12: Administering Analysis Services.
Chapter 13: Performance Optimization.
Chapter 14: Data Mining.
Chapter 15: Analyzing Cubes using Office Client Components.
Chapter 16: Integration Services.
Part Four: Scenarios.
Chapter 17: Reporting Services.
Chapter 18: Designing Real–Time Cubes.
Chapter 19: Securing Your Data in Analysis Services.
Appendix: MDX Function and Operator Reference.
Stephen Quinn was born in San Luis Obispo, California. Stephen has a Masters degree (1988) in Cognitive Psychology from California State University, Chico and is scheduled to receive his Masters of Business Administration (MBA) from the University of Washington, Seattle, in June 2006. Stephen is married to Katherine and is raising his daughter, Anastasia. He has been in most roles common to the R&D environment i.e., software developer, technical writer, technical support specialist and several quality assurance roles. Stephen has published some 20 articles in the magazines Byte, InfoWorld and Datamation. With 15+ years of software experience; Stephen has worked the last 8 years at Microsoft; most recently as a Technical Writer in SQL User Education and before that, for several years as Test Manager in the SQL Business Intelligence Unit. You can reach Stephen at email@example.com.
Utilizziamo i cookie di profilazione, anche di terze parti, per migliorare la navigazione, per fornire servizi e proporti pubblicità in linea con le tue preferenze. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie clicca qui. Chiudendo questo banner o proseguendo nella navigazione acconsenti all’uso dei cookie.