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

Request more details:

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.

View other Oracle Courses available
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