Course Search:
Request more details:


Print Page

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

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
  • Cost: Price on application
  • Duration: 2 or 3 Days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2010
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.