Oracle BI 11g R1: Create Analyses and Dashboards (Self-Study Course)

 

Who should attend

  • Business analysts
  • End users
  • Technical consultants
  • Developers

Product Description

  • Introduction to 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
    • Maintaining the Oracle BI Presentation Catalog in the Catalog page
    • 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
    • Introduction to Gauge views
    • Working with Gauge views
    • Introduction to Map views and their components
    • Creating and editing Map views
    • Introduction to Oracle Business Intelligence Mobile
    • Working with and searching content in BI Mobile
  • Measuring Results with Key Performance Indicators
    • Introduction to KPIs
    • Creating KPIs, setting trending, dimensionality, and thresholds
    • Introduction to KPI Watchlists
    • Creating a KPI Watchlist
    • Changing Dimensionality for a KPI Watchlist event
  • Showing Results With Pivot Tables
    • Introduction to 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
    • Introduction to dashboards and dashboard pages
    • Creating and editing dashboards
    • Using the Dashboard Builder
    • Exploring dashboard oject properies and options
    • Publishing dashboard pages
    • Creating personal customizations and using other page options
  • Configuring Oracle Business Intelligence Dashboards
    • Types of dashboard content
    • Embedding content in dashboards
  • Creating Dashboard Prompts and Variables
    • Overview of variables
    • Introduction to dashboard prompts and prompt types
    • 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
    • Variables and prompts
    • Adding variable prompts to a dashboard
    • Wiring dashboard prompts
  • Using Oracle Business Intelligence Delivers
    • Introduction to Oracle BI Delivers
    • Introduction to alerts
    • Adding an Alert Section to a dashboard
    • Overview of Agents
    • Configuring an Agent
    • Using Analysis and KPI conditions to deliver content with Agents
    • Subscribing to an Agent
  • Integrating Analyses with MS Office
    • Introduction to Oracle BI Office Add-in
    • Working with Oracle BI content in Microsoft Office applications
  • Working with Oracle Business Intelligence Briefing Books
    • Introduction to Oracle BI 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

Price on request