SAS BI Training

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

Overview of SAS

Overview of SAS 9 Business Intelligence Platform and SAS Data Integration Study Business Intelligence overview Business Intelligence Information Consumers navigating in SAS Data Integration Studio

Module 2:

Working Under Change Management

Working Under Change Management What is change management? repository types using change management

Module 3:

Designing the Data Mart

Designing the Data Mart planning a data warehouse course data for the Orion Star company Orion Star data models

Module 4:

Building a Data Mart

Building a Data Mart review of the case study defining the source data defining the target tables loading the target tables

Module 5:

Administering SAS Data Integration Studio

Administering SAS Data Integration Studio setup tasks for SAS Data Integration Studio setting up change management security planning and implementation (self-study)

Module 6:

Creating and Exploiting OLAP Using the SAS System

introduction to Online Analytical Processing overview of SAS OLAP Cube Studio registering metadata

Module 7:

Working with SAS OLAP Cubes Derived from Detail Tables

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

Module 8:

Working with SAS OLAP Cubes Derived from Star Sachems

Working with SAS OLAP Cubes Derived from Star Sachems creating a SAS OLAP cube from a star schema viewing a SAS OLAP cube with SAS Web OLAP Viewer for JAVA

Module 9:

Monitoring and Tuning a SAS OLAP Cube

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

Module 10:

Accessing SAS from Microsoft Office Applications

overview of the SAS Add-In for Microsoft Office introduction to the course data introduction to the course scenarios

Module 11:

Exploring the SAS Add-In for Microsoft Office

Exploring the SAS Add-In for Microsoft Office using the SAS Add-In for Microsoft Excel using the SAS Add-In for Microsoft Word and Microsoft PowerPoint using the SAS Add-In to publish documents (self-study)

Module 12:

Inserting SAS Data into Microsoft Excel

Inserting SAS Data into Microsoft Excel SAS data set concepts and terminology using SAS data sources with Microsoft Excel using SAS data sources in PivotTables

Module 13:

Analyzing Data with SAS Tasks in Microsoft Office

Analyzing Data with SAS Tasks in Microsoft Office overview of SAS tasks list data task one-way frequencies task table analysis task summary table task bar chart task

Module 14:

Using the SAS Information Delivery Portal

Using the SAS Information Delivery Portal overview of the SAS Information Delivery Portal navigating the SAS Information Delivery Portal changing portal preferences