Oracle BI 12c "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 new demonstrations of functionality and no fewer than 23 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).

Course:
Oracle BI 12c "Advanced" RPD Modelling
Duration:
3 Days
Delivery:
Instructor led with hands on exercises
Events:

Private Training available on-demand

Attendees:
BI Developers and Architects
Numbers:
Up to 15 Delegates per training

Agenda:

Agenda:

Day 1

 

  • Overview and Welcome
  • The Physical Layer
  • Logical Fact Tables
  • Logical Dimension Tables
  • Dimension Hierarchies
  • The Presentation Layer
  • Physical Calculations
  • Logical Calculations

 

Day 2

 

  • Variables
  • Security
  • Snow-Flakes
  • Hierarchical Columns
  • Aggregation
  • Denormalisation
  • Conformed Dimensions
  • Non-Conformed Dimensions

 

Day 3

 

  • Cross Database Joins
  • Outer-Joins
  • Parent-Child Hierarchies
  • Lookups and Double Columns
  • Fragmentation
  • Bridge Tables
  • BI Server Caching
  • XUDML
  • Summary of RPD Golden Rules

Interested in taking our Oracle BI 12c ‘Advanced’ RPD Modelling training course? Enquire Now!