Table of Contents


professional sql server analysis services 2005 with mdx
Professional SQL Server Analysis Services 2005 with MDX
bySivakumar HarinathandStephen R. Quinn
Wrox Press 2006 (856 pages)
ISBN:0764579185

Written by members of the Analysis Services product team at Microsoft, this timely, authoritative book shows you how to use Analysis Services with SQL Server components to provide comprehensive, end-to-end solutions.

Table of Contents
Professional SQL Server Analysis Services 2005 with MDX
Introduction
Section I - 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
Section II - 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
Section III - 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
Section IV - Scenarios
Chapter 17 - Reporting Services
Chapter 18 - Designing Real-Time Cubes
Chapter 19 - Securing Your Data in Analysis Services
Appendix A - MDX Function and Operator Reference
Index
List of Figures
List of Tables
List of Code Examples


Back Cover

SQL Server Analysis Services 2005 provides you with the business intelligence platform needed to build full-scale, multidimensional databases. MDX is the query language used to extract information from those multidimensional databases. Analysis Services 2005 supports core business functions such as market analysis, budgeting and forecasting.

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

  • The development process for designing Unified Dimensional Models (UDM)
  • Using MDX to query databases and for sophisticated business analysis
  • How to harness features such as multiple measure groups, BI wizards, Key performance indicators, and Actions
  • How to integrate Analysis Services with other SQL Server 2005 components in order to provide the best possible end-to-end solutions
  • How to manage and secure Analysis Services efficiently in support of your BI users
  • How to optimize your design and/or scale Analysis Services to extract the best performance

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.

About the Authors

Sivakumar Harinath was born in Chennai, India. Siva has a Ph.D. in Computer Science from the University of Illinois at Chicago. His thesis title was: "Data Management Support for Distributed Data Mining of Large Datasets over High Speed Wide Area Networks." Siva has worked for Newgen Software Technologies (P) Ltd., IBM Toronto Labs, Canada, and has been at Microsoft since February of 2002. Siva started as a Software Design Engineer in Test (SDET) in the Analysis Services Performance Team and is currently an SDET Lead for Analysis Services 2005. Siva's other interests include high performance computing, distributed systems and high speed networking.

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