Oracle - Course Details

OraD11g:OLAPE Oracle Database 11g: OLAP Essentials

Oracle Course Description:
In this course, students learn to progressively build an OLAP data model to support a wide range of business intelligence requirements. Students learn to design OLAP cubes to serve as a summary management resource for existing SQL table queries. Students also learn to leverage the power of Oracle OLAP by adding rich analytic content to your data model.
Oracle Course Duration:
3 DAYS
Oracle Course Target Audience:
Business Analysts,Business Intelligence Developer,Data Warehouse Administrator,Data Warehouse Analyst,Data Warehouse Developer,Database Administrators
Oracle Course Prerequisite:
Basic SQL knowledge,A basic understanding of OLAP concepts
Course Content:
  • Examining the Role of Oracle OLAP within the Oracle BI / DW Platform

    • Oracle OLAP and the Oracle BI / DW Platform
    • Features of the Oracle OLAP Option
    • Accessing Oracle 11g OLAP data

  • Understanding the Dimensional Model

    • Stored and Calculated Measures
    • Dimensions
    • Hierarchies
    • Levels
    • Attributes

  • Building OLAP Cubes

    • Using the Cube Building Tool
    • Creating Dimensions
    • Designing Cubes
    • Creating Measures
    • Mapping to Source Data
    • Loading Data

  • Examining Cube-Organized Materialized Views (Cube MVs)

    • Benefits of Cube MV Summary Management
    • General Requirements for rewrite to MVs
    • Designing Cube MVs
    • Using Cube MVs

  • Creating Calculated Measures

    • Examining OLAP Calculation Types
    • Using the Calculation Builder
    • Creating Common Business Calculations
    • Creating Custom Calculations

  • Using SQL to Query Oracle OLAP Cubes

    • Understanding Cube Views
    • Querying OLAP Cubes: The Basics
    • Leveraging Cube Summaries
    • Applying Query Filters
    • Joining OLAP and Relational Data

  • Enhancing Analytic Content

    • Creating Cubes with Varying Dimensionality
    • Integrating Measures from Data with Different Dimensionality
    • Creating Forecast Measures Using OLAP DML

  • Using Ad Hoc Query and Reporting Tools Against OLAP Data

    • Exploring OLAP Data Using Oracle Application Express (APEX)
    • Performing Ad Hoc Query of OLAP Data Using Oracle BI Answers
    • Examining Metadata Requirements for BI Tools

  • Implementing Cube Security

    • Understanding Authentication Requirements
    • Authorizing Access to Cube Data
    • Examining User and Object Privileges
    • Examining Methods for Scoping User Views of Data

  • Designing Cubes for Performance and Scalability

    • Objectives of Performant and Scalable Design
    • Examining how Data is Stored in Oracle Cubes
    • Identifying Cube Features that Impact Performance and Scalability
    • Implementing Design Techniques for Performance and Scalability

  • Examining Performance Tuning

    • Describing How Cubes are Stored
    • Understand Cube Build Processing
    • Examining Balanced Configurations
    • Correcting Performance Bottlenecks