ORACLE BI EE SYLLABUS

Day 1

  • Oracle Business Intelligence Enterprise Edition Overview
  • Creating a Repository Using the Oracle BI Administration Tool
  • Building the Physical Layer of a Repository
  • Creating a New Repository
  • Importing Metadata
  • Verifying Connection
  • Creating Keys and Joins
  • Building the Business Model and Mapping Layer of a Repository
  • Creating a Business Model
  • Examining Logical Joins
  • Examining Logical Columns
  • Examining Logical Table Sources
  • Renaming Logical Objects Manually
  • Creating Simple Measures
  • Building the Presentation Layer of a Repository
  • Creating a Subject Area
  • Creating Presentation Tables

Day 2

  • Testing and Validating a Repository
  • Checking Consistency
  • Disabling Cache
  • Setting up Query Log
  • Managing Logical Table Sources
  • Adding a New Logical Table Source
  • Creating Presentation Layer Objects
  • Loading the Repository
  • Checking the Query Log
  • Creating Calculation Measures
  • Checking the Query Log
  • Creating Logical Dimensions with Level-Based Hierarchies
  • Creating a Logical Dimension for Product
  • Creating Logical Levels
  • Associating Logical Columns with Logical Levels
  • Setting Logical Level Keys
  • Creating a Logical Dimension for Time
  • Associating Time Logical Columns with Logical Levels

Day 3

  • Creating a Logical Dimension for Customer
  • Setting Aggregation Content for Logical Table Sources
  • Creating Level-Based Measures
  • Opening the Repository in Offline Mode
  • Creating Level-Based Measures
  • Creating Logical Dimensions with Parent-Child Hierarchies
  • Opening the Repository in Offline Mode
  • Importing Metadata and Define Physical Layer Objects
  • Creating Logical Table and Logical Columns
  • Creating a Parent-Child Logical Dimension
  • Creating Presentation Layer Objects
  • Creating Logical Dimensions with Ragged and Skipped-Level Hierarchies
  • Importing Metadata and Define Physical Layer Objects
  • Creating Logical Table and Logical Columns
  • Creating a Ragged/Skipped Levels Logical Dimension
  • Creating Presentation Layer Objects
  • Using Aggregates

Day 4

  • Creating New Logical Table Sources
  • Setting Aggregate Content
  • Using Initialization Blocks and Variables
  • Creating an Initialization Block
  • Creating Variables
  • Creating a Measure

Day 5

  • Creating an Analysis and Using the Analysis Editor
  • Filtering, Sorting, and Saving your Analysis
  • Creating Selection Steps for your Analysis
  • Formatting and Adding Totals to your Analysis
  • Adding a Graph to an Analysis
  • Enhancing an Analysis by Adding a Graph
  • Formatting the Graph
  • Working with Pivot Tables, and Master-Detail Linking
  • Creating an Analysis with a Pivot Table View
  • Formatting a Pivot Table and Adding Calculation

Day 6

  • Creating a Master-Detail Linking
  • Adding Performance Tile to an Analysis
  • Adding a Simple Trellis to an Analysis
  • Working with Other View Types
  • Creating a Narrative View
  • Creating Column Selector and View Selector Views
  • Building Dashboards
  • Exploring and Editing My Dashboard
  • Creating a Dashboard
  • Editing a Dashboard
  • Saving a Customized Dashboard and Setting Preferences
  • Exporting the Dashboard to Excel Spreadsheet
  • Prompting to Filter Analysis
  • Creating a Named Dashboard Prompt
  • Creating a Column prompt
  • Creating a Variable Prompt