Creating and Exploiting OLAP using SAS®

Role

Data Modeller and System Expert.

Duration

2 days

Description

This course is designed for data modellers and system experts who want to understand, create and exploit Online Analytical Processing (OLAP) using SAS. It defines SAS OLAP cubes, explores their characteristics and demonstrates how to create and exploit OLAP cubes using a variety of SAS products; SAS OLAP Cube Studio, SAS Enterprise Guide, Microsoft Excel with the SAS OLAP Data Provider and the SAS Information Delivery Portal.

Prerequisites

Familiarity with SAS programming and table structures is helpful but not required. You can gain SAS knowledge by completing the SAS® Essentials: An Introduction to SAS Programming course. Familiarity with Structured Query Language (SQL) or Multidimensional eXpressions (MDX) is also helpful, but not required.

SAS Modules Used

SAS Enterprise Guide, SAS OLAP Server, SAS Management Console, SAS Information Map Studio, SAS Web Report Studio, SAS Information Delivery Portal, SAS Web OLAP Viewer for Java

Course Topics

Introduction to the SAS® Intelligence Platform

• SAS Business Intelligence Overview
• Business Intelligence Information Consumers
• Overview of the Orion Star Data

Introduction to OLAP Cubes

• Introduction to Online Analytical Processing
• Overview of SAS OLAP Cube Studio. Registering Metadata

Working with SAS OLAP Cubes Derived from Detail Tables

• Creating a SAS OLAP Cube from a Detail Table
• Generating Aggregation Using Cross-Dimensional Tuning
• Setting Permissions Using SAS Management Console
• Viewing a SAS OLAP Cube with SAS Enterprise Guide

Working with SAS OLAP Cubes Derived from Star Schemas

• Creating an OLAP Cube from a Star Schema
• Viewing a SAS OLAP Cube with Microsoft Excel

Monitoring and Tuning a SAS OLAP Cube

• Using Application Response Measurement for Tuning
• Building an Information Map from a SAS OLAP Cube
• Viewing a SAS OLAP Cube with the Visual Data Explorer
• Creating a Report with SAS Web Report Studio
• Generating Aggr

Additional Features of the SAS OLAP Cube Designer

• Ragged Hierarchies. Subsetting during the Build Process
• Viewing a SAS OLAP Cube with SAS Web OLAP Viewer for Java

Using MDX in SAS Enterprise Guide (Self-study)

• Utilizing MDX in SAS Enterprise Guide
• Creating Named Sets and Calculated Members with MDX

Objectives

After attending this course you will be able to: Understand, create and exploit Online Analytical Processing using SAS. Specifically you will be able to: Create and exploit OLAP cubes using a variety of SAS products including SAS OLAP Cube Studio, SAS Enterprise Guide, Microsoft® Excel with the SAS OLAP Data Provider and the SAS Information Delivery Portal.