See how Peak Indicators have transformed the Oracle BI training market. Watch Video
Oracle interview Peak Indicators about the OBIEE 11g release. Watch Video
Latest Knowledge Base Articles
|
| Course: |
Oracle BI 11g “Advanced” Bootcamp |
|
|
| Duration: |
5 days |
|
|
| Delivery: |
Instructor led with hands on exercises |
|
|
| Events: |
Public Training events now available (view Public Schedule)
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 (MOLAP)
- Outer-Joins
- Cross Database-Joins
- Non-Conforming Dimensions
- BI Server Caching
- Usage Tracking
- 20 Golden Rules for the RPD
|
|
Contact Us to request further details
|
|
|
Twitter
Linkedin