Oracle Dashboard and Reports Training Course

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

* Ensure the success of your Oracle Business Intelligence project by learning from an experienced Oracle Business Intelligence expert.

* Learn how to collect specifications from executive-level management for dashboards and reports.

* See how to create and publish multiple templates for the BI Publisher reports. .

* Understand the types of dashboard graphics and when to deploy the right charting based on the data characteristics.

* Use advanced features of BI Publisher such as creating reports with hyperlinks, scheduling and managing scheduled reports, bursting the reports, using online and Excel analyzers to analyze the data in BI Publisher reports, and creating reports from data templates.

* See how to create executive dashboards for strategic data analysis.

* See how to extend Oracle dashboards for complex hypothesis testing and trend analysis.

* See how to configure and maintain Interactive Dashboards and how to customize the user interface using cascading style sheets, dashboard styles, and XML message files.

* Get proven techniques for extending dashboard reports.

* Get Step-by-step instructions for creating ad-hoc queries in Oracle Business Intelligence and incorporating them into Interactive Dashboards,

* Build simple and complex Oracle BI Interactive Dashboard including pivot tables, charts, gauges, prompts, embedded content, navigation links, and Oracle BI Publisher reports

Burleson's Oracle  Dashboard and Report Application Development Business Intelligence Suite Enterprise Edition course is a hands on three day intensive course designed for report developers, business analysts,  and subject matter experts to create professional level dashboards and reports using Oracle BI Dashboards and Reports.  

This dashboards and reports training course shows how to take full advantage of all aspects of powerful OBIEE end-user tools, and it also covers the material that is taught in the one day Power User Answers course as fully outlined in the class syllabus below.

 Every Oracle  Business Intelligence  shop has different requirements, and Oracle Business Intelligence training course can also be customized according to your specific needs along with follow-up supplemental mentoring to guarantee your success in your  Business Intelligence  deployment.

BC is proud to be the All-American team with pragmatic training from expert instructors.

		Oracle BI Enterprise Edition  Dashboard & Reports best practices ISBN = 0615262953

This Oracle  Business Intelligence  Suite Enterprise Edition dashboard and reports training course is designed for practicing Oracle professionals who have basic experience with Oracle.

Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.

This course is intended for anyone involved in the Oracle Business Intelligence project, including IT managers, data analysts, developers, systems analysts and end-user liaisons.

Introduction to Oracle Business Intelligence.

Business Intelligence and Transactional Applications
Business Intelligence Balanced Scorecard.
Enterprise Planning and Budgeting.
Activity-Based Management for Business Intelligence.
Oracle Integration Components Enabling Business Intelligence.
Business Intelligence Data Hubs.
Business Activity Monitoring.
BPEL Process Manager.
Enterprise Messaging Service.
Custom Data Warehouse Solutions.
The Role of the Oracle Database in Business Intelligence .

Introduction to Oracle Data Warehousing

Oracle Data Warehousing Basics.
Oracle Database Analysis
Business Intelligence Schema Considerations.
Managing an Oracle-based Data Warehouse.
Oracle/PeopleSoft EPM.
Oracle/Siebel Business Analytics Applications.
Build or Buy?  Choosing a Custom Business Intelligence solution.

Overview of Oracle dashboard

Dashboard Basics
Charting and Chart Formatting Basics
Pivot Table Basics
Reports overview
Configure and maintain Interactive Dashboard
Customize a dashboard interface with cascading style sheets, dashboard styles, and XML message files.
Managing templates in Oracle dashboard

Using BI Publisher

Create and publish multiple templates for the BI Publisher reports.
Analyze the data from BI reports
Create BI reports with hyperlinks
Schedule and manage scheduled reports
Bursting BI Publisher reports
Using the online and Excel analyzers
Creating reports from data templates.

Using OBIEE for forecasting and trend analysis

Basics of linear regression (sum of the least squared, single, double and triple exponential smoothing)
Trend analysis and predictive validity (confidence interval)

Ad-hoc queries with BI Answers


Introduction and Overview of Fundamentals
Creating a Request
Filtering,
Totals
Formatting Tabular Views
Charting Basics Intermediate Charting and Chart Formatting Basics
Adding Calculations and Formatting
Using Bins
Conditional Formatting Basics
Advanced Formatting of Tabular Views
Column Selector Basics
View Selector Basics
Combining View Selectors and Column Selectors Review, Tips, and Tricks
Sophisticated trend analysis (non-linear regression)

Dashboard Management

Adding Calculations and Data Formatting
Using Bins
Conditional & Advanced Formatting
Dashboard and report navigation
The use of prompts, column selectors and view selectors
Dashboard Column & View Selector Basics
View Selector and Dashboard Basics
Developing Dashboard Prompts
Professional Level Tables and Pivot Tables
Complex Charts: Line-Bar Combinations

Building Reports

Build simple and complex Oracle BI Interactive Dashboard reports.
Create Oracle BI Publisher reports
Building and deploying gauges
Using report prompts
Adding embedded content to reports
Creating navigation links

Managing Requests

Creating a Request
Formatting an Existing Request
Developing Complex Requests Based upon Existing Requests
Making Requests More “User Friendly”
Presentation Variables
Multiple Request Navigation

Pivot Table Management

Interactive dashboard reports using pivot tables
Complex Pivot Tables
Drilling down

Oracle Dashboard Reports

Report exporting
Creating Interactive Dashboards
Step-by-step instructions for creating ad-hoc queries in OBIEE
Incorporating ad-hoc reports them into Interactive Dashboards
Printing and downloading
End user navigation essentials

Report Formatting

Charting Basics
Intermediate Charting and Chart Formatting Basics
Adding Calculations and Data Formatting
Conditional Formatting Basics
Advanced Formatting of Tabular Views
Combinations with Similar Requests
Filters Based on the Results of Other Requests
Additional Views in Answers
Filtering, Totals, and Formatting Tabular Views

Using Excel Analyzer

Install and configure Excel Analyzer
Configuring the scheduler for the Excel Analyzer
Configuring report delivery media for the Excel Analyzer

Selecting data sources

Column Selector Basics
View Selector Basics
Combining View Selectors and Column Selectors

Advanced Dashboard Topics

Ranking and Top and Bottom Requests
Advanced Formatting of Tabular Views
Combining Column Selectors with a Single Chart View
Bubble Charts
Using Guided Navigation to Create Dashboard Alerts
Navigation to Display or Hide Dashboard Sections
Text Areas
Links to Shared Folders and RSS
Advanced Presentation Variables