Announcing : Oracle BI Training Days, London October 22nd - 24th 2008

Something that we've been working on in the background recently, and are now able to announce, are the first of our Oracle BI Training Days running in London from October 22nd to the 24th, 2008. If you're a developer using Oracle's latest BI tools and you're looking to take a step up in terms of your technical knowledge, plus get the chance to meet our team and other advanced developers using Oracle's BI tools, this is an opportunity you can't afford to miss.

The event is running over three days with a different focus on each day. The way we are pricing it is that you can attend for just one day, or attend all three for the price of two. We're organizing a meal (ticket price included) at the end of the first day, and we're keeping the numbers attending restricted so that those that attend can get the maximum possible out of the session. The format of the three days will be a seminar/workshop style, with either myself or one of the team leading each session, doing demos, and providing you with the demo and sample files so that you can follow along if you wish. The expectation for each session is that you have some level of basic knowledge, we will take you beyond this and also introduce you to some potentially new topics such as the Oracle BI Applications and some of the new features in Essbase 11.1 and Oracle Database 11g.

Day 1 - Oracle Business Intelligence Enterprise Edition In-Depth

  • A Future Oracle BI Architecture
    • OBIEE overview
    • OBIEE architecture
    • The Oracle BI&DW Tech Stack
    • Key features and new possibilities
    • A proposed architecture and development approach
  • Oracle BI EE Data Modeling Techniques
    • The Common Enterprise Information Model
    • Creating the Business Model and Mapping Layer
    • Mapping 3NF data models into the Business Model
    • Integrating Multiple data sources into the business model
    • Fragmentation and Real-Time Integration
  • Oracle BIEE Performance Optimization
    • Clustering and other physical implementation optimizations
    • Optimizing the Business Model
    • Caching
    • Aggregate Persistence Wizard
  • OBIEE Integration with SOA and BPEL and Web applications
    • The OBIEE Web Services Interface
    • The EasyBI SOA Bridge
    • Integrating OBIEE with SOA and BPEL
    • Integrating OBIEE with web-based applications using GO URL

Day 2 - New Features in Oracle OBIEE 10gR3 and Oracle 11g Data Warehousing

  • Essbase 9.3.1 and 11.1 Integration with OBIEE
    • Overview of Essbase
    • Building an Essbase Cube using EIS and Essbase Studio
    • Integrating an Essbase Cube into OBIEE
    • Loading Essbase Cubes from the Common Enterprise Information Model
    • Integrating OBIEE dashboards into the Hyperion Workspace
  • Automated Decision Making Using Oracle Real-Time Decisions
    • The need for automated business decisions
    • Introduction to Oracle Real-Time Decisions
    • Steps to Create a Real-Time Decisions Project
    • Integration of Real-Time Decisions with ApEx and ADF
  • Migrating Discoverer EULs and Workbooks to OBIEE
    • Aspects of OBIEE/ Discoverer Integration
    • Using the Discoverer EUL Migration Utility
    • Post-migration steps
    • Migrating Discoverer Workbooks
    • Integration of Discoverer with Oracle BI Publisher
  • New DW Features in Oracle Database 11g
    • Overview of Oracle Database 11g DW Features
    • New Partitioning Features
    • The Relationship between the DW and OBIEE
    • Cube Organized Materialized Views

Day 3 - OBI Apps In-Depth

  • Oracle BI Applications 7.9.5 Introduction and Architecture
    • Overview of Oracle BI Applications
    • Oracle BI Applications Architecture
    • The Oracle Business Analytics Warehouse data model
    • Exploring the BI Apps data model and pre-built dashboards
  • Oracle Business Analytics Warehouse Administration using DAC
    • Introduction to the DAC
    • Basic DAC Administration
    • Performing an initial EBS 11.5.10 data load using the DAC
  • Introduction to Informatica PowerCenter 8.1.1
    • Overview of Informatica PowerCenter 8.1.1
    • Creating a simple mapping and running end-to-end
  • Extending and Customizing the BI Apps Data Warehouse.
    • Overview of the Oracle BI Apps customization methodology
    • Understanding SIL and SDE mappings
    • Customizing an Existing Type 1 mapping to customize a dimension
    • Creating a new Type 2 mapping to add new facts and dimensions

The idea of the event is to take you beyond what's available on other public courses, address the requirements of more advanced and experienced developers, and provide a "state of the nation" view of Oracle's latest BI & DW offerings, including what's been announced and showcased at Oracle Open World 2008. The cost of the event is £900 + VAT for one day, or £1800 + VAT for all three days, with a 10% early bird discount available until October 3rd. As I said, places are limited and so far we've received a lot of interest and bookings, so register now to avoid disappointment. If you want any more details, drop me an email or check out the web page, and hopefully we'll see you at the event in October.