SAS Institute. The Power to Know

Learning Center

Stay in Touch

Not sure what course to take?

Speak with an expert curriculum consultant at 800-333-7660 or send an e-mail.

Submit Your Course Requests

Want this course at another location or on a different date? Let us know your course needs.

On-site Pricing

Course fee and EPTO/APTO units differ for on-site training.
Get your groove on!
free iPod offer Register with friend by Nov 30. Save 15%; get a free iPod shuffle.

Creating and Exploiting OLAP Using the SAS System

Duration: 2.0 days
Course fee: $1,150
EPTO units: 2.2
CEUs: 1.2
Register now

This course teaches you how to understand, create, and exploit Online Analytical Processing (OLAP) using SAS. This course requires the SAS Intelligence Platform.

This course can help prepare you for the following certification exam(s): SAS Warehouse Technology Exam, SAS Warehouse Architect Concepts Exam.

Learn how to

Who should attend

Data modelers and system experts

Expand/Collapse AllExpand All      Expand/Collapse AllCollapse All      PrintPrint version

Prerequisites
Familiarity with SAS programming and table structures is helpful but not required. You can gain SAS knowledge by completing the SAS Programming 1: Essentials course. Familiarity with Structured Query Language (SQL) or Multidimensional eXpressions (MDX) is also helpful, but not required.
Course Contents
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 aggregations 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 a SAS OLAP cube from a star schema
  • viewing a SAS OLAP cube with SAS Web OLAP Viewer for Java
Monitoring and Tuning a SAS OLAP Cube
  • using Application Response Measurement (ARM) for tuning
  • building an information map from a SAS OLAP cube
  • creating a report with SAS Web Report Studio
  • generating aggregations using ARM analysis
Working with Input Data
  • establishing a ragged hierarchy
  • subsetting data during the build process
Using MDX in SAS Enterprise Guide
  • utilizing MDX in SAS Enterprise Guide
  • creating named sets and calculated members with MDX
Working with SAS OLAP Cubes Derived from Summary Tables
  • creating a SAS OLAP cube from a summary table
  • viewing a SAS OLAP cube with Microsoft Excel
Software
This course addresses SAS Enterprise Guide, SAS Intelligence Platform, SAS Information Delivery Portal, SAS Information Map Studio, SAS Management Console.
Course Materials
Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.
Share Your Thoughts
Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Register now


created using SAS software This page was created using SAS software.