Exalytics in action! Tuning on-the-fly with the Exalytics "Summary Advisor".
Watch Video



See how Peak Indicators have transformed the Oracle BI training market. Watch Video
Course: OBI EE “Advanced” RPD Modelling
Duration:    4 days
Delivery:   Instructor led with hands on exercises
Events: Private Training available on-demand (Contact Us)
Public Training events also available (view Public Schedule)
Attendees:   Experienced BI Developers and Architects
Numbers: Up to 15 Delegates per training
   
Overview: 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 18 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 and Essbase Cubes)

Download the full brochure in PDF format

 

Agenda:      

Day 1

  • BI EE “Advanced” Concepts
  • Modelling Star-Schemas
  • Time Dimensions
  • Slowly Changing Dimensions
  • Dimension Hierarchies
  • Mini-Dimensions
  • Snow-Flaking
  • Aggregation
  • Denormalisation
  • Conforming Dimensions

Day 2

  • Variables
  • Security (DB and LDAP) 
    • Authentication
    • Authorisation
    • Security Filters
  • Logical Calculations
    • Physical vs Logical
    • Level Based Measures
    • Time Series
  • Modelling Third-Normal-Form (3NF)
 

Day 3 

  • Cross Database-Joins
  • Non-Conforming Dimensions
  • Design Principles 1-3
  • Modelling Flat Structures
  • Fragmentation
  • Outer-Joins
  • Write-Back
  • UDML
  • Oracle OLAP

Day 4

  • Oracle Essbase
  • BI Server Caching
  • Usage Tracking  (incl. Repository Merge)
  • “SA System” Subject Area
  • Data-Mart Automation
  • Generating RPD Meta-Data
  • Conducting a BI Repository Review


Contact Us to request further details
 






Twitter Image



Search
More Info