+1-646-597-8346     +91-7396-388-592     Info@araniconsulting.com                
Arani Consulting

SAS BI ( Business Intelligence ) Online Training | SAS BI ( Business Intelligence )  Training

 
Overview of SAS 9 Enterprise Intelligence Platform and SAS Data Integration Studio
  • Business Intelligence overview
  • Business Intelligence Information Consumerscourse content
  • Navigating in SAS Data Integration Studio
Change Management
  • What is change management?
  • Repository types
  • Using change management
Designing the Course Data Mart
  • Planning a data warehouse
  • Building a Data Mart
  • Defining the source data
  • Defining the target tables
  • Loading the target tables
Creating Reports
  • Report Transformations
  • Using the Transformation Generator Wizard
  • SAS Data Integration Studio and stored -processes Transformations for Slowly Changing Dimensions
  • 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
  • Using the Data Validation transformation
  • Using the Apply Lookup Standardization transformation
  • Using the Create Match Code transformation

SAS/Enterprise Guide

Introduction
  • Starting SAS Enterprise Guide
  • SAS Enterprise Guide windows
  • Basic elements of SAS Enterprise Guide
  • Entering data
  • Creating a list report
  • Producing a frequency report
  • Creating a scatter plot
  • Adding a note to the project
  • Saving the project
Reading Data from Files
  • Opening a SAS data set from your local computer
  • Opening a SAS data set stored in a SAS library
  • Opening a Microsoft Excel file
Creating Reports
  • Creating a simple report
  • Changing titles and footnotes
  • Changing column labels and formatting values
  • Defining your own formats
  • Creating a grouped report
  • Selecting a style for the report
Working with Data in the Query Builder
  • Opening the Query Builder
  • Selecting columns
  • Creating a new column
  • Ordering and removing columns
  • Filtering data
  • Sorting the data rows
Joining Two Data Files Together
  • Opening the two data files to be joined
  • Joining tables
  • Filtering the data
  • Modifying the type of join
  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube

Popular Posts

Online Training

Live virtual Online Training: Through a combination of new and existing ...

On Demand Training

At Arani Consulting we provide the training needs of our ...

Project Support

As a leading online Training services institute, we specialize in ...

Corporate Training

Right skill set and quickly adapting to the new technologies ...