Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000

Code: 2074
Course duration: 5 days
Price:

2074: Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000

 

Duration: 5 Days.

Prerequisites:

Before attending this course, students must have:

  • A basic understanding of database design, administration, and implementation concepts
  • satisfactory level of comfort within the Microsoft Windows 2000 environment

Course Description:

This course provides students with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft SQL Server 2000 Analysis Services

Objectives:

  • Define the term OLAP and its role within data warehousing
  • Design multidimensional data marts by using star and snowflake schemas
  • Recognize the fundamental components of a cube
  • Understand the architecture of Analysis Services
  • Create dimensions from relational dimension tables
  • Understand the many types of dimensions
  • Utilize various dimension properties and settings
  • Design OLAP dimensions based on underlying source data
  • Create cubes by using the Cube Wizard and Cube Editor
  • Create and manipulate measures
  • Develop and understand virtual cubes
  • Design cube storage and aggregations
  • Update dimensions and cubes when source data changes
  • Optimize the processing of dimensions and cubes
  • Create partitions within cubes
  • Implement simple calculations by using multidimensional expressions (MDX) and calculated members
  • Use Microsoft Excel 2000 as an OLAP front-end application
  • Understand how data mining fits within OLAP and the Microsoft data warehousing framework
  • Employ actions, drillthrough, and writeback 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

Lesson 1: Introduction to Data Warehousing and OLAP

Introducing Data Warehousing

Defining OLAP Solutions

Understanding Data Warehouse Design

Understanding OLAP Models

Guaranteed to Run

2019-12-11 09:00 to 2019-12-13 17:00
Attend Online
2019-11-22
09:00 to 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2019-11-21 09:00 to 2019-11-22 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2019-11-15
09:00 to 17:00
Attend Online
2019-11-07 09:00 to 2019-11-08 17:00
Attend Online
2019-11-07 09:00 to 2019-11-08 17:00
Attend Online
2019-11-06 09:00 to 2019-11-08 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2019-11-04 09:00 to 2019-11-08 17:00
Attend Online
2019-11-01
09:00 to 17:00
Palm Beach County Florida (Instructor-Led)
2019-11-01
09:00 to 17:00
Raleigh, North Carolina (Instructor-Led)
2019-10-30 09:00 to 2019-11-01 17:00
Attend Online
2019-10-28 09:00 to 2019-11-01 17:00
Northern New Jersey (Virtual Instructor-Led)
2019-10-24 09:00 to 2019-10-25 17:00
Fort Lauderdale, Florida (Instructor-Led)
2019-10-24 09:00 to 2019-10-25 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2019-10-23 09:00 to 2019-10-25 17:00
Attend Online
2019-10-21 09:00 to 2019-10-25 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2019-10-21 09:00 to 2019-10-25 17:00
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review