Oracle Business Intelligence Enterprise Edition (OBIEE) Training

• Install and configure the OBIEE.
• Use Data Model Editor for creating Data models.
• Create Logical Tables, Joins, and columns.
• Gain knowledge on concepts of data warehouse and Business intelligence.
• Use Enterprise Manager to enable and disable cache.
• Create and work with KPIs, scorecards, and action links.
• Design and develop the interactive Oracle BI dashboards.
• Design and develop the logical business model using OBIEE.

• Recorded Videos After Training
• Digital Learning Material
• Course Completion Certificate
• 24x7 After Training Support

• Software Engineers
• Mainframe Professionals
• Business Intelligence Professionals
• Project Managers
• Database Analysts
• Application developers
• Data warehouse developers
• Server Architects

• Anyone who is interested in learning Oracle Business Intelligence Enterprise Edition

• Multisoft Systems provides training certification after completion of Oracle Business Intelligence Enterprise Edition (OBIEE) Certification Online Training Course.

Module 1. Repository Basics

• Exploring Oracle BI architecture components 
• Exploring a repository's structure, features, and functions 
• Using the Oracle BI Administration Tool 
• Creating a repository 
• Loading a repository into Oracle BI Server 
• Installing the BI Client software 

Module 2. Building the Physical Layer of a Repository

• Importing data sources 
• Setting up Connection Pool properties 
• Defining keys and joins 
• Examining physical layer object properties 
• Creating alias tables 
• Printing the physical layer diagram

Module 3. Building the Business Model and Mapping Layer of a Repository

• Building a business model 
• Building logical tables, columns, and sources 
• Defining logical joins 
• Building measures
• Examining business model object properties 
• Printing the business model and mapping layer diagram

Module 4. Building the Presentation Layer of a Repository

• Exploring presentation layer objects 
• Creating presentation layer objects 
• Modifying presentation layer objects 
• Examining presentation layer object properties 
• Nesting presentation tables 
• Controlling presentation layer object visibility

Module 5. Testing and Validating a Repository

• Checking repository consistency 
• Turning on logging 
• Uploading the repository through Enterprise Manager 
• Executing analyses to test the repository 
• Inspecting the query log

Module 6. Managing Logical Table Sources

• Adding multiple logical table sources to a logical table 
• Specifying logical content

Module 7. Adding Calculations to a Fact

• Creating new calculation measures based on logical columns 
• Creating new calculation measures based on physical columns
• Creating new calculation measures using the Calculation Wizard 
• Creating measures using functions

Module 8. Working with Logical Dimensions

• Creating logical dimension hierarchies 
• Creating level-based measures 
• Creating share measures 
• Creating dimension-specific aggregation rules 
• Creating presentation hierarchies 
• Creating parent-child hierarchies 
• Creating ragged and skipped-level hierarchies

Module 9. Enabling Usage Tracking

• Creating the usage tracking tables 
• Setting up the sample usage tracking repository 
• Tracking and storing Oracle BI Server usage at the detailed query level
• Using usage tracking statistics to optimize query performance and aggregation strategies

Module 10. Using Model Checker and Aggregates

• Using Model Check Manager 
• Modelling aggregate tables to improve query performance 
• Using the Aggregate Persistence Wizard 
• Testing aggregate navigation 
• Setting the number of elements in a hierarchy

Module 11. Using Partitions and Fragments

• Exploring partition types 
• Modelling partitions in an Oracle BI repository

Module 12. Using Repository & Session Variables

• Creating session variables 
• Creating repository variables 
• Creating initialization blocks 
• Using the Variable Manager 
• Using dynamic repository variables as filters

Module 13. Modeling Time Series Data

• Using time comparisons in business analysis 
• Using Oracle BI time series functions to model time series data

Module 14. Modeling Many-to-Many Relationships

• Using bridge tables to resolve many-to-many relationships between dimension tables & fact tables

Module 15. Setting an Implicit Fact Column

• Ensuring the correct results for dimension-only queries 
• Selecting a predetermined fact table source 
• Specifying a default join path between dimension tables

Module 16. Security

• Exploring Oracle BI default security settings 
• Creating users and groups 
• Creating application roles 
• Setting up object permissions 
• Setting row-level security (data filters) 
• Setting query limits and timing restrictions

Module 17. Cache Management

• Restricting tables as non-cacheable 
• Using Cache Manager 
• Inspecting cache reports 
• Purging cache entries 
• Modifying cache parameters and options 
• Seeding the cache