Oracle BI 11g: Create Analyses & Dashboards Training

• Develop & use the views and graphs in analyses
• Develop analyses with Essbase data sources
• Use the Oracle BI Mobile for accessing Business Intelligence content
• Create and work with the KPIs
• Organize, create the set up and deliver the personalized alerts with the help of Oracle BI Delivers
• Implement the BI content in Microsoft Office applications
• Create and modify Interactive Dashboards
• Perform the administration tasks related to the development and configuration of Interactive Dashboard
• Demonstrate how to add geographical mapping to analyses
• Implement the BI Composer
• Perform the pre- and post-aggregate filtering using filters, groups, and selections
• Combine the analysis criteria across multiple subject areas and execute direct database queries as well
• Make the use of hierarchical columns in analyses and views

• Application Developers
• Business Analysts
• Business Intelligence Developer
• Developer
• End Users
• Functional Implementer
• Technical Administrator
• Technical Consultant

1. Introducing Oracle Business Intelligence Enterprise Edition

• Introduction to Oracle BI
• Architecture overview

2. 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

3. 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

4. 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

5. 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

6. 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

7. Visualizing Data: Gauges, Maps, and Mobile

• Working with Gauge views
• Creating and editing Map views
• Working with and searching content in BI Mobile

8. Measuring Results with Key Performance Indicators

• Creating KPIs, setting trending, dimensionality, and thresholds
• Creating a KPI Watchlist
• Changing Dimensionality for a KPI Watchlist event

9. 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

10. 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

11. Configuring Oracle Business Intelligence Dashboards

• Exploring types of dashboard content
• Embedding content in dashboards

12. 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

13. 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

14. Integrating Analyses with MS Office

• Working with Oracle BI content in Microsoft Office applications

15. 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

16. Scorecarding

• Identifying the objects and components of Oracle Scorecard and Strategy Management
• Creating a scorecard
• Editing a scorecard