On-line training course catalogue
Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000
Type of course: Classroom
| Fee | £1545 |
|---|---|
| Days | 5 |
| Course code | MS2074 |
We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.
Print this page | Download as Word document |
Overview
This course provides delegates with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft SQL Server 2000 Analysis Services.
Prerequisites
Delegates should have a basic understanding of database design, administration, and implementation concepts and a satisfactory level of comfort within the Microsoft Windows 2000 environment.
Delegates will learn how to
- Design multidimensional data marts by using star and snowflake schemas
- Define the term OLAP and its role within data warehousing
- Design OLAP dimensions based on underlying source data
- Design cube storage and aggregations
- Use Microsoft Excel 2000 as an OLAP front-end application
- Create cubes and virtual cubes based on end-user requirements
Outline
Module 1: Introduction to Data Warehousing and OLAP
Module 2: Introducing Analysis Manager Wizards
Module 3: Understanding Analysis Services Architecture
Module 4: Building Dimensions Using the Dimension Editor
Module 5: Using Advanced Dimension Settings
Module 6: Working with Cubes and Measures
Module 7: Case Study – Creating the Store Expense Cube
Module 8: Managing Storage and Optimization
Module 9: Processing Dimensions and Cubes
Module 10: Managing Partitions
Module 11: Implementing Calculations Using MDX
Module 12: Working with Virtual Cubes
Module 13: Using Excel as an OLAP Client
Module 14: Using Actions, Drillthrough, and Writeback
Module 15: Implementing Security
Module 16: Deploying an OLAP Solution
Module 17: Introduction to Data Mining
Module 18: Case Study – Working with the Foodmart Database
Link to this page: http://www.xpertise.co.uk/MS2074
Xpertise – Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 training courses
Xpertise provides Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 training courses from 22 UK locations: in Aberdeen Scotland, Altrincham Manchester, Birmingham West Midlands, Bristol South West, Edinburgh Scotland, Glasgow Scotland, Hinckley East Midlands, Leeds Yorkshire, Leeds Yorkshire (Ring Road), London King William Street, London Middlesex Street, London Rosebery Avenue, London Tabernacle Street, Maidenhead Berkshire, Malmesbury Wiltshire, Manchester (Exchange Quay), Milton Keynes Buckinghamshire, Newcastle Tyne and Wear, Reading Berkshire, Stockport Manchester, Swindon Wiltshire and Washington Tyne and Wear – and at 44 partner locations nationwide.
Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.