Oracle Business Intelligence (BI): Create Reports & Interactive Dashboards

Course Description

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 course will guide participants through all of the features available from the product, allowing them to build sophisticated database requests and to format resulting answers. <BR> <BR> <a href='http://www.professional.ie/it_training/database_oracle.htm'> View other Oracle Courses available </a> <BR>
2 or 3 Days
Contact us for pricing

Prerequisites

No specific prerequisite courses are required. A general working knowledge of desktop business software and the use of web-based services via a browser are the only mandatory technical prerequisites.

DATABASES & DATA MODELS

- ABOUT DATABASE TECHNOLOGIES
- LOGICAL DATA MODELS
- PHYSICAL DATA MODELS

DATA WAREHOUSING & BI

- TRANSACTIONAL DATABASES
- WAREHOUSE DATABASES
- WAREHOUSE MODELS & SCHEMAS
- ABOUT BUSINESS INTELLIGENCE
- OLAP, BI, DSS

INTRODUCTION TO ORACLE BI ANSWERS & 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 & 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

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 & PAGES
- TOTALS WITHIN PIVOT TABLES

ADVANCED FORMATTING

- SET OPERATIONS
- PDF & PRINT CONTROL
- VIEW XML & SQL CALLS

ADMINISTERING THE PRESENTATION CATALOG

- ACCESSING THE PRESENTATION CATALOG
- BI & PRESENTATION CATALOG SECURITY
- MANAGING PRESENTATION CATALOG OBJECTS

DEPLOYING REQUESTS TO DASHBOARDS

- VARIABLE REFERENCES
- USING DASHBOARD PROMPTS
- PREPARING OBJECTS FOR DASHBOARD DEPLOYMENT

OracleBusiness IntelligenceDashboard ReportingOracle Business Intelligence DiscovererOracle Discoverer