SAS Business Intelligence course for Novice by Elegant IT Services

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 process

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
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 SAS9 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