0
  • An empty cart

    You have no item in your shopping cart

Enter your keyword

OBIEE - Oracle Business Intelligence 11g

OBIEE – Oracle Business Intelligence 11g

Hot

Course Overview

This course focuses on Oracle Business Intelligence Foundation Suite 11 Certified Implementation Specialist Certification. The course involves theory and hands-on practical using step-by-step instructions on how to perform a variety of tasks and exercises. Because the step-by-step solutions are built for practical real world applications, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.

Course Start Dates

Start Date TimeDaysDurationLocation
20/11/2017 10.00-5.00pm Mon to Thu 4 Days Holborn
08/01/201810.00-5.00pm Mon to Thu 4 Days Holborn
26/02/201810.00-5.00pm Mon to Thu 4 Days Holborn
23/04/201810.00-5.00pmMon to Thu4 DaysHolborn
18/06/201810.00-5.00pmMon to Thu4 DaysHolborn
17/09/201810.00-5.00pmMon to Thu4 DaysHolborn
24/11/201810.00-5.00pmMon to Thu4 DaysHolborn

Prerequisites

  • Dimensional modeling
  • Basic SQL
  • Data warehouse design
  • Database design

Target Audience

  • Business Intelligence Developer
  • Data Warehouse Administrator
  • Business Analysts
  • Data Warehouse Analyst
  • Data Modelers
  • Reports Developer
  • Data Warehouse Developer
  • Application Developers

On-site training for Corporate

We conduct on-site training for this course provided that the company has a training room with laptops or computers.

The price for a group of up to 3 candidates is £4,500.00 and for every additional candidate is £1100.00 (within M25 area)

The price for a group of up to 3 candidates is £4,900.00 and for every additional candidate is £1100.00 (outside M25 area)

Course Content

Oracle Business Intelligence 11g

  •  OBIEE Installation
  • Data Modeling concepts
  • OBI Administration (Meta data RPD Development)
  •  Answers(Reports) Development
  • Dashboard Design

Using Administration Tool and Creating Repository

  • Create a New Repository
  • Create an ODBC Data Source
  • Import SH Schema
  • Create Physical Joins

  • Create a Business Model
  • Create Logical Tables
  •  Create Logical Columns
  • Create Logical Joins
  • Rename Business Model Objects
  • Delete Unnecessary Business Model Objects
  • Build Dimension Hierarchies

  • Testing and Validating a Repository
  • Run a Consistency Check
  • Enable Query Logging
  • Modify NQSConfig. ini
  • Start Oracle BI Services
  • Use Oracle BI Answers to Execute Queries
  • Use Query Log to Verify Queries

  • Load a Prebuilt Repository
  •  Create a New Measure
  • Create a Calculation Measure Using Answers
  • Create a Calculation Measure Using Logical Columns
  • Create a Calculation Measure Using Physical Columns
  • Create a Calculation Measure Using the Calculation wizard
  • Organizing the Presentation Layer

  • Create an Initialization Block for Session Variables
  •  Test the initialization block and session variables
  • Create a dynamic repository variable
  • Adding Multiple Sources

  •  Import the Excel data source
  •  Map logical dimension columns
  • Create the quota measures
  • Test the quota measures

  •  Execute direct database request

  • Use Direct Database Request to Create Aggregate Tables
  •  Import Aggregate Tables
  • Create Physical Joins for Aggregate Tables
  • Map existing logical columns to aggregate columns
  • Test in Answers and Examine Query log

  •  Identify a dimension as a time dimension
  •  Create a Month Ago measure
  • Create a Change Month Ago measure
  • Create a ToDate measure
  •  Test the time series measures

Using Answers and Creating Interactive Dashboards

  •  To restore the Presentation Catalog

  • To create a query
  • To add a filter for the direct channel
  • To create totals and format results
  • To create a chart

  •  To create and set the basic layout for a pivot table
  •  To add calculations and formatting to the pivot table

  • To create a query
  • To add a filter for the percent change in the amount sold
  • To create a narrative view

  • To create a Column Selector
  • To create a View Selector

  • To create an Interactive Dashboard

  •  To create a dashboard prompt that filters on Country Region…
  •  To use a Presentation variable to populate a title with the name of the selected country region…

Reviews Statistic

4
4 out of 4
2 Ratings
5 Start 0
4 Start 2
3 Start 0
2 Start 0
1 Start 0

2 reviews for OBIEE – Oracle Business Intelligence 11g

  1. 4 out of 5

    :

    A well run very informative course. The tutor was helpful and knowledgeable and I achieved everything I set out to learn.

  2. 4 out of 5

    :

    Comprehensive course covering OBIEE installation, Analysis and Dashboard creation plus an introduction to ODI.

Add a review

Duration 4 Days

Location map

Share our course