Oracle BI 11g "Advanced" RPD Modelling

This training provides BI Developers and Architects with essential knowledge on the advanced concepts and key fundamentals behind the Oracle BI Server and BI Repository (RPD).

With no fewer than 21 realistic “hands-on” lab sessions, Delegates will receive significant first-hand experience with sophisticated Modelling techniques enabling them to model complex data structures (including Star-Schema, Flat Structures, 3NF, Essbase Cubes, Oracle OLAP cubes, Ragged / Unbalanced Hierarchies).

Oracle BI 11g "Advanced" RPD Modelling
4 Days
Instructor led with hands on exercises

Private Training available on-demand

BI Developers and Architects
Up to 15 Delegates per training


Day 1

  • Modelling Overview and Concepts
  • Modelling a Flat Structure
  • Modelling a Star-Schema
  • Slowly Changing Dimensions (SCD)
  • Dimension Hierarchies
  • Physical Calculations
  • Aggregation
  • Denormalization
  • Conforming Dimensions

Day 2

  • Simple Subject Areas
  • Logical Calculations
    • Time Series Calculations
    • Level Based Measures
    • Logical vs Physical
  • Variables
  • Security
    • Authentication
    • Authorization
    • Data Filters
  • Modelling Third-Normal-Form (3NF)
    • Handling Snow-Flakes
    • Overcoming Physical Complexity
    • Optimising 3NF Queries

Day 3

  • Lookup Functions
  • Double Columns
  • Hierarchical Columns
    • Ragged, Skipped Level
    • Parent-Child
  • Outer Joins
  • Cross-Database Joins
  • Non-Conformed Dimensions
  • Fragmentation
  • Write Back

Day 4

  • Oracle Essbase
  • Oracle OLAP
  • Query Federation
  • BI Server Caching
  • Usage Tracking
  • Aggregate Persistence
  • Generating RPD Metadata
  • 20 Golden Rules for RPD Design

Want to take Oracle BI 11g ‘Advanced RPD Modelling’ training? Enquire Now!