OBI EE "Advanced" RPD Modelling

Course:	OBI EE “Advanced” RPD Modelling
Duration:	4 days
Delivery:	Instructor led with hands on exercises
Events:	Private Training available on-demand (Contact Us)
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

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...