Oracle BI 12c: Create Analyses and Dashboards

Prerequisites

• Basic knowledge of Microsoft Office Applications

Audience

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

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