Audience :

  • End Users
  • Business Users
  • Implementors
  • Developers
  • Business Analysts
  • OBIEE Administrators

Topics :

  • Table of Contents
    • Product and Course Overview
    • Introduction to Oracle BI Enterprise Edition
    • Scenario
    • Starting Oracle BI Presentation Services
    • Exploring the Unified Framework
  • Creating a Simple Analysis
    • Creating an OBIEE Analysis
    • Creating and saving simple filters
    • Investigating commonly used view options
    • Creating subtotals and grand totals
    • Sorting the rows of the result set
    • Saving Favorites
    • Duplicating and modifying existing analyses
    • Creating custom formulas
    • Formatting analysis columns
    • Saving reusable analytics calculations
  • Defining Filters
    • Filtering using related columns
    • Filtering using variables
    • Creating top/bottom filters
    • Filtering for the Top/Bottom X% of rows
    • Filtering for a combined X% of total results
    • Creating filter groupings
    • Filtering using SQL
    • Filtering based on results from a saved analysis
    • Filtering within a column formula
  • Drilling and Navigation
    • Drilling and navigating
  • Pivot Tables
    • Creating a pivot table
    • Adding pivot table totals
    • Adding pivot table calculations
    • Creating pivot table calculated items
  • Table View Options
    • Displaying the table view in "Green Bar" style
    • Table layout options
  • Graphs
    • Bar graphs
    • Line graphs
    • Renaming Views
    • Trellis graphs
    • Axis Labels, Scaling, Scale Markers
    • Line-Bar graphs
  • Compound Layouts
    • Modifying compound layouts
  • Additional Views
    • Narratives
    • The No Results message
    • Column Selectors
    • View Selectors
    • Gauges
    • Legends
    • Tickers
    • Titles
    • Heat Maps
  • Exploring the Visual Analyzer
    • Creating Visual Analyzer objects
  • Creating Data Mashups
    • Incorporating Excel Data with OBIEE
  • Advanced Topics and Techniques
    • Creating union analyses
    • Conditional formatting
    • Bins
    • Performance Tiles
    • Creating a Map
  • Extended Navigation and Drilling
    • Navigating to a website
    • Creating a Master-Detail link
    • Multi-analysis Master-Detail Interaction
    • Using hierarchical columns
  • Selection Steps
    • Creating a simple selection condition
    • Creating custom dimension members using Calculated Items
    • Creating custom dimension members using Calculated Groups
  • Dashboard Prompts
    • Creating a column-based dashboard prompt
    • Creating a presentation variable dashboard prompt
    • Creating cascading dashboard prompts
    • Creating limited-scope dashboard prompts
    • Creating hierarchical dashboard prompts
    • Creating Analysis Prompts
  • Oracle BI Dashboards: Overview
  • Dashboard Layout
    • Creating a new dashboard page and adding columns
    • Creating and formatting sections
  • Populating Dashboard Contents
    • Adding a dashboard prompt to the dashboard
    • Adding an Oracle BI Analysis to the dashboard
    • Adding links and images to the dashboard
    • Adding text to the dashboard
    • Adding a folder view to the dashboard
    • Adding guided navigation to the dashboard
    • Adding embedded content to the dashboard
    • Adding an Alerts section to hold Agent output
    • Adjusting column properties
    • Managing dashboard pages
    • Creating section report links
    • Creating shared dashboards (information only)
    • Publishing shared dashboards (information only)
  • Saved Customizations
    • Saving dashboard customizations
    • Applying saved dashboard customizations
    • Renaming and deleting dashboard customizations
  • Overview of Oracle BI Agents
  • Creating and Configuring Agents
    • Configuring your user account
    • Creating a new Agent
    • Saving an Agent
    • Subscribing to Agents (information only)
    • Accessing Oracle BI Alerts
  • Day 5
  • KPIs (Key Performance Indicators)
    • Creating a "High values are desirable" KPI
    • Creating a "Low value is desirable" KPI
    • Copying and changing existing KPIs
  • Creating a KPI Watchlist
    • Creating a new KPI Watchlist
    • Creating Analyses from KPI Watchlists
  • Scorecards
    • Creating a Scorecard
  • Complex Analyses and Prompts
    • Creating a multi-part dashboard prompt
    • Creating a complex analysis
    • Building a multi-analysis column selector
    • Conditional sorting, highlighting, and selection
    • Cleanup and completion of the Analysis
  • Appendix A: Graph Types Available in Oracle BI Answers
  • Appendix B: Variables
  • Appendix C: Dashboard Best Practices
  • Appendix D: Suggested Object Suffixes
  • Appendix E: Integration with Microsoft Office