Oracle BI 11g "Advanced" Bootcamp

This 5 day training provides BI Developers and Architects with all the knowledge and “hands-on” experience needed to deliver a world-class OBIEE 11g implementation. 

First of all, Delegates will learn how to design and build a sophisticated set of Interactive Reports and Dashboards using a wide range of exciting features and visualisations.

Delegates will then spend 3 days learning the advanced concepts and key fundamentals behind the Oracle BI 11g Server and BI Repository (RPD), learning how to model a variety of complex data sources and presenting users with an intuitive and usable set of Subject Areas.

Course:
Oracle BI 11g "Advanced" Bootcamp
Duration:
5 Days
Delivery:
Instructor led with hands on exercises
Events:

Private Training available on-demand

Attendees:
BI Developers and Architects
Numbers:
Up to 15 Delegates per training

Agenda:

Day 1 - Reports and Dashboards

  • Introduction to Answers
  • Column Properties
  • Column Formulas
  • Filters
  • Tables, Pivot Tables and Graphs
  • Multiple Subject Areas
  • Other Useful Views
  • Set Operations
  • Drill-Down and Navigation

Day 2 - Reports and Dashboards

  • Master-Detail Linking
  • Hierarchical Columns
  • Conditional Formatting
  • Embedded Maps
  • Introduction to Dashboards
  • Dashboard Prompts
  • Action Links and Conditions
  • Presentation Variables
  • Selections, Groups and Calculated Items
  • Dashboard Customizations

Day 3 - Advanced Modelling

  • 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 4 - Advanced Modelling

  • 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 5 - Advanced Modelling

  • Hierarchical Columns
    • Ragged
    • Skipped Level
    • Parent-Child
  • Outer Joins
  • Cross-Database Joins
  • Non-Conformed Dimensions
  • Fragmentation
  • BI Server Caching
  • Usage Tracking
  • 20 Golden Rules for RPD Design

Interested in taking our Oracle BI 11g ‘Advanced’ Boot Camp training course? Enquire Now!