课程大纲

Introducing Oracle Business Intelligence Enterprise Edition

      • Introduction to Oracle BI

      • Architecture overview

Working with Oracle Business Intelligence Analyses

      • Introduction to Oracle BI Analysis Editor

      • Oracle BI column types

      • Working with analyses in Oracle BI

      • Using advanced formatting

Administering the Presentation Catalog

      • Oracle BI and catalog security overview

      • Managing security using roles

      • Understanding security inheritance 

      • Setting object permissions

      • Setting system privileges

      • Archiving catalog items

Limiting and Grouping Data in Analyses

      • Introduction to filters and selections

      • Creating, editing, and grouping filters

      • Adding prompts to analyses

      • Dynamic filtering 

      • Using saved analyses as filters

      • Creating groups

      • Creating calculated items

      • Creating selection steps

Oracle Business Intelligence Analyses: Advanced Features

      • Setting analysis properties

      • Combining analysis criteria by using set operations

      • Executing direct database analyses

      • Editing logical SQL generated by an analysis

      • Creating a link to a saved analysis

      • Creating an Excel Web Query file

Working with Views and Graphs in Analyses

      • Introduction to views, graphs, and editors

      • Working with views in Compound Layouts

      • Creating and editing graphs

      • Linking master-detail views

      • Performing common view tasks 

Visualizing Data: Gauges, Maps, and Mobile

      • Working with Gauge views 

      • Creating and editing Map views

      • Working with and searching content in BI Mobile

Measuring Results with Key Performance Indicators

      • Creating KPIs, setting trending, dimensionality, and thresholds

      • Creating a KPI Watchlist

      • Changing Dimensionality for a KPI Watchlist event

Showing Results With Pivot Tables

      • Creating, arranging, and formatting a pivot table

      • Using hierarchical columns

      • Sorting in pivot tables

      • Setting aggregation and using totals

      • Showing an item's relative value

      • Building calculations and displaying running sums

Creating Oracle Business Intelligence Dashboards

      • Creating and editing dashboards

      • Using the Dashboard Builder

      • Exploring dashboard object properties and options

      • Publishing dashboard pages

      • Creating personal customizations and using other page options

Configuring Oracle Business Intelligence Dashboards

      • Exploring types of dashboard content

      • Embedding content in dashboards

Creating Dashboard Prompts and Variables

      • Understanding variables

      • Adding a named dashboard prompt to a dashboard

      • Adding a hidden named dashboard prompt to a dashboard

      • Creating additional prompt page and setting page preferences

      • Adding variable prompts to a dashboard

Using Oracle Business Intelligence Delivers

      • Configuring delivery devices and adding delivery profiles

      • Adding an Alert Section to a dashboard

      • Configuring an Agent

      • Using Analysis and KPI conditions to deliver content with Agents

      • Subscribing to an Agent

Integrating Analyses with MS Office

      • Working with Oracle BI content in Microsoft Office applications

Working with Oracle Business Intelligence Briefing Books

      • Adding content to Briefing Books

      • Editing Briefing Books

      • Downloading and viewing Briefing Books

      • Adding a list of Briefing Books to a dashboard

      • Using Briefing Books with Oracle BI Delivers

Scorecarding

      • Identifying the objects and components of Oracle Scorecard and Strategy Management

      • Creating a scorecard

      • Editing a scorecard

对应认证: 

Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist（1Z0-591）