Introduction to SAS Business Intelligence Applications

Role

Data Manager

Duration

2 days

Description

This course is designed for anyone who wants a hands-on overview of the new SAS®9 Data Management and Business Intelligence Client tools. The course focuses on new features in the areas of foundation technologies, data warehousing, intelligent storage and business intelligence. This course uses a pre-installed SAS®9 image on the classroom machines and does not cover software installation and configuration.

Prerequisites

N/A

SAS Modules Used

SAS®9, SAS Management Console, SAS DI Studio, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Enterprise Guide, SAS Add-in for Microsoft Office, SAS Information Delivery Portal.

Course Topics

Introduction to the SAS®9 Business Intelligence Platform:

• Architecture Overview
• Security Concepts

Introduction to the SAS Intelligence Architecture:

• SAS Business Intelligence Overview
• Business Intelligence Security

Overview of the SAS Business Intelligence Clients:

• Java Clients
• Windows Clients
• Browser Clients

SAS Management Console:

• SAS Management Console Overview
• How SAS Management Console Works
• Introduction to SAS Management Console Plug-Ins
• Working with the User Interface

SAS DI Studio:

• SAS DI Studio Overview
• SAS DI Studio Interface
• Advanced DI Studio Features (Self-Study)

SAS OLAP Cube Studio:

• SAS OLAP Cube Studio Overview
• SAS OLAP Cube Studio Interface
• SAS OLAP Cube Studio and Microsoft Excel

Working with SAS Stored Processes:

• An Overview of Stored Processes
• Creating and Registering a Stored Process

SAS Enterprise Guide:

• New Features of SAS Enterprise Guide
• Exploring Enterprise Guide
• Using the Stored Process Manager
• Working with OLAP Cubes in Enterprise Guide

SAS Add-In for Microsoft Office:

• Overview of the SAS Add-In for Microsoft Office
• Using the SAS Add-In for Microsoft Office

SAS Information Map Studio:

• Overview of SAS Information Map Studio
• Using SAS Information Map Studio

SAS Web Report Studio:

• Overview of SAS Web Report Studio
• Using SAS Web Report Studio

SAS Information Delivery Portal:

• Overview of SAS Information Delivery Portal
• Using SAS Information Delivery Portal

Objectives

After attending this course you will be able to: Describe SAS®9 multi-tier architecture, Define metadata using SAS Management Console, Create a data warehouse using SAS DI Studio Build an OLAP cube, Build SAS Information Maps, Create reports using SAS Web Report Studio, Create SAS stored processes, Use SAS Enterprise Guide to exploit OLAP cubes, Run stored processes, Use the SAS Microsoft Office Add-in to run stored processes, Access data from SAS Servers, Use the SAS Information Delivery Portal to view customised content.