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. The Creating and Exploiting OLAP Using the SAS System; Creating, Distributing, and Using SAS Stored Processes; and Using SAS Information Map Studio to Create Information Maps courses are available to provide the same type of information in a more detailed approach over a longer period of time.
Learn how to
create and manage metadata using SAS Management Console
analyze data and create stored processes using SAS Enterprise Guide
build information maps using SAS Information Map Studio
build OLAP cubes using SAS OLAP Cube Studio
create reports with SAS Web Report Studio
access information using the SAS Information Delivery Portal.
Who should attend
Business analysts who need to learn the SAS Business Intelligence applications in a short period of time
Prerequisites
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 1: Essentials course or the Self-paced e-Learning programming courses.
Course Outline
Introduction to the platform for SAS Business Analytics
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
Course Materials
Students receive a hardcopy of the course notes.
System Requirements
This course addresses SAS Web Report Studio, SAS OLAP Server, SAS Management Console, SAS Intelligence Platform, SAS Information Map Studio.
