Oracle BI 12c: Create Analyses and Dashboards (D95505) – Outline

Detailed Course Outline

Introduction to Oracle Business Intelligence Enterprise Edition
  • Introduction to Oracle BI EE
  • Oracle BI 12c Architecture
  • Oracle BI 12c Highlights
Working with Oracle Business Intelligence Analyses
  • Introduction to Oracle BI Analysis Editor
  • Oracle BI column types
  • Working with analyses in Oracle BI
  • Adding basic formatting
  • Setting analysis properties
  • Using advanced formatting
Filtering Data for Analyses
  • Introduction to filters and selections
  • Creating, editing, and grouping filters
  • Adding prompts to analyses
  • Dynamic filtering
  • Using saved analyses as filters
Selecting and Grouping Data for Analysis
  • Creating selection steps
  • Creating groups
  • Creating calculated items
  • Creating direct database analysis requests
  • Including advanced SQL clauses in your analysis
Advance Visualization in Analysis
  • Introduction to views, graphs, and editors
  • Working with views in Compound Layouts
  • Creating and editing graphs
  • Performing common view tasks
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
Working with Additional Views in Analyses
  • Creating simple and advanced trellis views
  • Creating performance tile views
  • Working other view types like Treemap and Heat Matrix
  • Linking master-detail views
Visualizing Data on Maps
  • Oracle spatial components
  • Managing map data
  • Creating and editing Map views
  • Interacting with map views
  • Other applications and points of integration for map views
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
Scorecards and Key Performance Indicators
  • Objects and components of Oracle Scorecard and Strategy Management
  • Key Performance Indicator (KPI) overview
  • Scorecard document types
  • Creating scorecards and KPIs
  • Creating scorecard documents
  • Editing scorecards and KPIs
Visual Analyzer, BI Ask, and Data Mashup
  • Creating Visual Analyzer Projects
  • Adding and rearranging the Visualizations
  • BI Ask
  • Data Mashups
Working with BI Content in Smart View
  • Working with Views in Smart View Clients
  • Customizing BI data in MS Office
  • Copying and pasting views between Smart View clients
  • Inserting BI views in to Smart View clients
  • Creating and publishing views using the View Designer
  • Federating data from multiple data sources
Oracle Business Intelligence Mobile
  • Downloading and using the Oracle BI mobile application
  • Navigating the Oracle BI mobile application
  • Working with favorites and local content
  • Working with BI content
  • Oracle BI Mobile Security Toolkit
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
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
  • Working with Oracle BI Briefing Books
Direct Database Analysis
  • Direct Database Analysis Overview
  • Changing Direct Database Analysis Privileges
  • Creating and Executing a Direct Database Analysis
Expressions
  • SQL Syntax and Semantics
  • Running Aggregate Functions
  • Advance Analytics Internal Logical SQL Functions
  • Advance Analytics External Logical SQL Functions