Overview of SAS Business Intelligence and Data Integration Applications

Duration: 2.0 days CEU: 1.2

This course provides a comprehensive, hands-on overview of the SAS Intelligence Platform applications, including the Data Integration applications.

Learn how to

use SAS Management Console
use SAS Data Integration Studio
create an OLAP cube using SAS OLAP Cube Studio
access data, create reports, and perform analyses using the SAS Add-In for Microsoft Office
access data and create reports and stored processes using SAS Enterprise Guide
write stored process code and register stored processes
build business views of enterprise data
build reports from a Web browser
access existing information using the SAS Information Delivery Portal.

Who should attend

Business users, data warehouse architects, and SAS system administrators

Prerequisites

No SAS experience or programming experience is required although you should

have some computer experience. Specifically, you should be able to log on and off a computer and use a keyboard or mouse.
have some experience using Microsoft Office applications. Specifically, you should be able to open and save documents, use the menus and toolbars to accomplish tasks, and navigate Word documents, PowerPoint presentations, and Excel spreadsheets.
know how to use a Web browser to access information.

To help you prepare for class, please view the SAS Business Intelligence Overview.

Course Contents

Introduction to the SAS Intelligence Platform

identify the multiple tiers of the SAS Intelligence Platform
define SAS Intelligence Platform security

Overview of the SAS Intelligence Platform Applications

identify SAS Intelligence Platform applications
review SAS Intelligence Platform desktop applications
review SAS Intelligence Platform Web browser applications

Introduction to the Orion Star Data and Case Study

explore the data used in this course
discuss common job roles
discuss the Orion Star data models
discuss the case study scenario

Overview of the SAS Management Console

identify the tasks managed by the SAS Management Console
identify the role of the SAS Metadata Server
discuss metatdata profiles and metadata repositories
review the categories of plug-ins available in SAS Management Console

Using SAS Data Integration Studio

discuss the components and features of SAS Data Integration Studio
explore the SAS Data Integration Studio user interface
discuss various types of transformation templates
introduce the Source Designer
introduce the Target Designer
introduce the Process Designer

Using SAS OLAP Cube Studio

define Online Analytical Processing (OLAP)
discuss the SAS servers that SAS OLAP Cube Studio work with
identify the components that make up the SAS OLAP Cube Studio interface
discuss permissions needed to view an OLAP cube
use Microsoft Excel to view a SAS OLAP cube

Using the SAS Add-in for Microsoft Office

discuss the capabilities of the SAS Add-In for Microsoft Office
using the SAS Add-In for Microsoft Office

Using SAS Enterprise Guide

investigating the features of SAS Enterprise Guide
exploring SAS Enterprise Guide
working with OLAP cubes in SAS Enterprise Guide

Working with SAS Stored Processes

creating and registering a stored process
using the Create New Stored Process Wizard

Using SAS Information Map Studio

overview of SAS Information Map Studio
using SAS Information Map Studio

Using SAS Web Report Studio

discuss the SAS Report Object Model
identify which SAS Servers can be used by SAS Web Report Studio
explore the SAS Web Report Studio user interface
discuss the Report Wizard

Using SAS Information Delivery Portal

define the concept of pages and portlets
discuss available content in the SAS Information Delivery Portal
define WebDAV and how it is used by the SAS Information Delivery Portal
customize the portal by adding and organizing content

Introduction to SAS Business Visualization Capabilities

discuss how SAS supports business visualization
define the components used to display a dashboard in the SAS BI Dashboard portlet
define the steps to build a dashboard
explore SAS Visual BI

Manually Creating a Stored Process

explore the steps to create and register a stored process manually
discuss the Metadata Libname Engine
introduce the stored process macros

Software Addressed

This course addresses the following software product(s): SAS Intelligence Platform.

Course Materials

Students receive a hardcopy of the course notes.

U.S. Schedule

06OCT2008 Dallas, TX

17NOV2008 New York, NY

16DEC2008 Seattle, WA

Check for additional and updated schedule information online at support.sas.com/courses/sbiovr.html.

Registration

To register for this course in the US, call 800-333-7660 or visit support.sas.com/training. This course is also available for on-site training, or you can create a custom course by combining material from several courses. For more details, contact SAS Education in Cary, NC at 919-531-7321 or send e-mail to training@sas.com.