SAS®9 Business Intelligence Fast Track (SBIFAST)

Duration

5 days

Description

This intensive training course provides accelerated learning for those who will use SAS Business Intelligence applications. This course is for individuals who are comfortable with learning large amounts of information in a short period of time. Other courses are available to provide the same type of information in a much more detailed approach over a longer period of time.

Learn how to

• use SAS Management Console to create and manage metadata
• use SAS Enterprise Guide to analyze data and create stored processes
• use SAS Information Map Studio to build information maps
• use SAS OLAP Cube Studio to build OLAP cubes
• create reports with SAS Web Report Studio
• access information using the SAS Information Delivery Portal.

Prerequisite Skills

Before attending this course you should view the free Self-paced e-Learning module Overview: SAS Business Intelligence. You should also have some SAS programming experience. SAS programming experience can be obtained by attending the SAS Programming I: Essentials course or the Self-paced e-Learning programming courses.

Course Topics

Introduction to the SAS Intelligence Platform

• defining common job roles
• discussing the course flow

Exploring Business User Applications

• exploring SAS Add-in for Microsoft Office
• exploring SAS Web Report Studio
• exploring the SAS Information Delivery Portal

Using SAS Management Console

• exploring how SAS Management Console works
• introduction to the SAS Management Console plug-ins
• working with the user interface

Overview of SAS Stored Processes

• exploring stored process uses and applications
• using the stored process Web application (self-study)

Manually Creating and Registering SAS Stored Processes

• creating and registering a SAS Stored Process
• introducing input parameters
• working with input parameters

Creating and Running SAS Stored Processes with SAS Enterprise Guide

• overview of SAS Enterprise Guide
• creating a stored process with SAS Enterprise Guide
• exploring other features for stored processes in SAS Enterprise Guide

Creating Results Packages from Stored Processes

• creating transient and permanent package results
• viewing result packages with SAS Package Reader

Introduction to SAS Information Map Studio

• overview of SAS Information Maps
• exploring SAS Information Map Studio
• overview of the course case study

Enhancing Information Maps

• updating an information map with data items, filters, and folders
• adding additional data sources to an information map

Information Maps, Predefined Filters, and Stored Processes

• overview of information map prefilters
• building a general prefilter
• building an authorization-based prefilter
• associating stored processes with an information map

Introduction to Online Analytical Processing

• introduction to online analytical processing
• overview of SAS OLAP Cube Studio

Working with SAS OLAP Cubes Derived from Detail Tables and Star Schemas

• 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
• creating an 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 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 for SAS OLAP Cubes

• establishing a ragged hierarchy
• subsetting data during the build process

Introduction to SAS Business Visualization Capabilities

• defining business visualization
• exploring SAS BI Dashboard
• exploring SAS Visual BI

Booking

Please contact the Education Team at SAS for the latest information on all SAS courses or to put your name on our specialised course waiting list.