Our Oracle Business Intelligence training course gives delegates the opportunity to learn to develop and deploy commercial reporting and analysis solutions, with extensive hands-on labs using Oracle Database, Oracle Discoverer and Oracle Warehouse Builder, delivered by expert instructors.

• Understand Oracle Business Intelligence Suite
• Design and deploy reporting solutions to Oracle Portal
• Share reports through Discoverer Viewer
• Use Oracle BI Discoverer Plus Relational & OLAP
• Analyse and present data using Drilling, Pivoting and graphs
• Manage Oracle Discoverer
• Create the End User Layer (EUL)

Database programmers, business analysts and project managers who want to get the most out of the Business Intelligence tools available with Oracle Business Intelligence tools including Warehouse Builder and Oracle Discoverer

Some experience of using SQL language to query, and modify relational data

Overview of Oracle Business Intelligence platform

Fusion Middleware BI Solution
Oracle Business Intelligence (BI) Publisher
Oracle BI Discoverer

Using Discoverer Plus Relational

Ad hoc queries
Understanding Data Warehouses
Creating Reports
Adding, Sorting,
Pivoting & Deleting
Customising Report layout

Advanced formatting with Parameters & Conditions

Complex calculations
Time-series calculations
Calculated (custom) members

Workbooks and Worksheets

Configuring, creating and editing Worksheets
Discoverer URL parameters

Scheduling & Distributing Reports

Scheduling Reports & Workbooks in Discoverer Plus Relational
Export methods - MS Excel, HTML, PDF...

Analysing Data

Oracle Data Miner
Oracle Spreadsheet Add-In for Predictive Analytics
Analytic Function Template
Drilling up & Drilling down
Drill Structures & Facilities
Item & Date Hierarchies
Pivoting
Graphs
Key Performance Indicator (KPI) metrics
Scorecards - Balanced Scorecard & Six Sigma

Oracle OLAP

Relational and Multidimensional Data Models
Primary data types
Creating and Editing OLAP Queries
Creating Worksheets & Workbooks with Discoverer Plus OLAP

Oracle Discoverer Administrator

Overview of End User Layer (EUL)
Business Areas
Sharing reports

Lists of Values (LOVs)

Overview of LOVs
Creating and managing LOVs
Alternative Sort
Conditions
Item Classes

Folders and Items

Configuring properties
Creating Calculated Items
Registering PL/SQL Functions
Joins & Join Relationships
Complex Folders
Summary Folders
Automated Summary Management (ASM)
Custom Folders & LOVs
Analytical Items
Aggregate Items

Batch Scheduling

Manging the Batch Repository
Repository User properties
Scheduling & Managing Workbooks

Creating & Maintaing the End User Layer

(EUL)
Refreshing the Database
Managing the Business Area & Folders
Going Live
Automating Tasks
Assigning & verifying the Default EUL
Multiple EULs

Related courses

BI1 Intro to Microsoft Business Intelligence Training Course (SQL Server 2008 & SQL Server 2012)

BI2 Expert Business Intelligence with SQL Server Training Course

BI3 Business Intelligence with SharePoint and PerformancePoint Services Training Course