LiveZilla Live Help
India : +91 996 395 7366
USA : +1 214 347 4655

SAS BI

SAS BI Online Training

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

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