OBI EE Advanced Modelling - Part 1
Starting dates and places
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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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!
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.