SAS Business Intelligence Syllabus (A00-270)

Required Exam

Candidates who earn this credential will have earned a passing score on the SAS BI Content Development for SAS 9 exam. This exam is based on SAS 9.2/9.3 using the 4.3 version of the BI clients and is administered by SAS and Pearson VUE.

    64 multiple-choice questions (must achieve score of 70% correct to pass)
    2 hours to complete exam
    Use exam ID A00-270; required when registering with Pearson VUE.
    This exam is based on SAS 9.2/9.3 using the 4.3 version of the BI clients. Exam topics include:

Business User Reporting Applications:

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

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.

Creating Information Maps:

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

Building a SAS BI Dashboard Application:

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

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.

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.

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.

The Environment Metadata:

    Describe the metadata created and used by the SAS Platform.