Enable Technology

Data Analytics 

Oracle Business Intelligence - Create Reports and Interactive Dashboards




Course Overview


Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated dashboards and reports.

Duration: 3 day course



Course Content


Databases and Data Models
About Database Technologies
Logical Data Models
Physical Data Models

Data Warehousing and BI
Transactional Databases
Warehouse Databases
Warehouse Models and Schemas
About Business Intelligence
OLAP, BI, DSS

Introduction to Oracle BI Answers and Dashboards
Oracle BI Architecture
Launch BI Presentation Services
Log On
Basic Navigation

Using A Dashboard
Understanding The Dashboard Interface
Viewing the Request Results
Using Prompts to Filter Data
Saving and Reusing Filter Settings
Managing The View of the Dashboard Page
Viewing Supplementary Content
Miscellaneous Tasks

Building a Dashboard
Creating a Dashboard
Understanding the Dashboard Structure
Using the Dashboard Editor
Managing Saved Content
Managing Dashboard Objects

Creating a Report
Navigating the Answers Interface
Creating a New Request
Adding Columns to a Request
Previewing the Answers
Controlling the Report Definition
Downloading the Answers

Report Formatting
Report Attributes
Sorting Data
Filtering Data
Reusing Filters
Prompts

Column Formatting
Column Formatting
Column Formulas

Using Primary Views
About Views
Customizing the Table View
Chart View
Gauge View
Filters View
Managing the Views

Using Secondary Views
Column Selector View
View Selector View
Ticker View
Legend View
Narrative View
No Results View

Using Pivot Table Views
Pivot Table Concepts
A Pivoting Scenario
Defining the Pivot View
Sections and Pages
Totals within Pivot Tables

Advanced Formatting
Set Operations
Pdf and Print Control
View XML and SQL Calls

Administering The Presentation Catalog
Accessing The Presentation Catalog
BI and Presentation Catalog Security
Managing Presentation Catalog Objects

Deploying Requests to Dashboards
Variable References
Using Dashboard Prompts
Preparing Objects for Dashboard Deployment






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;