The following course and knowledge testing topics can be mixed and matched in any practical combination to suit your needs. Try out the Course Designer or Test Designer wizards to give it a go yourself. Save what you put together without obligation and get a quote and book whenever you like.

  • SAS® OLAP - Essentials

    • Required SAS 9.2 components
    • How SAS components interact to generate and view OLAP data
    • OLAP terminology and the interaction of OLAP components.

    Approximately delivery time: 1 hours

  • OLAP Design - Data and Dependency

    Consideration to the source of your OLAP data plays an important role in data access, updates and maintainability.

    • OLAP cube design, maintenance and data dependency considerations
    • Data dependent factors (update frequency, ragged heirarchies, static data hierachies)
    • Performance considerations
    • Planning for data updates

    Approximately delivery time: 1 hours

  • OLAP Design Requirements Gathering

    Effectively communicating and documenting the business analysis for your OLAP cube, will make it much easier to design and build without any guesswork. Using our OLAP design template, we will walk through practical examples to demonstrate how useful this technique can be.

    • Business analysis considerations and required information for planning an OLAP solution.
    • OLAP cube design, maintenance and data dependency considerations
    • Using the YourTeamPlayer design template to define requirements and document functional specifications.

    Approximately delivery time: 1 hours

  • SAS® OLAP Cube Studio - Building a basic cube

    • Exploring the SAS OLAP Cube Studio application and functionality
    • Step through the Cube Designer Wizard to see how the information is used to build the OLAP structure
    • Registering sample table metadata and creating a sample cube using the cube designer wizard
    • Explore the interactive capabilities of the registered cube via SAS OLAP Cube Studio and SAS Enterprise Guide

    Approximately delivery time: 3 hours

    Pre-requisite Topics

    OLAP - Online Analytical Processing
    SAS® OLAP - Essentials
    OLAP Design Requirements Gathering
  • SAS® OLAP Cube Studio - Using different data sources

    • Creating cubes from a single data source, a star schema and a summarised table structure (proc summary output).

    Approximately delivery time: 2 hours

    Pre-requisite Topics

    OLAP - Online Analytical Processing
    SAS® OLAP Cube Studio - Building a basic cube
  • SAS® OLAP Cube Studio - Performance tuning methods

    • How to gain better performance from your OLAP cube,
    • Manual and usage based performance tuning of your OLAP cube
    • Applying appropriate aggregations to your cube

    Approximately delivery time: 2 hours

    Pre-requisite Topics

    OLAP - Online Analytical Processing
    SAS® OLAP Cube Studio - Using different data sources
  • OLAP MDX Basics

    • The basics of the MDX (Multi Dimensional Expression) query language 
    • Code syntax, use of Touples defining ranges of values.
    • Using generated MDX from SAS Enterprise Guide to add calculations and additional functionality to the metadata of an existing cube or just a single view of that cube.

    Approximately delivery time: 1 hours

    Pre-requisite Topics

    OLAP - Online Analytical Processing
    SAS® OLAP - Essentials
  • SAS® OLAP Cubes as a data source for SAS Information Maps

    Using an OLAP cube as a data source in SAS Information Map Studio to creat an information map that can be used in SAS Web Report Studio to provide dynamic drill down functionality in your web reports.

    NOTE: SAS Information Map Studio and SAS Web Report Studio are just used to demonstrate the capability here. To learn more about these topics, we suggest choosing some topics from these subject areas.

    Approximately delivery time: 1 hours

  • SAS OLAP Updating Static and Dynamic dimensions in SAS 9.2

    • Discussion of your options with regard to updating your cubes online or offline.
    • Definition of static and dynamic dimensions in SAS OLAP Cubes
    • Design, maintenance, performance and data drill through considerations 
    • Follow through a case study example of how to set up and execute dynamic updates using sample data.

    Approximately delivery time: 3 hours

YourTeamPlayer onsite SAS® Software Training

Entirely customised SAS® Software education

All courses are at YOUR site
All courses use YOUR DATA
All use YOUR computing environment
Only YOUR staff in attendance
Only dealing with YOUR data issues