SAS Business Intelligence

SAS Business Intelligence

SAS Business Intelligence

  1. SAS Management Console
    1. Navigation in SAS Management Console
    2. SAS Open Metadata Architecture
    3. Introduction to Metadata * Centralized Metadata Management
    4. SAS Metadata Server
    5. Connecting to the Metadata Server
    6. Introduction and Working With Metadata Repositories
    7. Client / Server Interaction
    8. Create a Custom and Project Repository
    9. Setting up Change Management
    10. User Creation and Permissions
    11. Creating Libraries
    12. Creating connections with Data Bases and SAS Applications
    13. Creating Flows for Scheduling, Creating Jobs with dependencies and without dependencies.
    14. Brief Explanation about LSF and Process Managers
  2. 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. Introduction 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
  3. SAS/BI Studio Or ETL Studio
    1. Data ware housing Concept
    2. Exploring SAS Data Integration Studio
    3. Working on Change Management
    4. Explaining how to define source, target data structures and designing jobs.
    5. Introduction to jobs and the job editor
    6. Working with propagation and mappings
    7. Working with intermediate files
  4. Data Transformations
    1. Proc SQL
    2. Append
    3. Extract
    4. Validate
    5. Return Code Check
    6. Data Transfer
    7. Sort
    8. Rank
    9. Splitter
    10. Control Table
    11. User Written Code
    12. Create Transformation Template
    13. Transpose
    14. Data Access Transformations
    15. File Reader
    16. File Writer
    17. Table Loader
    18. Analysis Transformations
    19. Frequency Report
    20. One-Way Frequency Report
    21. Summary Report
    22. Tabulate Report
    23. Print Report
    24. Standardize
    25. List data
    1. SAS OLAP Cube Studio
      1. OLAP Introduction
      2. Discuss Dimensions / Facts / Hierarchies / Levels / Measures / Ragged Hierarchies / Aggregation
      3. Create an OLAP Cube from Detail Table (ROLAP)
      4. Create an OLAP Cube from Star Schema (ROLAP, HOLAP)
      5. Create an OLAP Cube from Summarized Table
      6. Review the Cube design and structure
      7. Exploring OLAP Cube with
        1. SAS Enterprise Guide
        2. SAS Information Map Studio
  • Microsoft Office Excel
  1. SAS Web Report Studio
  1. 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
  2. SAS Web Report Studio
    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
  3. 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
    15. SAS MICROSOFT ADD IN
    16. SAS BI Dashboards

 

No Comments

Post a Reply