SAS BI

SAS

BI

Why SAS BI Online Training Only with Virtuous trainers?

Virtuous Trainers offers SAS BI Online and Corporate trainings that are tailor made as per the requirements of an entity or an individual. With industry's best trainers anyone who joins our institute will be assured of 100% quality training with real time scenarios and live projects(most technologies) and assignments. Apart from the course content of the respective technologies our curriculum includes resume building, interview tips, global certification guidance and many more facilities which help an individual prepare to further their careers.

What is Business Intelligence?

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, competitor and market performance.

SAS supports business intelligence with the following:

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

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 SAS®9 Enterprise Intelligence Platform and SAS® Data Integration Studio 1-1

  • What Is Business Intelligence?
  • Navigating in SAS Data Integration Studio
  • 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(SELF STUDY)

  • SAS and Data Quality
  • Data Validation Transformation
  • Apply Lookup Standardization Transformation (Self-Study)
  • Create Match Code Transformation (Self-Study)
  • 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
  • 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

To Enroll for a free demo kindly Contact
Mobile : +91 8790035436
EMail ID : enquiry@virtuoustrainers.com
Skype ID : virtuoustrainers