Introduction to OLAP

for Analytics Designers

From Chase International

 

 

Course Description

This 2 day, instructor-led training course covers the theory of On-Line Analytical Processing and includes group workshop and practical examples for creating, maintaining, viewing and manipulating a cube of data.  Day one covers OLAP theory and practical sessions with day two aimed at reporting on the cube created using a third party tool, such as Crystal Analysis.

 

Course Cost

Course cost includes courseware and any activity handouts.  If course is off-site it also includes lunch and refreshments.  Costs are dependant on location and number of delegates.

 

Product Editions and Versions

This course is aimed at users of SQL Server 2005 Analysis Services and an analytic tool such as Crystal Analysis or OLAP Intelligence.

 

Who Should Attend?

Any analytics designer who would like to have an introduction to OLAP, to gain a better understanding of multi-dimensional data and how to build and manipulate that data.

 

Course Content

 

Introduction to OLAP

  • Transaction Processing System
  • Decision Support System
  • Defining OLAP
  • Cube Technology

Cube Construction

  • Components of an OLAP Application
  • Multi-dimensional Cubes
  • Measures
  • Dimensions
  • Hierarchies
  • Aggregation
  • Security

Connecting to SLQ Server OLAP Cubes

·         Open interfaces

Developing your OLAP Solution

  • Introduction to Analysis Server

Processing and Browsing Cubes

·         Dimension and Cube Processing

 

Introduction to Crystal Analysis / OLAP Intelligence

Creating a Server Connection

  • Managing Connections

Creating an OLAP Report

  • Templates
  • Worksheets
  • Orientation

Manipulating Data

  • Sorting
  • Filtering
  • Totals
  • Calculations
  • Parameters
  • MDX

Charts and Highlighting

  • Introduction to charts
  • Using highlighting

Navigational Components

  • Slice Navigator
  • Dimension Explorer

Guided Analytic Reports

Publishing and Distributing Reports

 


Pre-Requisite Knowledge

No prior knowledge is required, knowledge of Windows conventions is useful.

Use of an analytic tool, such as Crystal Analysis, is an advantage.

 

Additional Training

This course may be followed by more advanced training in Crystal Analysis or OLAP Intelligence

or workshop-style training on-site.

 

For more information and specific costs :- www.chase-international.com – 01491 572987