 |
Professional SQL Server Analysis Services 2005 with MDX
Read an excerpt:
Chapter 1: Introduction to Data Warehousing and Analysis Services 2005
Excerpt provided courtesy of John Wiley & Sons Inc. Copyright © John Wiley & Sons Inc. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Professional SQL Server 2005 Integration Services; Brian Knight, et al, $30.95, 38% Off!
- Professional SQL Server 2005 Reporting Services; Paul Turley, et al, $24.95, 38% Off!
- The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset; Joy Mundy, et al, $42.50, 15% Off!
- Microsoft SQL Server 2005 Analysis Services Step by Step; Hitachi Consulting Services, et al, $23.95, 40% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
* Written by the lead developers of Analysis Services at Microsoft, this book
begins with an overview showing how Analysis Services and MDX can be used to
build data warehouses and multidimensional databases
* The authors then describe the development processes for building dimensions
and cubes from various data sources
* Demonstrating a variety of techniques in real-world scenarios, the book shows
how MDX can be used to query databases to provide sophisticated analysis of
business problems
* Finally, the book explains how Analysis Services can be used with other components
of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive,
end-to-end solutions
Table of Contents
1. Introduction.
2. A First Look at SQL Server Analysis Services 2005 Tools.
3. Introduction to MDX Working with Data Sources and Data.
4. Source Views.
5. Creating and Working with Dimensions.
6. Creating and Working with Cubes.
I: ADVANCED TOPICS IN MDX, DIMENSIONS, CUBES, AND EXTENSIONS.
7. Advanced Topics in MDX.
8. Enhancements to Your Dimensions.
9. Enhancements to Your Cubes.
10. Extending MDX User Designed Functions.
II: ADMINISTRATION / INTEGRATION.
11. Administering Analysis Services.
12. Performance Optimization.
13. Data Mining.
14. Introduction to Integration Services.
15. Introduction to Supporting Services.
16. Client Components.
III: SEENARIOS.
17. Designing Real Time Cubes.
18. Securing Your Data in Analysis Services.
19. Updating Your UDM Data.
|
|
