SAS BI Online Training

SAS BI Online Training


    SAS BI Course Content

    1.Data Integration Studio

    • Using SAS Data Integration Studio
    • SAS Data Integration Studio Overview
    • The SAS Data Integration Studio Interface
    • Adding Library Definitions
    • Using the Source Designer
    • Using the Target Designer
    • Using the Process Designer
    • Exercises
    • Explain and work on the Extract and Summary Statistics transformation.
    • Explain and work on the Loop transformations.
    • Investigate where status handling is available.
    • Explain and work on the Data Validation transformation.
    • Explain and work on the Rank, Transpose, Append, List and Sort transformations.
    • Explain and work on the Apply Lookup Standardization transformation.
    • Define the Concept of a Checkpoint.
    • Describe features of the New Tables wizard.
    • Explain SAS packages.
    • Explain importing and exporting of relational metadata.
    • Explain components of SQL Join’s Designer window.
    • Investigate mapping and propagation.
    • Work with performance statistics.
    • Generate reports on metadata for tables and jobs.
    • Define Impact and Reverse Impact Analysis.
    • Explain reasons to use the Table Loader transformation.
    • Explain various load styles provided by the Table Loader transformation.
    • Explain various types of keys and how to define in SAS Data Integration Studio.
    • Explain indexes and how to define in SAS Data Integration Studio.
    • Explain Table Loader options for keys and indexes.
    • List the functions of the SCD Type 2 transformation.
    • Work on business keys, surrogate and retained keys.
    • Detect and track changes.
    • Explain the Lookup transformation
    • Explain the types of job deployment available for SAS Data Integration Studio Jobs.
    • Provide an overview of the scheduling process.
    • Explain the types of scheduling servers.
    • Explain the Schedule Manager in SAS Management Console.
    • List the applications that can be used to create and execute stored processes.
    • Describe deployment of SAS Data Integration Studio jobs as a SAS Stored Process.
    • Import SAS code.

    2.Management Console

    • Overview of the SAS Management Console
    • Introduction to the SAS Management Console
    • How the SAS Management Console Works
    • Introduction to the SAS Management Console Plug-Ins
    • Working with the User Interface

    3.Business User Reporting Applications

    • Use the SAS Add-In for Microsoft Office.
    • Use SAS Web Report Studio.
    • Use SAS Information Delivery Portal.

    4.Advanced Reporting Techniques and Roles

    • Modify an existing SAS Information Map.
    • Create a New SAS BI Dashboard Indicator.
    • Create data sources for reporting and analysis.
    • Interpret permissions and file structures defined in metadata by the platform administrator.

    5.Creating Information Maps

    • Utilize different data sources.
    • Use filters and the prompting framework to dynamically subset data.
    • Create profilers to subset the information map data.

    6.Building a SAS BI Dashboard Application

    • Build SAS BI Dashboard Components.
    • Build advanced SAS BI Dashboard Components.

    7.Building Stored Processes

    • Create a stored process from a SAS Enterprise Guide Project.
    • Create a stored process from a SAS Program.
    • Add prompts to a stored process.
    • Create a stored process to provide a dynamic data source.
    • Define the macro variables generated for each prompt type.7

    8.Utilizing Advanced Techniques with SAS Reports

    • Build advanced reports with SAS Web Report Studio.
    • Create and use SAS report templates.
    • Link reports in SAS Web Report Studio.
    • Schedule and distributing SAS Reports.
    • Build SAS reports with SAS Enterprise Guide.
    • Create shared prompts.

    9.Utilizing Multidimensional (OLAP) Data Sources

    • Apply Online Analytical Processing concepts.
    • Build an OLAP cube with SAS OLAP Cube Studio.
    • Build an information map from a SAS OLAP Cube.
    • Working with SAS OLAP Cubes Derived from Star Schemas
    • Creating an OLAP Cube from a Star Schema

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 month, 1 week

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies


    This web site or team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information


    +91 9989754807