SAS BI online training institute in USA

SAS BI Online Training institute +91 - 9246 333 245.

course content for sas bi training online and class room training

SAS BI Tools & Applications

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 proess

SAS DI Content Developer

What Is Business Intelligence?

Navigating in SAS Data Integration Studio

Chapter 2 Working under Change Management

What Is Change Management?

Repository Types

Using Change Management

Designing the Course Data Mart

Planning a Data Warehouse

Exercises

Building a Data Mart

Review of the Case Study

Define the Source Data

Define the Target Tables

Load the Target Tables

Exercises

Building an OLAP Cube

What Is OLAP

Building an OLAP Cube

Solutions to Exercises

Transformations for Slowly Changing Dimensions (Self-Study)

Defining Slowly Changing Dimensions

Using the SCD Type 2 Loader Transformation

Using the Fact Table Lookup Transformation

Job Scheduling

Scheduling SAS Data Integration Studio Jobs

SAS® Data Integration Studio and Data Quality

SAS and Data Quality

Data Validation Transformation

Apply Lookup Standardization Transformation (Self-Study

Create Match Code Transformation (Self-Study)

Chapter 10 Administering SAS® Data Integration Studio

Setup Tasks for SAS® Data Integration Studio

SAS OLAP CUBE STUDIO 9.1
Chapter 1

Introduction to the SAS® Enterprise Intelligence Platform

SAS Business Intelligence Overview

Business Intelligence Information Consumers

Chapter 2

Introduction to OLAP Cubes

Introduction to Online Analytical Processing

Overview of SAS OLAP Cube Studio

Registering Metadata

Exercises

Chapter 3

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

Exercises

Chapter 4

Working with SAS OLAP Cubes Derived from Star Schemas

Creating an OLAP Cube from a Star Schema

Viewing a SAS OLAP Cube with SAS Web OLAP Viewer for Java

Solutions to Exercises

Chapter 5

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

Chapter 6

Overview of the SAS Business Intelligence Applications

Introduction

SAS BI Java Applications

SAS BI Windows Applications

SAS BI Web Browser Applications

Chapter 7

Overview of the SAS Management Console

Introduction to the SAS Management Console

How the SAS Management Console Works

Introduction to the SAS Management Console Plug-Ins

Working with the User Interface

Chapter 8

Using SAS Data Integration Studio

SAS Data Integration Studio Overview

The SAS Data Integration Studio Interface

Adding Library Definitions

Using the Source Designer

Using the Target Designer

Using the Process Designer

Exercises

Chapter 9

Using SAS OLAP Cube Studio

Overview of SAS OLAP Cube Studio

SAS OLAP Cube Studio Interface

Chapter 10

Using the SAS Add-In for Microsoft Office

Overview of the SAS Add-In for Microsoft Office

Using the SAS Add-In for Microsoft Office

Exercises

Chapter 11

Using SAS Enterprise Guide

Investigating the Features of SAS Enterprise Guide

For Your Information v

Exploring SAS Enterprise Guide

Chapter 12

Using SAS Information Map Studio

Overview of the SAS Information Map Studio

Using SAS Information Map Studio

Exercises

Chapter 13

Using SAS Web Report Studio

Overview of SAS Web Report Studio

Using SAS Web Report Studio

Exercises