Oracle Business Intelligence (BI): Create Reports and 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.
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 and 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 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
OracleBusiness IntelligenceDashboard ReportingOracle Business Intelligence DiscovererOracle Discoverer