SAS Business Intelligence Online Training Course Content

SAS Business Intelligence Online Training Course Content

SAS BI Course Content
Introduction to DWH / BI Concepts

  • SAS Web Report Studio 4.2
  • SAS EG 4.2
  • SAS Information Delivery Portal 4.2
  • SAS Data Integration Studio 4.2
  • SAS BI Dashboard 4.2
  • SAS Management Console 9.2
  • SAS Stored Process 4.2
  • SAS OLAP Cube Studio 4.2
  • SAS Stored Process Web Application 4.2
  • SAS Web OLAP Viewer for Java 4.2
  • Course Notes (Case Studies/ Exercises)
  • SAS Add-In for Ms Office 4.2
  • SAS Information Map Studio
  • LFS
  • Platform flow Manager PFM
  • SAS Web OLAP Viewer
  • SAS BI Dashboard 4.2

Chapter 1

  • Introduction
  • Overview
  • Audience

Chapter 2

  • Getting Started: The SAS Information Delivery Portal
  • Overview
  • Open the Portal and Log On
  • Create a Page and Add It to Your Navigation Bar
  • Add a SAS BI Dashboard Portlet to a Page

Chapter 3

  •  Working with Lists
  • Overview
  • Scroll Through a List
  • Delete One or More Items in a List
  • PART 2 Information for Dashboard Users 11

Chapter 4

  • Working in the SAS BI Dashboard Portlet
  • Select a Dashboard
  • Personalize a Dashboard
  • Personalize an Indicator
  • Create or Edit a Personal Indicator Alert
  • PART 3 Information for Dashboard Administrators 19

Chapter 5

  • Getting Started: Create a Dashboard
  • Create a Collection Portlet
  • Starting the SAS BI Dashboard from the SAS Information Delivery Portal
  • Creating a Dashboard
  • Create a Dashboard from Sample Data

Chapter 6

  • Data Models
  • Overview
  • Data Model Rules
  • Manage Data Models
  • Create or Edit a Data Model
  • Defining a Data Source

Chapter 7

  • Ranges
  • Manage Ranges
  • Create or Edit a Range

Chapter 8

  • Indicators
  • Overview
  • Manage Indicators
  • Create or Edit an Indicator
  • Indicator Displays
  • Indicator Alerts
  • Manage Dashboards
  • Create or Edit a Dashboard
  • Controlling the Appearance of a Dashboard
  • LSF
  • PFM

Data Warehousing Concepts (1week)

  • What is Data Warehousing
  • Why Use a Data Warehouse ?
  • Available Tools in the Market
  • Key Terms
  •  Architectural Concepts
  • Primary Components
  • What is ETL ?
  • Data Cleansing
  • Data Merging
  • Data Aggregation
  • Data Scrubbing
  • Historic Data
  • Current Data & Historical
  • Complete History
  • Limited/Unlimited Number of Histories
  • Load Types
  • First Time Load ( Initial Extraction )
  • Delta Load
  • Full Load
  • Incremental Loads
  • Schema Types
  • Star Schema
  • Snowflake Schema
  • Integrated Star Schema
  • Advantages of Each Schema
  • Dimensional Modeling Techniques
  • Conceptual Modeling
  • Logical Modeling
  • Physical Modeling
  • Named Input
  • Formatted Input
  • Data marts
  • Concept
  • Dependent vs Independent Data Mart
  • Enterprise Warehouse Schema
  • Implementation Methodology
  • Kimball Methodology
  • Inmon Methodology
  • Facts
  • Additive Facts
  • Semi Additive Facts
  • Non Additive Facts
  • Measures
  • Dimension Table Types
  • Slowly changing Dimensions
  • Type 1/2/3 Dimensions
  • Junk Dimensions
  • Confirmed Dimensions
  • Need of Time Dimension Comparison
  • Why is BI (Business Intelligence ) Required ?
  • OLTP
  • DSS
  • OLAP
  • Types of OLAP
  • ROLAP
  • MOLAP
  • HOLAP
  • DOLAP
  • DDE Triplet
  • Reporting Architecture
  • Database Layer
  • Interface Layer
  • Server Layer
  • Presentation layer
  • BI Server Systems
  • BI Client Systems and Functionalities
  • Hieracheis
  • Need of Hierarchies in Reporting
  • Need for ODS in Data Warehousing

SAS Enterprise Guide

  • Introduction on SAS EG Application.
  • Customizing SAS Enterprise Guide options
  • Setting up and managing profiles
  • Importing files from sources other than SAS
  • Accessing data via SAS libraries
  • Grouping and summarizing data
  • Gntroduction to querying data
  • Filtering and sorting data
  • Creating new columns with an expression
  • Joining tables
  • Grouping and summarizing data in a query (self-study)
  • Creating new columns by recoding values (self-study)
  • Creating a frequency report
  • Generating HTML, PDF, and RTF output
  • Creating a listing report
  • Creating a graph
  • Creating Stored Process from SAS EG.
  • Creating OLAP cubes from SAS EG.
  • Working on different STATASTICAL Procedures

SAS/DI STUDIO 4.2 (Data Integration Studio)

  • Exploring SAS Data Integration Studio
  • Working on Change Management
  • Explaining how to define source, target data structures and designing jobs.
  • Introduction to jobs and the job editor
  • Working with propagation and mappings
  • Working with intermediate files
  • Working with the extract transformation
  • Working with summary statistics transformation
  • Explore status handling for transformations and jobs
  • Working with the data validation transformation
  • Working with the sort transformation
  • Working with the append transformation
  • Working with the transpose transformation
  • Working with the apply lookup standardization transformation
  • Iterating a job with Loop transformations
  • Basics of the Table Loader transformation
  • Load styles of the Table Loader transformation
  • Table properties and load techniques of the Table Loader transformation
  • Introduction to change management and establishing a change management environment.
  • Defining slowly changing dimensions
  • Using the SCD type 2 Loader and Change Data capture transformations (Pre & Post Process).
  • Analyzing metadata using impact analysis
  • Deploying jobs for scheduling.
  • Deploying jobs as Stored Process.
  • Exporting and importing metadata
  • Building an OLAP cube
  • Building an information map
  • Building the dimensions
  • Building the fact tables.
  • Creating and Exploiting OLAP Using the SAS System

SAS OLAP Cube Studio 4.2

  • Introduction to Online Analytical Processing
  • Overview of SAS OLAP Cube Studio
  • Registering metadata
  • Working with SAS OLAP Cubes Derived from Detail Tables
  • Creating a SAS OLAP Cube from a detail table
  • Generating aggregations using cross- dimensional tuning
  • Setting permissions using SAS Management Console
  • Viewing a SAS OLAP cube with SAS Enterprise Guide
  • Working with SAS OLAP Cubes Derived from Star Sachems
  • Creating a SAS OLAP cube from a star schema
  • Viewing a SAS OLAP cube with SAS Web OLAP Viewer for JAVA
  • Monitoring and Tuning a SAS OLAP Cube

SAS Web Report Studio 4.2

  • Introduction on SAS Web Report Studio
  • Calling Information Maps into WRS.
  • Creating filters at WRS
  • Creating Layouts for Reports.
  • Creating Prompts.
  • Customizable roles to authorize capabilities(From SMC)
  • Working on Report Creation and Templates.

SAS Information Delivery Portal

  • Introduction to SAS IDP
  • Adding a Portal page
  • Adding Contents to Portlet.
  • Adding portlets to page.
  • Utilize SAS EG to create content and publish packages to the framework
  • Viewing and managing portal content.
  • Portal Customization
  • Call Reports from WRS to IDP.
  • User level Authentication.
  • Designing Portal
  • Creating Dashboards.
  • Calling STP into IDP.
  • Cubes in PORTAL/
  • Sharing portal content.

SAS Information Map Studio ;

  • Introduction to SAS information Map Studio.
  • updating an information map with filters, folders, and data items
  • Adding additional data sources to an information map
  • Overview of information map pre-filters
  • Building a general pre-filter
  • Building an authorization-based pre-filter
  • Information Maps and Stored Process.
  • Overview of stored processes
  • Associating stored processes with an information map
  • Using information maps in SAS Web Report Studio
  • Overview of surfacing data with information maps
  • Using information maps in the SAS Information Delivery Portal
  • Using information maps in SAS Enterprise Guide
  • Using information maps in the SAS Add-In For Microsoft Office
  • Overview of OLAP cubes
  • Building an information map for an OLAP cube

SAS Management Console 9.2

  • User Creation and Permissions
  • Creating Libraries
  • Creating connections with Data Bases and SAS Applications
  • Creating Repository and creating Folders levels at Repository
  • Checking (TEST) connections for Different SAS Servers.
  • Creating Flows For Scheduling ,Creating Jobs with dependencies and without Dependencies.
  • Migration from Test Servers to Production servers.
  • What is Metadata Tree and its Uses.
  • Configuring Different Servers @SAS Management Console.
  • Explain The Structure at SERVER LEVEL and SMC LEVEL(like Where the log files, Config Files,

Batch Files, executable files are stored For running different servers successfully.)

  • Brief Explanation about LSF and Process Managers
  • Brief Explanation about WEB Servers like the purpose of XYTHOS ,TOMCAT,Websphere.
  • START and STOP Servers, Take Backups….

Register today to attend Free Instructor Led Online Demo 

Share this post