a)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
Deployinging 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
b)SAS BI (BUSINESS INTELLIGENCE)
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 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 Techiques 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