toggle menu

SAS BI Online Training in USA

  1. Velocity Infosystems ›
  2. SAS BI Online Training

SAS BI Online Training Course Content :

SAS BI Online Training
                                                                            SAS BI Online Training

SAS DI (DATA INTEGRATION)

Introduction to the platform for SAS Business Analytics and SAS Data Integration Studio

  • exploring the platform for SAS Business Analytics
  • working with SAS Data Integration Studio
  • Introduction to change management

Introduction to Course Data and Course Scenario

  • explaining the course data
  • explaining how to define target data
  • Introduction to the course scenario

Creating Metadata for Source Data

  • setting up the environment
  • registering source data

Creating Metadata for Target Tables

  • registering target tables
  • importing metadata

Creating Metadata for Jobs

  • creating jobs
  • exploring functionality of Job Editor
  • submitting jobs to create target tables
  • specify how to document jobs
  • recording job performance statistics
  • chaining job flows

Working with Transformations

  • working with the extract transformation
  • working with the data validation transformation
  • working with the apply lookup standardization transformation
  • working with the sort transformation
  • working with all different transformations
  • working with status handling

Defining Table Relationships

  • reviewing the data model
  • defining integrity constraints
  • defining keys and indexes
  • exploring various load techniques

Working with Slowly Changing Dimensions

  • defining slowly changing dimensions
  • working with SCD Type 2 loader transformation
  • working with the lookup transformation

Working with Transformations

  • working with the transformation generator wizard

Deploying Jobs

  • specify how to deploy jobs for batch scheduling
  • specify how to deploy jobs as stored processes
  • specify how to deploy jobs for web services

Maintaining and Administering SAS Data Integration Studio

  • Establishing project repositories for change management
  • working with impact analysis
  • moving metadata
  • enabling status handling
  • setting up the SAS Data Quality Server software

SAS BI (BUSINESS INTELLIGENCE)

Introduction to the platform for SAS Business Analytic s and SAS Data Integration Studio

  • exploring the platform for SAS Business Analytic
  • working with SAS Data Integration Studio
  • introduction to change management introducing the course environment and scenario

Introducing the Business User Reporting Applications

  • defining the business user role and reporting applications
  • exploring the SAS Add-In for Microsoft Office
  • exploring SAS Web Report Studio
  • exploring the SAS Information Delivery Portal
  • defining the interaction between the business user and the business analyst

Introducing Advanced Reporting Techniques and Roles

  • defining the business analyst role and applications
  • modifying an existing information map
  • creating a new SAS BI Dashboard indicator
  • creating data sources for reporting and analysis
  • defining the interaction between the business analyst and the platform administrator
  • understanding SAS Data Integration capabilities

Creating an Information Map

  • understanding SAS information maps
  • utilizing different data sources
  • exploiting dynamic subsetting of data
  • creating prefilters to subset the information map

Building a SAS BI Dashboard Application

  • understanding SAS BI Dashboard
  • building the SAS BI Dashboard components
  • building advanced SAS BI Dashboard components

Building Stored Processes

  • understanding SAS Stored Process concepts
  • creating a stored process from a SAS Enterprise Guide project
  • creating a stored process from a SAS program
  • creating stored process parameters
  • creating a stored process to provide a dynamic data source

Utilizing Advanced Techniques with SAS Reports

  • building advanced reports with SAS Web Report Studio
  • creating and using SAS report templates
  • linking reports in SAS Web Report Studio
  • scheduling and distributing SAS Reports
  • building SAS Reports with SAS Enterprise Guide
  • creating shared prompts

Consolidating Information into a Business Reporting Application

  • creating the business reporting application

Introducing Multidimensional Data Sources

  • understanding online analytical processing concepts
  • building an OLAP cube with SAS OLAP Cube Studio
  • building an information map from a SAS OLAP cube

Drop your query

Most Popular Courses

Achieve your career goal with industry recognised learning paths

What my Client's Say?

 

  • It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand

  • All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin

  • It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla

  • Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig

  • Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala

  • It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar

  • The course was really good because it was a practical course.~ M.Radha patel

  • I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria

Request a Call Back