Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Oracle Dashboard and Reports Training Course

Oracle BI training © 2016 by Burleson Corporation

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

Click here for on-site course prices

Optional supplemental mentoring

 

Key Features

* 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

  

Course Description

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.

Book Required


Oracle BI Enterprise Edition 

Dashboard & Reports best practices


ISBN = 0615262953

Audience

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.

Curriculum Design

This Oracle  Business Intelligence  Suite Enterprise Edition course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Mr. Burleson has over two decades of real-world Business Intelligence experience, and strategic data analysis.  In this intensive training course, Mr. Burleson shares hidden secrets for maximizing your investment in the Oracle  Business Intelligence Suite.

Learning Objectives

By the end of this Oracle  Business Intelligence training course the student will understand the Oracle Business Intelligence infrastructure, Business Intelligence planning, data warehouse data collection.  In addition, the student will learn to construct their own queries, administer and build their own dashboards using Oracle  Business Intelligence  Suite Enterprise Edition.



Oracle  Dashboard & Reports Training Course
Syllabus

An intensive 3-day Oracle dashboard and reports training course

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

 

 

 

To view all of our Oracle  Business Intelligence  Suite training course please visit our main training page here.

   

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.