Oracle Business Intelligence Enterprise Edition Overview

• Presentation Catalog
• Signing In/Out
• Navigation
• Setting Preferences
• Interacting with Other Products
• Integration with Publisher
• Integration with Microsoft Office

Creating Analyses

• What Are Analyses?
• How Are Analyses Processed?
• Embedding an Analysis in a Dashboard
• Understanding the Double Column Feature
• Creating New Analyses
• Specifying the Criteria for Analyses Editing the Formula for a Column

Adding Views for Display in Dashboards

• Available Views
• Editing Graph Views
• Modifying Values and Performing Write Back
• Interactions in Views
• Drilling in Views
• Sorting Data in Views Common Sort Functionality
• Linking Views in Master-Detail

Building and Using Dashboards

• Dashboard Overview
• Dashboard Builder
• Creating/Editing Dashboards
• Adding Oracle BI Publisher Reports to Dashboard Pages
• Changing the Properties of a Dashboard and its Pages

Filtering and Selecting Data for Analyses

• Saving Objects as Inline or Named
• Filters and Selection Steps
• Creating or Editing Column Filters
• Working with Groups and Calculated Items

KPIs and KPI Watchlists

• Overview
• Creating/Editing KPIs
• Generating an Analysis from a KPI
• Creating or Editing KPI Watchlists

Scorecarding

• Overview
• Editor
• Creating Scorecards
• Vision Statements
• Perspectives

Repository Basics

• Exploring Oracle BI architecture components
• Exploring a repository's structure, features, and functions
• Using the Oracle BI Administration Tool
• Creating a repository
• Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository

• Importing data sources
• Setting up connection pool properties
• Defining keys and joins
• Examining physical layer object properties
• Creating alias tables

Building the Business Model and Mapping Layer of a Repository

• Building a business model
• Building logical tables, columns, and sources
• Defining logical joins
• Building measures
• Examining business model object properties

Building the Presentation Layer of a Repository

• Exploring Presentation layer objects
• Creating Presentation layer objects
• Modifying Presentation layer objects
• Examining Presentation layer object properties

Adding Calculations to a Fact

• Creating new calculation measures based on existing logical columns
• Creating new calculation measures based on physical columns
• Creating new calculation measures using the Calculation Wizard
• Creating measures using functions

Working with Logical Dimensions

• Creating logical dimension hierarchies
• Creating level-based measures
• Creating share measures
• Creating dimension-specific aggregation rules
• Creating presentation hierarchies
• Creating parent-child hierarchies
• Using calculated members

Using Aggregates

• Modeling aggregate tables to improve query performance
• Setting the number of elements in a hierarchy
• Testing aggregate navigation
• Using the Aggregate Persistence Wizard

Modeling Time Series Data

• Using time comparisons in business analysis
• Using Oracle BI time series functions to model time series data

Modeling Many-to-Many Relationships

• Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables