SAS BI Online 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

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

• 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

• Introduction to the SAS® Enterprise Intelligence Platform
• SAS Business Intelligence Overview
• Business Intelligence Information Consumers
• Introduction to OLAP Cubes
• Introduction to Online Analytical Processing
• Overview of SAS OLAP Cube Studio
• Registering Metadata
• Exercises

• 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

• 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

• 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
• Overview of the SAS Business Intelligence Applications
• Introduction
• SAS BI Java Applications
• SAS BI Windows Applications
• SAS BI Web Browser Applications
• 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
• 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
• Using SAS OLAP Cube Studio
• Overview of SAS OLAP Cube Studio
• SAS OLAP Cube Studio Interface
• 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

• Using SAS Enterprise Guide
• Investigating the Features of SAS Enterprise Guide
• For Your Information v
• Exploring SAS Enterprise Guide
• Using SAS Information Map Studio
• Overview of the SAS Information Map Studio
• Using SAS Information Map Studio
• Exercises

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