OBI EE Advanced Modelling - Part 1

2 Day Course
Hands On
Official Oracle Curriculum
Code OCADVMP1

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

Part 1 of the OBI EE “Advanced Modelling” series 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-Warehouse and Transactional (OLTP) data structures and also to implement and optimize Cross-Database Joins.

Delegates will learn how to provide End Users with usable and intuitive “Subject Areas” regardless of the underlying complexity within the physical data sources. In addition to Modelling, expertise will be gained in other important areas such as Variables, Logical Calculations and Security. Delegates will learn not only how to apply row-level data visibility but also to implement Authentication and Authorization using both Database and LDAP sources.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Course Contents (9 topics)

  • Modelling Star-Schemas and Snow-Flakes
  • Aggregate Navigation and De-normalization
  • Dimensions, Mini-Dimensions and Hierarchies
  • Conformed and Non-Conformed Dimensions
  • Modelling Third-Normal-Form (3NF) / OLTP structures
  • Session and Repository Variables
  • Security and Security Filters (via Database and LDAP)
  • Cross-Database Joins
  • Logical Calculations (Level Based Measures, Time Series)

Prerequisites

This training is suitable for any person with prior Database, Data-Warehouse or Business Intelligence experience.

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections