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