SAS Business Intelligence course for Intermediate trainees by STAR IT TECHNOLOGIES

SAS BI COURSE CONTENT Course:
SAS BI(business intelligence) and DI(Data integration)training -
.
Course Content / Topics:
1. SAS Data Integration Studio (ETL),
2. SAS Management Console,
3. SAS Information Delivery Portal
4. SAS Web Report building
5. SAS OLAP cube Studio
6. SAS OLAP Cube Viewer
7. SAS Enterprise Guide
8. SAS Dashboard
9. SAS Add in In for Microsoft Office
10. SAS Information Map Studio
11. SAS Stored Process

Course Content:

Data Integration Studio

Using SAS Data Integration Studio
SAS Data Integration Studio Overview

SAS BI COURSE CONTENT

The SAS Data Integration Studio Interface
Adding Library Definitions
Using the Source Designer
Using the Target Designer
Using the Process Designer
Explain and work on the Extract and Summary Statistics transformation.
Explain and work on the Loop transformations
SAS BI COURSE CONTENT

Work on business keys, surrogate and retained keys.
Detect and track changes.
Explain the Lookup transformation
Explain the types of job deployment available for SAS Data Integration Studio Jobs.
Provide an overview of the scheduling process
Explain the types of scheduling servers.
Explain the Schedule Manager in SAS Management Console.
List the applications that can be used to create and execute stored processes.