LiveZilla Live Help
India : +91 996 395 7366
USA : +1 214 347 4655
facebook twitter linkedin Google +

SAS BI

SAS BI Online Training

Business intelligence (BI) uses knowledge management, data integration, data mining and business analysis to identify, track and improve key processes and data, as well as identify and monitor trends in corporate, competitorand market performance.    

SAS supports business intelligence with the following:

  • a set of client applications
  • SAS server processes
  • a centralized metadata management facility

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