Learn to add a new dimension to your data with analysis services!
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. Youll discover why these services make it easier to analyze huge amounts of data quickly, and youll learn how to develop a wide range of advanced dimensional-data applicationsfrom enterprise reporting tools to advanced decision-support systems. The books 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.
Or split into 4x interest-free payments of 25% on orders over R50
Learn more
Learn to add a new dimension to your data with analysis services!
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. Youll discover why these services make it easier to analyze huge amounts of data quickly, and youll learn how to develop a wide range of advanced dimensional-data applicationsfrom enterprise reporting tools to advanced decision-support systems. The books 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.
Imprint | Microsoft Press,U.S. |
Country of origin | United States |
Series | Step by step |
Release date | September 2000 |
Availability | Supplier out of stock. If you add this item to your wish list we will let you know when it becomes available. |
First published | September 2000 |
Authors | Microsoft Corporation, R. Jacobson |
Dimensions | 240 x 188 x 30mm (L x W x T) |
Format | Paperback |
Pages | 379 |
Running time | 1 hour |
ISBN-13 | 978-0-7356-0904-4 |
Barcode | 9780735609044 |
Categories | |
LSN | 0-7356-0904-7 |