 |
Microsoft SQL Server 2000 Analysis Services Step by Step View Larger Image | OLAP Train, Reed Jacobson Microsoft Press, Paperback, Bk&CD edition, Published September 2000, 379 pages, ISBN 0735609047 | List Price: $39.99 Our Price: $24.95 You Save: $15.04 (38% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 2 Average Customer Rating:      Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Microsoft SQL Server 2000 DTS Step by Step; Carl Rabeler, $24.95, 38% Off!
- MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, 2nd Edition; Microsoft Corp., $37.50, 37% Off!
- Hitchhiker's Guide to SQL Server 2000 Reporting Services; Peter Blackburn, et al, $31.95, 36% Off!
- MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, 2nd Edition; Microsoft Corp., $37.50, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
MICROSOFT SQL SERVER; 2000 ANALYSIS SERVICES STEP BY STEP shows
Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You’ll discover why these services make it easier to analyze huge amounts of data quickly, and you’ll learn how to develop a wide range of advanced dimensional-data applications—from enterprise reporting
tools to advanced decision-support systems. The book’s easy-to-follow lessons begin with clear objectives and include real-world business examples, with a companion CD full of sample files that support each lesson. This title shows you how to:
- Administer the Analysis Manager: Understand the fundamentals behind data dimensions and hierarchies, data warehousing, and the Microsoft Analysis Services architecture, and use the
Microsoft Analysis Manager application to define and populate data cubes.
- Create and display cubes: Define and modify measures and dimensions. Design, build, process, and view cubes, from simple to advanced, with cube and dimension editors. Use Microsoft Excel PivotTable Reports and the PivotTable List in Microsoft Excel to browse cubes, and create cubes
using Microsoft Office.
- Query cubes: Use multidimensional expressions (MDX) values and sets and the MDX Sample application to query and display dimensional data.
- Perform advanced administration: Choose data storage options and the Storage Design Wizard to optimize, manage, and update data efficiently. Automate the Analysis server to process an OLAP database. Work with partitions and automate updates, and apply security to cubes.
Customer Reviews
Customer Reviews: 2 Average Customer Rating:      May 4, 2003     Kalpesh Salot from California, USA Great Book for OLAP developer's I am working OLAP Dataware House Porject and buiding huge cube with more then 34 Dimesion, The last chapter of this book is really very help. Thanks to OLAP Train providing good solutions!
Thanks -Kalpesh
Sep 28, 2001     Trevor from Jeffersonville, IN A plethora of knowledge! Explores the wide range of options analysis services provides!! Very helpful to my current project.
Good info on MDX and general cube administration
Explores almost all the options for each type of dimension.
|
 |