| Course: |
Oracle BI 11g “Advanced” RPD Modelling |
|
|
| Duration: |
4 days |
|
|
| Delivery: |
Instructor led with hands on exercises |
|
|
| Events: |
Public Training events now available (view Public Schedule)
Private Training available on-demand (Contact Us) |
|
|
| Attendees: |
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 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).
Download the full brochure in PDF format |
|
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
|
Contact Us to request further details
|
Twitter
Linkedin
