|
|
 |
Microsoft SQL Server 2000
Designing & Implementing OLAP Solutions with SQL 2000 (2074)
|
|
|
Who Should Attend
| SQL Server database and Windows 2000 network administrators and developers who are responsible for writing queries and the management and technical support of Windows 2000 networks, support engineers, MCP and MCSE candidates. |
Prerequisites
| A basic understanding of database design, administration and implementation concepts. Students will also need experience with a Microsoft Windows 2000 environment. |
Course Objectives
| This course provides the Microsoft necessary knowledge and skills required to design, implement, and deploy OLAP solutions, using Microsoft SQL Server 2000 Analysis Services. Participants learn and practice designing multi-dimensional data marts, create dimensions from relational dimension tables, and utilise various dimension properties and settings as well as design OLAP dimensions based on underlying source data. Students will learn how to create cubes, design and manipulate measures, design cube storage and aggregations and update dimensions and cubes when source data changes.
|
|
|
| Participants will also gain the skills to optimise the processing of dimensions and cubes, create partitions within cubes, implement simple calculations. Understand how data mining fits within OLAP and the Microsoft data warehousing framework. Employ actions, drill through, and write back for data analysis. Design and implement cube and dimension security. Automate the processing of dimensions and cubes through Data Transformation Services (DTS). Create cubes and virtual cubes based on end-user requirements. |
Course Content
| 1. Overview of Data Warehousing and OLAP
|
| 2. Preparing, building and processing a cube
|
| 3. Understanding Analysis Services Architecture
|
| 4. Building shared, private and standard diensions
|
| 5. Working with levels, hierarchies and time dimensions
|
| 6. Working with cubes and measures
|
| 7. Creating and updating the store expense cube
|
| 8. Managing storage and optimisation
|
| 9. Processing dimensions and cubes
|
| 10.Using partitions to improve both processing and query performance
|
| 11.Implementing calculations using Multi-Dimensional Expressions (MDX)
|
| 12.Working with virtual cubes
|
| 13.Using Excel as an OLAP Client
|
| 14.Using actions, drill through and write back
|
| 15.Implementing security
|
| 16.Deploying an OLAP solution
|
| 17.Introduction to Data Mining
|
| 18.Working with the Foodmart Database |
|
|
|
|
Top