Course Contents :
Overview
General Datawarehousing concepts
Dimensional modeling basics
Oracle Business Intelligence Application Overview
Describing the Oracle Business Intelligence Applications Architecture and components
BI Server
BI Answers
Interactive Dashboards
Delivers
ADMIN TOOL AND RPD MODELING
Creating Repository Using Administrative Tool
Repository Basics
Building Physical Layer of Repository
Building Physical Model and BMM Layer of a Repository
Building the Presentation Layer of a Repository
Testing & Validation of a Repository
Calculations & Measures
Creating Dimension Hierarchies
Organizing Presentation Layer
Working with Initialization Blocks and Variables
Adding Multiple Sources
Executing Direct Database Requests
Working with Aggregates
Creating Time Series Measures
DASHBOARD AND ANALYSIS
Creating Interactive Dashboards using Answers
Creating query and chart
Working with Filters
Working with Pivot Table
Building Views and Charts in Requests
Creating Interactive Dashboard
Configuring Interactive Dashboards and prompts
Configuring Guided Navigation Links
Using Partitions and Fragments
KPI & Scorecarding
Oracle BI for MS-Office
SCHEDULING AND DELIVERING
Sending Alerts Using Delivers
Configure Scheduler Schema
Scheduler Configuration
Creating Sample Request and Adding to Interactive Dashboard
Creating and Delivering a Simple iBot
Creating and Delivering a Conditional iBot
SECURITY FEATURES AND UPGRADE
Authentication & Authorization
Object & Data Level Security
Webcatalog Level Security
Creating Users, Groups & Webgroups
Upgrading RPD/WEBCAT from a earlier release
