Skip Main Navigation
Page Content

Save This Event

Event Saved

OBIEE – ORACLE BUSINESS INTELLIGENCE TRAINING

Westminster College, UK

Monday, 5 February 2018 at 10:00 - Thursday, 8 February 2018 at 17:00 (GMT)

OBIEE – ORACLE BUSINESS INTELLIGENCE TRAINING

Ticket Information

Ticket Type Sales End Price * Fee Quantity
OBIEE – ORACLE BUSINESS INTELLIGENCE 11G TRAINING 5 Feb 2018 £1,790.00 £67.38
* Prices include VAT

Share OBIEE – ORACLE BUSINESS INTELLIGENCE TRAINING

Event Details

COURSE OVERVIEW

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.


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


COURSE CONTENT


  • 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

EXECUTING DIRECT DATABASE REQUESTS 

 
  •  Execute direct database request

USING AGGREGATES 

  
  • 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

CREATING A QUERY AND A CHART 

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

WORKING WITH A PIVOT TABLE 

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

CREATING A NARRATIVE VIEW 

   
  • 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

CREATING AN INTERACTIVE DASHBOARD 

   
  • To create an Interactive Dashboard

USING DASHBOARD PROMPTS AND PRESENTATION VARIABLES 

   
  •  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…

 

2 REVIEWS FOR OBIEE – ORACLE BUSINESS INTELLIGENCE 11G

  1. 4 out of 5

     – 28th July 2016:

    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

     – 6th October 2016:

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

Do you have questions about OBIEE – ORACLE BUSINESS INTELLIGENCE TRAINING? Contact Westminster College, UK

Save This Event

Event Saved

When & Where


Westminster College
88 Kingsway,
Holborn,
WC2B 6AA London
United Kingdom

Monday, 5 February 2018 at 10:00 - Thursday, 8 February 2018 at 17:00 (GMT)


  Add to my calendar

Organiser

Westminster College, UK

Westminster College is  Central London's Top Professional IT training organisation. We're located in Central London, just next to Holborn tube station, and we offer over 100 courses across a wide range of IT subjects.  

  Contact the Organiser
OBIEE – ORACLE BUSINESS INTELLIGENCE TRAINING
Things to do in London Course Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.