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).
Course:
Oracle BI 11g "Advanced" RPD Modelling
Duration:
4 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:
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
- XUDML
Day 4
- Oracle Essbase
- Oracle OLAP
- Query Federation
- BI Server Caching
- Usage Tracking
- Aggregate Persistence
- Generating RPD Metadata
- 20 Golden Rules for RPD Design