Introduction to Oracle Business Intelligence Enterprise Edition
Introduction to Oracle BI EE00:00:00
Oracle BI 12c Highlights
Oracle BI 12c Architecture
Working with Oracle Business Intelligence Analyses
Adding basic formatting00:00:00
Working with analyses in Oracle BI
Introduction to Oracle BI Analysis Editor
Setting analysis properties
Oracle BI column types
Using advanced formatting
Filtering Data for Analyses
Adding prompts to analyses00:00:00
Using saved analyses as filters
Dynamic filtering
Creating, editing, and grouping filters
Introduction to filters and selections
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
Advance Visualization in Analysis
Working with views in Compound Layouts
Performing common view tasks
Introduction to views, graphs, and editors
Creating and editing graphs
Draft Lesson
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
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
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
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
Draft Lesson
Creating Dashboard Prompts and Variables
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
Configuring Oracle Business Intelligence Dashboards
Embedding content in dashboards
Exploring types of dashboard content
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
Visual Analyzer, BI Ask, and Data Mashup
Creating Visual Analyzer Projects
Adding and rearranging the Visualizations
Data Mashups
BI Ask
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
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
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
Administering the Presentation Catalog
Working with Oracle BI Briefing Books
Draft Lesson
Setting object permissions
Setting system privileges
Managing security using roles
Oracle BI and catalog security overview
Understanding security inheritance
Archiving catalog items
Direct Database Analysis
Creating and Executing a Direct Database Analysis
Changing Direct Database Analysis Privileges
Direct Database Analysis Overview
Expressions
Advance Analytics Internal Logical SQL Functions
Running Aggregate Functions
Advance Analytics External Logical SQL Functions
SQL Syntax and Semantics