OBI EE Advanced Modelling - Part 1

Level
Total time

OBI EE Advanced Modelling - Part 1

Perpetual Solutions
Logo Perpetual Solutions
Provider rating: starstarstarstarstar 10 Perpetual Solutions has an average rating of 10 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Prerequisites:

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

Course Description:

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 w…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Business Intelligence (BI), Data Warehouse, Microsoft SQL Server, IT Security, and Web Accessibility.

Prerequisites:

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

Course Description:

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.

This course includes the following modules:

Course Contents

  • 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)

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.