SAS BI

SAS BI ONLINE TRAINING

 

Course Description:

SAS Enterprise BI is a comprehensive, easy-to-use business intelligence software solution that integrates the power of SAS Analytics and SAS Data Management to provide insights that power better decisions. It includes role-based, self-service interfaces for all types of users within a well-defined IT governance framework and a centralized point of administration. This helps organizations simplify and speed business intelligence deployment.

 

SAS BI ONLINE TRAINING Course Content

–          Introduction to DWH / BI Concepts

–          SAS Web Report Studio 4.3

–          SAS EG 6.1

–          SAS Information Delivery Portal 4.3

–          SAS Data Integration Studio 4.3

–          SAS BI Dashboard 4.3

–          SAS Management Console 9.3

–          SAS Stored Process 4.3

–          SAS OLAP Cube Studio 4.3

–          SAS Stored Process Web Application 4.3

–          Course Notes (Case Studies/ Exercises)

–          SAS Add-In for Ms Office 4.3

–          SAS Information Map Studio 4.3

–          LFS

–          Platform flow Manager PFM

Data Warehousing Concepts

  1. What is Data Warehousing
  2. Why Use a Data Warehouse ?
  3. Available Tools in the Market
  4. Key Terms
  5. Architectural Concepts
  6. Primary Components
  7. What is ETL ?
  8. Data Cleansing
  9. Data Merging
  10. Data Aggregation
  11. Data Scrubbing
  12. Historic Data
  13. Current Data & Historical
  14. Complete History
  15. Limited/Unlimited Number of Histories
  16. Load Types
  17. First Time Load ( Initial Extraction )
  18. Delta Load
  19. Full Load
  20. Incremental Loads
  21. Schema Types
  22. Star Schema
  23. Snowflake Schema
  24. Integrated Star Schema
  25. Advantages of Each Schema
  26. Dimensional Modeling Techniques
  27. Conceptual Modeling
  28. Logical Modeling
  29. Physical Modeling
  30. Named Input
  31. Formatted Input
  32. Data marts
  33. Concept
  34. Dependent vs Independent Data Mart
  35. Enterprise Warehouse Schema
  36. Implementation Methodology
  37. Kimball Methodology
  38. Inmon Methodology
  39. Facts
  40. Additive Facts
  41. Semi Additive Facts
  42. Non Additive Facts
  43. Measures
  44. Dimension Table Types
  45. Slowly changing Dimensions
  46. Type 1/2/3 Dimensions
  47. Junk Dimensions
  48. Confirmed Dimensions
  49. Need of Time Dimension Comparison
  50.  Why is BI (Business Intelligence ) Required ?
  51. OLTP
  52. DSS
  53. OLAP
  54. Types of OLAP
  55. ROLAP
  56. MOLAP
  57. HOLAP
  58. DOLAP
  59. DDE Triplet
  60. Reporting Architecture
  61. Database Layer
  62. Interface Layer
  63. Server Layer
  64. Presentation layer
  65. BI Server Systems
  66. BI Client Systems and Functionalities
  67. Hieracheis
  68. Need of Hierarchies in Reporting
  69. Need for ODS in Data Warehousing

SAS DI STUDIO 4.3 (SAS Data Integration Studio)

  1. Exploring SAS Data Integration Studio
  2. Working on Change Management
  3. Explaining how to define source, target data structures and designing jobs.
  4. Introduction to jobs and the job editor
  5. Working with propagation and mappings
  6. Working with intermediate files
  7. Working with the extract transformation
  8. Working with summary statistics transformation
  9. Explore status handling for transformations and jobs
  10. Working with the data validation transformation
  11. Working with the sort transformation
  12. Working with the append transformation
  13. Working with the transpose transformation
  14. Working with the apply lookup standardization transformation
  15. Iterating a job with Loop transformations
  16. Basics of the Table Loader transformation
  17. Load styles of the Table Loader transformation
  18. Table properties and load techniques of the Table Loader transformation
  19. Introduction to change management and establishing a change management environment.
  20. Defining slowly changing dimensions
  21. Using the SCD type 2 Loader and Change Data capture transformations (Pre & Post Process).
  22. Analyzing metadata using impact analysis
  23. Deploying jobs for scheduling.
  24. Deploying jobs as Stored Process.
  25. Exporting and importing metadata
  26. Building an OLAP cube
  27. Building an information map
  28. Building the dimensions
  29. Building the fact tables.
  30. Creating and Exploiting OLAP Using the SAS System

SAS OLAP Cube Studio 4.3

  1. Introduction to Online Analytical Processing
  2. Overview of SAS OLAP Cube Studio
  3. Registering metadata
  4. Working with SAS OLAP Cubes Derived from Detail Tables
  5. Creating a SAS OLAP Cube from a detail table
  6. Generating aggregations using cross- dimensional tuning
  7. Setting permissions using SAS Management Console
  8. Viewing a SAS OLAP cube with SAS Enterprise Guide
  9. Working with SAS OLAP Cubes Derived from Star Sachems
  10. Creating a SAS OLAP cube from a star schema
  11. Viewing a SAS OLAP cube with SAS Web OLAP Viewer for JAVA
  12. Monitoring and Tuning a SAS OLAP Cube

SAS Information Map Studio 

  1. Introduction to SAS information Map Studio.
  2. updating an information map with filters, folders, and data items
  3. Adding additional data sources to an information map
  4. Overview of information map pre-filters
  5. Building a general pre-filter
  6. Building an authorization-based pre-filter
  7. Information Maps and Stored Process.
  8. Overview of stored processes
  9. Associating stored processes with an information map
  10. Using information maps in SAS Web Report Studio
  11. Overview of surfacing data with information maps
  12. Using information maps in the SAS Information Delivery Portal
  13. Using information maps in SAS Enterprise Guide
  14. Using information maps in the SAS Add-In For Microsoft Office
  15. Overview of OLAP cubes
  16. Building an information map for an OLAP cube

SAS Enterprise Guide

  1. Introduction on SAS EG Application.
  2. Customizing SAS Enterprise Guide options
  3. Setting up and managing profiles
  4. Importing files from sources other than SAS
  5. Accessing data via SAS libraries
  6. Grouping and summarizing data
  7. Gntroduction to querying data
  8. Filtering and sorting data
  9. Creating new columns with an expression
  10. Joining tables
  11. Grouping and summarizing data in a query (self-study)
  12. Creating new columns by recoding values (self-study)
  13. Creating a frequency report
  14. Generating HTML, PDF, and RTF output
  15. Creating a listing report
  16. Creating a graph
  17. Creating Stored Process from SAS EG.
  18. Creating OLAP cubes from SAS EG.
  19. Working on different STATASTICAL Procedures

SAS Web Report Studio 4.3

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

SAS Information Delivery Portal 

  1. Introduction to SAS IDP
  2. Adding a Portal page
  3. Adding Contents to Portlet.
  4. Adding portlets to page.
  5. Utilize SAS EG to create content and publish packages to the framework
  6. Viewing and managing portal content.
  7. Portal Customization
  8. Call Reports from WRS to IDP.
  9. User level Authentication.
  10. Designing Portal
  11. Creating Dashboards.
  12. Calling STP into IDP.
  13. Cubes in PORTAL/
  14. Sharing portal content.

SAS Management Console 9.3

  1. User Creation and Permissions
  2. Creating Libraries
  3. Creating connections with Data Bases and SAS Applications
  4. Creating Repository and creating Folders  levels at Repository
  5. Checking (TEST) connections for Different SAS Servers.
  6. Creating Flows For Scheduling ,Creating Jobs with dependencies and without Dependencies.
  7. Migration from Test Servers to Production servers.
  8. What is Metadata Tree and its Uses.
  9. Configuring Different Servers @SAS Management Console.
  10. 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.)
  11. Brief Explanation about LSF and Process Managers
  12. Brief Explanation about WEB Servers like the purpose of XYTHOS ,TOMCAT,Websphere.
  13. START and STOP Servers, Take Backups….

SAS Information Delivery Portal

  1. Overview
  2. Open the Portal and Log On
  3. Create a Page and Add It to Your Navigation Bar
  4. Add a SAS BI Dashboard Portlet to a Page
  5. Working with Lists
  6. Scroll Through a List
  7. Delete One or More Items in a List
  8. Working in the SAS BI Dashboard Portlet
  9. Select a Dashboard
  10. Personalize a Dashboard
  11. Personalize an Indicator
  12. Create or Edit a Personal Indicator Alert
  13. Create a Collection Portlet
  14. Starting the SAS BI Dashboard from the SAS Information Delivery Portal

SAS BI Dashboard 4.3

  1. Create a Dashboard from Sample Data
  2.  Data Models
  3. Data Model Rules
  4. Manage Data Models
  5. Create or Edit a Data Model
  6. Defining a Data Source
  7. Ranges
  8. Manage Ranges
  9. Create or Edit a Range
  10. Manage Indicators
  11. Create or Edit an Indicator
  12. Indicator Displays
  13. Indicator Alerts
  14. Manage Dashboards
  15. Create or Edit a Dashboard
  16. Controlling the Appearance of a Dashboard

LSF (Load Sharing Facility Scheduler)/PFM 

  1. Create flows
  2. Deploy jobs to flows
  3. Schedule flows

SAS STORED PROCESS WEB APLLICATION

  1. Open stored proceses
  2. Execute stored processes
  3. Generate reports

SAS ADDIN MS OFFICE

  1. Open datasets,OLAP Cubes,Information Maps from MS Office Tools
  2. Generate reports
  3. Analyze Metadata objects

 Prerequisites: 

Nothing is needed but SAS/base knowledge would added advantage.

 Related Course:

                  SAS Platform Administration

Career Path:

SAS BI developer/SAS BI content developer/SAS BI aalyst is a leading and demanding skill-sets in IT as well highly paid jobs since the role need to be handling the backbone of organization’s vital data management at large scale.

 

 SAS BI ONLINE TRAINING DURATION: 22-24 hrs

 

SAS BI ONLINE Training demo