Oracle BI 11g "Advanced" Bootcamp

Course: Oracle BI 11g “Advanced” Bootcamp
Duration: 5 days
Delivery: Instructor led with hands on exercises
Events: Private Training available on-demand (Contact Us)
Attendees: BI Developers and Architects
Numbers: Up to 15 Delegates per training
Overview: 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.

Download the full brochure in PDF format

Agenda:

Day 1 - Reports & 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 & 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

Day 4 - Advanced Modelling

  • Conforming Dimensions
  • Simple Subject Areas
  • Variables
  • Security
  • Logical Calculations
    • Physical vs Logical
    • Level Based Measures
    • Time Series
  • Modelling Third-Normal-Form (3NF)
    • Handling Snow-Flakes
    • Opimising 3NF Queries
    • Overcoming Physical Complexity

Day 5 - Advanced Modelling

  • Hierarchical Columns
  • Outer-Joins
  • Cross Database-Joins
  • Non-Conforming Dimensions
  • BI Server Caching
  • Usage Tracking
  • 20 Golden Rules for the RPD
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...