Oracle BI 11g "Advanced" RPD Modelling

Course:	Oracle BI 11g “Advanced” RPD Modelling
Duration:	4 days
Delivery:	Instructor led with hands on exercises
Events:	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

More Info:

Please Contact Us to request further details

Training Services

		View Office Addresses
		UK: Ireland:	+44 1246 550058 +353 1 871 9419
		enquiries@peakindicators.com
		Twitter: @Peakindicators
		LinkedIn

Training Delivery

See how Peak Indicators have transformed the BI training market with its comprehensive range of courses and the world's most effective delivery method.

Watch Video...