Course Topics
1. Introduction to Oracle Business Intelligence Enterprise Edition
- Introduction to Oracle BI EE
- Oracle BI 12c Highlights
- Oracle BI 12c Architecture
2. Working with Oracle Business Intelligence Analyses
- Adding basic formatting
- Working with analyses in Oracle BI
- Introduction to Oracle BI Analysis Editor
- Setting analysis properties
- Oracle BI column types
- Using advanced formatting
3. Filtering Data for Analyses
- Adding prompts to analyses
- Using saved analyses as filters
- Dynamic filtering
- Creating, editing, and grouping filters
- Introduction to filters and selections
4. Selecting and Grouping Data for Analysis
- Creating calculated items
- Including advanced SQL clauses in your analysis
- Creating selection steps
- Creating direct database analysis requests
- Creating groups
5. Advance Visualization in Analysis
- Working with views in Compound Layouts
- Performing common view tasks
- Introduction to views, graphs, and editors
- Creating and editing graphs
6. Showing Results with Pivot Tables
- Using hierarchical columns
- Building calculations and displaying running sums
- Showing an item’s relative value
- Creating, arranging, and formatting a pivot table
- Setting aggregation and using totals
- Sorting in pivot tables
7. Working with Additional Views in Analyses
- Creating simple and advanced trellis views
- Creating performance tile views
- Linking master-detail views
- Working other view types like Treemap and Heat Matrix
8. Visualizing Data on Maps
- Oracle spatial components
- Managing map data
- Other applications and points of integration for map views
- Interacting with map views
- Creating and editing Map views
9. Creating Oracle Business Intelligence Dashboards
- Publishing dashboard pages
- Using the Dashboard Builder
- Exploring dashboard object properties and options
- Creating and editing dashboards
- Creating personal customizations and using other page options
10. Configuring Oracle Business Intelligence Dashboards
- Embedding content in dashboards
- Exploring types of dashboard content
11. Creating Dashboard Prompts and Variables
- Adding variable prompts to a dashboard
- Creating additional prompt page and setting page preferences
- Adding a named dashboard prompt to a dashboard
- Understanding variables
- Adding a hidden named dashboard prompt to a dashboard
12. Scorecards and Key Performance Indicators
- Editing scorecards and KPIs
- Objects and components of Oracle Scorecard and Strategy Management
- Creating scorecard documents
- Scorecard document types
- Creating scorecards and KPIs
- Key Performance Indicator (KPI) overview
13. Visual Analyzer, BI Ask, and Data Mashup
- Creating Visual Analyzer Projects
- Adding and rearranging the Visualizations
- Data Mashups
- BI Ask
14. Working with BI Content in Smart View
- Creating and publishing views using the View Designer
- Federating data from multiple data sources
- Inserting BI views in to Smart View clients
- Working with Views in Smart View Clients
- Customizing BI data in MS Office
- Copying and pasting views between Smart View clients
15. Oracle Business Intelligence Mobile
- Navigating the Oracle BI mobile application
- Oracle BI Mobile Security Toolkit
- Downloading and using the Oracle BI mobile application
- Working with BI content
- Working with favorites and local content
16. Using Oracle Business Intelligence Delivers
- Adding an Alert Section to a dashboard
- Configuring an Agent
- Subscribing to an Agent
- Using Analysis and KPI conditions to deliver content with Agents
- Configuring delivery devices and adding delivery profiles
17. Administering the Presentation Catalog
- Working with Oracle BI Briefing Books
- Setting object permissions
- Setting system privileges
- Managing security using roles
- Oracle BI and catalog security overview
- Understanding security inheritance
- Archiving catalog items
18. Direct Database Analysis
- Creating and Executing a Direct Database Analysis
- Changing Direct Database Analysis Privileges
- Direct Database Analysis Overview
19. Expressions
- Advance Analytics Internal Logical SQL Functions
- Running Aggregate Functions
- Advance Analytics External Logical SQL Functions
- SQL Syntax and Semantics
