Professional SQL Server Analysis Services 2005 with MDX

Sivakumar Harinath, Stephen R. Quinn - Collection Programmer to Programmer

828 pages, parution le 01/05/2006

Ajouter à une liste

Indisponible

Résumé

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 to MDX to query databases and for sophicticated business analysis How to harness features such as multiple measure groups, Bl 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 Bl 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 Bl and leveraging the SQL Server 2005 tool set.

L'auteur - Sivakumar Harinath

Sivakumar Harinath is the Test Lead for Analysis Services 2005 at Microsoft.

Sommaire

Introduction to Data Warehousing and Analysis Services 2005
First Look at Analysis Services 2005
Introduction to MDX
Working with Data Sources and Data Source Views
Dimension Design
Cube Design
Advanced Topics in MDX
Advanced Dimension Design
Advanced Cube Design
Extending MDX using External Functions
Updating Your UDM Data
Administering Analysis Services
Performance Optimization
Data Mining
Analyzing Cubes using Office Client Components
Integration Services
Reporting Services
Designing Real-Time Cubes
Securing Your Data in Analysis Services
Appendix: MDX Function and Operator Reference
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Sivakumar Harinath, Stephen R. Quinn
Collection	Programmer to Programmer
Parution	01/05/2006
Nb. de pages	828
Format	18,5 x 23,5
Couverture	Broché
Poids	1234g
Intérieur	Noir et Blanc
EAN13	9780764579189
ISBN13	978-0-7645-7918-9