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
    Contact Us

    +1 475-212-0075

    Drop us a query

      Your Details

      * Required

      Job Support

        Your Details

        * Required

        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