SAS BI Online Training
SAS BI Online Training Course Content :
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