Microsoft SQL Server 2000 Analysis Services

Step by step

Reed Jacobson, Olap Train - Collection Step by Step

380 pages, parution le 01/01/2000

Ajouter à une liste

Indisponible

Résumé

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

L'auteur - Reed Jacobson

Reed Jacobson is Vice President, Consulting for LEX Software, a company that specializes in custom development services using Microsoft Excel, Visual Basic, SQL Server, and other products. LEX Software is one of the original companies invited to participate in what later became the Microsoft Solution Provide Program. Reed received a B.A. in Japanese and Linguistics, and MBA from Brigham Young University, and a graduate fellowship in Linguistics from Cornell University. He worked as a Software Applications Specialist for Hewlett-Packard for 10 years and ran his own consulting firm for five years.

Reed is the author of Excel Trade Secrets for Windows, Microsoft Excel Advanced Topics Step by Step, and Office 2000 Expert Companion. He has given presentations on Excel at TechEd and other Microsoft conferences and seminars.

Autres livres de Reed Jacobson

Microsoft Excel 2007 VBA - Etape par étape - Pro

Découvrir tous les livres de Reed Jacobson

Sommaire

Administration Fundamentals
- A Data Analysis Foundation
- Analysis Manager from 500 Feet
- Dimension and Cube Editors
- Advanced Dimensions and Cubes
- Office 2000 Analysis Components
Multidimensional Expressions
- MDX Values
- MDX Sets
Advanced Administration
- Storage Optimization
- Processing Optimization
- Dimension Optimization
- Security

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Reed Jacobson, Olap Train
Collection	Step by Step
Parution	01/01/2000
Nb. de pages	380
Format	18,5 x 23,5
Couverture	Broché
Poids	840g
Intérieur	Noir et Blanc
EAN13	9780735609044
ISBN13	978-0-7356-0904-4