SAS BI Tools & Applications

• 1.SAS Enterprise Guide
• 2.SAS Data Integration Studio (ETL),
• 3.SAS Management Console,
• 4.SAS Web Report Studio
• 5.SAS OLAP cube Studio
• 6.SAS Add –In for Microsoft Office
• 7.SAS Information Map Studio
• 8.SAS stored proess

SAS DI Content Developer
Chapter 1 SAS®9 Enterprise Intelligence Platform and SAS® Data Integration Studio 1-1

• 1.What Is Business Intelligence?
• 2.Navigating in SAS Data Integration Studio
• 3.Chapter 2 Working under Change Management
• 4.What Is Change Management?
• 5.Repository Types
• 6.Using Change Management

Designing the Course Data Mart

• 1.Planning a Data Warehouse
• 2.Exercises

Building a Data Mart

• 1.Review of the Case Study
• 2.Define the Source Data
• 3.Define the Target Tables
• 4.Load the Target Tables
• 5.Exercises

Building an OLAP Cube

• 1.What Is OLAP
• 2.Building an OLAP Cube
• 3.Solutions to Exercises

Transformations for Slowly Changing Dimensions (Self-Study)

• 1.Defining Slowly Changing Dimensions
• 2.Using the SCD Type 2 Loader Transformation
• 3.Using the Fact Table Lookup Transformation

Job Scheduling

• 1.Scheduling SAS Data Integration Studio Jobs

SAS® Data Integration Studio and Data Quality

• 1.SAS and Data Quality
• 2.Data Validation Transformation
• 3.Apply Lookup Standardization Transformation (Self-Study
• 4.Create Match Code Transformation (Self-Study)
• 5.Chapter 10 Administering SAS® Data Integration Studio
• 6.Setup Tasks for SAS® Data Integration Studio

SAS OLAP CUBE STUDIO 9.1

Chapter 1 

• 1.Introduction to the SAS® Enterprise Intelligence Platform
• 2.SAS Business Intelligence Overview
• 3.Business Intelligence Information Consumers

Chapter 2 

• 1.Introduction to OLAP Cubes
• 2.Introduction to Online Analytical Processing
• 3.Overview of SAS OLAP Cube Studio
• 4.Registering Metadata
• 5.Exercises

Chapter 3 

• 1.Working with SAS OLAP Cubes Derived from Detail Tables
• 2.Creating a SAS OLAP Cube from a Detail Table
• 3.Generating Aggregations Using Cross-Dimensional Tuning
• 4.Setting Permissions Using SAS Management Console
• 5.Viewing a SAS OLAP Cube with SAS Enterprise Guide
• 6.Exercises

Chapter 4

• 1.Working with SAS OLAP Cubes Derived from Star Schemas
• 2.Creating an OLAP Cube from a Star Schema
• 3.Viewing a SAS OLAP Cube with SAS Web OLAP Viewer for Java
• 4.Solutions to Exercises

Chapter 5 

• 1.Monitoring and Tuning a SAS OLAP Cube
• 2.Building an Information Map from a SAS OLAP Cube
• 3.Creating a Report with SAS Web Report Studio
• 4.Exercises
• 5.Appendix A Working with SAS OLAP Cubes Derived from Summary Tables
• 6.Creating a SAS OLAP Cube from a Summary Table
• 7.Viewing a SAS OLAP Cube with Microsoft Excel
• 8.Appendix B SAS®9 Business Intelligence Training
• 9.SAS BI Content Developer

Chapter 6

• 1.Overview of the SAS Business Intelligence Applications
• 2.Introduction
• 3.SAS BI Java Applications
• 4.SAS BI Windows Applications
• 5.SAS BI Web Browser Applications

Chapter 7

• 1.Overview of the SAS Management Console
• 2.Introduction to the SAS Management Console
• 3.How the SAS Management Console Works
• 4.Introduction to the SAS Management Console Plug-Ins
• 5.Working with the User Interface

Chapter 8

• 1.Using SAS Data Integration Studio
• 2.SAS Data Integration Studio Overview
• 3.The SAS Data Integration Studio Interface
• 4.Adding Library Definitions
• 5.Using the Source Designer
• 6.Using the Target Designer
• 7.Using the Process Designer
• 8.Exercises

Chapter 9

• 1.Using SAS OLAP Cube Studio
• 2.Overview of SAS OLAP Cube Studio
• 3.SAS OLAP Cube Studio Interface

Chapter 10

• 1.Using the SAS Add-In for Microsoft Office
• 2.Overview of the SAS Add-In for Microsoft Office
• 3.Using the SAS Add-In for Microsoft Office
• 4.Exercises

Chapter 11

• 1.Using SAS Enterprise Guide
• 2.Investigating the Features of SAS Enterprise Guide
• 3.For Your Information v
• 4.Exploring SAS Enterprise Guide

Chapter 12

• 1.Using SAS Information Map Studio
• 2.Overview of the SAS Information Map Studio
• 3.Using SAS Information Map Studio
• 4.Exercises

Chapter 13 

• 1.Using SAS Web Report Studio
• 2.Overview of SAS Web Report Studio
• 3.Using SAS Web Report Studio
• 4.Exercises