SAS BI Training

Introduction To SAS BI

The SAS Business Intelligence Platform is a suite of software services, components and practices for building intelligent enterprise information delivery applications that exploit the analytic and presentation power of the SAS System. Learn More about SAS BI.

SAS Enterprise Guide
SAS Data Integration Studio (ETL)
SAS Management Console
SAS Web Report Studio
SAS OLAP cube Studio
SAS Add -In for Microsoft Office
SAS Information Map Studio
SAS stored process

SAS BI Content Developer

Understanding SAS BI tool, SAS data integration studio, What is change management and repository types in this module of SAS BI training.

What Is Business Intelligence?
Navigating in SAS BI Data Integration Studio
Working under Change Management
What Is Change Management?
Repository Types in SAS BI
Using Change Management

Designing The Course Data Mart

Data marts are small slices of data warehouse. This module is a collection of tips on how to run your data mart implementation project

Planning a Data Warehouse, Exercises

Building A Data Mart In SAS BI

Learn how to build a data mart during SAS BI training, starting from reviewing a case study.

Review of the Case Study
Define the Source Data
What are the Target Tables in SAS BI
Load the Target Tables
Exercises

Building An OLAP Cube

On-Line Analytical Processing (or OLAP) has long been part of the data storage and exploitation strategy for SAS professional. Take an overview on OLAP in this module of SAS BI Training.

What Is OLAP
Building an OLAP Cube in SAS BI
Solutions to Exercises

SAS BI Transformations, For Slowly Changing Dimensions (Self-Study)

This module is designed to give you a good idea about SCD, its dimensions, load transformation and Lookup transformation.

Defining Slowly Changing Dimensions in SAS BI
How to use SAS BI SCD Type 2 Loader Transformation
Using the Fact Table Lookup Transformation

Job Scheduling

Learn how to schedule data integration studio jobs during SAS BI training.

Scheduling SAS Data Integration Studio Jobs

SAS® Data Integration Studio And Data Quality

Understand what is data integration studio, how to set up tasks for SAS BI data integration etc... in this module of training.

SAS and Data Quality
SAS BI Data Validation Transformation
Apply Lookup Standardization Transformation (Self-Study)
Create Match Code Transformation (Self-Study)
Administering SAS® BI Data Integration Studio
Setup Tasks for SAS® BI Data Integration Studio

Introduction To SAS BI OLAP

This is an introduction module, which lets you know the SAS intelligence platform and who are the information consumers.

Introduction to the SAS® Enterprise Intelligence Platform
SAS BI Overview
Who are SAS Business Intelligence Information Consumers

Overview Of SAS OLAP Cube Studio

In continuation to the introduction module, we’ll learn about SAS Business Intelligence Cube studio, Registering through metadata followed by a few exercises.

Introduction to OLAP Cubes
Introduction to Online Analytical Processing
Overview of SAS OLAP Cube Studio
Registering Metadata
Exercises

Creating SAS BI OLAP Cube

Here we provide a closer look at SAS® OLAP Cube Studio through a screen demonstration. It is a detailed view of this SAS Business Intelligence client.

Working with SAS OLAP Cubes Derived from Detail Tables
Creating a SAS OLAP Cube from a Detail Table
Generating Aggregations in SAS BI cube Using Cross-Dimensional Tuning
Setting Permissions Using SAS Management Console
Viewing a SAS OLAP Cube with SAS Enterprise Guide
Exercises

Creating SAS BI OLAP From Schema

Using a star schema design in SAS is beneficial in the OLAP cube build process and accessing the data directly using a relational information map.

Working with SAS OLAP Cubes Derived from Star Schemas
Creating an SAS  OLAP Cube from a Star Schema
Viewing a SAS OLAP Cube with SAS Web OLAP Viewer for Java
Solutions to Exercises

Monitoring SAS OLAP

This module trains you on how to monitor and tune SAS OLAP Cube, Creating SAS OLAP cube from a summary table and SAS Business Intelligence content developer.

Monitoring and Tuning a SAS OLAP Cube
Building an Information Map from a SAS OLAP Cube
Creating a Report with SAS Web Report Studio
Exercises
Appendix A Working with SAS OLAP Cubes Derived from Summary Tables
Creating a SAS OLAP Cube from a Summary Table
Viewing a SAS OLAP Cube with Microsoft Excel
Appendix B SAS®9 Business Intelligence Training
SAS BI Content Developer

SAS Business Intelligence Applications

An overview of all the SAS Business Intelligence applications

Introduction
SAS BI Java Applications
SAS BI Windows Applications
SAS BI Web Browser Applications

All About SAS BI Management Console

This module aims at having a detailed discussion over SAS Business Intelligence management.

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

SAS Data Integration

By the end of this module, you will have a good understanding about SAS BI DATA integration.

Using SAS Data Integration Studio
SAS Data Integration Studio Overview
SAS Data Integration Studio Interface
Adding Library Definitions
Using the Source Designer
Using the Target Designer
Using the Process Designer
Exercises

Using SAS OLAP Cube Studio

In this module, we provide the usage and overview of SAS OLAP Cube Studio interface.

Using SAS OLAP Cube Studio
Overview of SAS OLAP Cube Studio
SAS OLAP Cube Studio Interface

Overview Of SAS Add-In For Microsoft Office

Deepen your SAS BI skills by knowing how to Add-In SAS BI with Microsoft Office.

Using the SAS BI Add-In for Microsoft Office
Overview of the SAS BI Add-In for Microsoft Office
Using the SAS BI Add-In for Microsoft Office Exercises

SAS Enterprise Guide

SAS Enterprise Guide is a point-and-click, menu-and wizard-driven tool that empowers users to analyse data and publish results. Explore more about SAS Enterprise Guide in this module.

Using SAS Enterprise Guide
Investigating the Features of SAS Enterprise Guide
Exploring SAS Enterprise Guide

Overview Of SAS Information Map Studio

Learn all about what is SAS Business Intelligence information Map studio.

Using SAS Information Map Studio
Overview of the SAS Information Map Studio
Using SAS Information Map Studio
Exercises

Using SAS Web Report Studio

Finally, learn all about SAS Web Report Studio in this module of training.

Using SAS Web Report Studio
Overview of SAS Web Report Studio
Using SAS Web Report Studio
Exercises