SAS BI Online Training in USA

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

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim