OBIEE Training

Oracle Business Intelligence Foundation Suite (OBIEE+ and Essbase), developed by Oracle is a complete, open, and architecturally unified business intelligence system. It is designed for the enterprise that enables reporting, ad hoc query and analysis, online analytical processing (OLAP), dashboards, and scorecards. The suite provides users with accurate & consistent insight by managing all enterprise data sources, metrics, calculations, definitions, and hierarchies in a Common Enterprise Information Model.

OBIEE Online Training

OBIEE is known to be the most emerging reporting tool ever since Oracle has taken over Siebel. Offered by BestOnlineTrainers, this training gives you complete knowledge of OBIEE in a phased manner.

OBIEE Online Training Course Details

Module 1: Data Warehousing Concepts

Introduction and Definition
Sources, Transformations and Targets (Architecture)
Data Extraction, Data Transformations and Data Loading (Data Acquisition Process)
Data Warehousing Approaches
Staging Area, Metadata, Repository and Data Mart
Differences between OLTP and OLAP (DSS) Systems
Operational Data Store (ODS)
Business Intelligence

Module 2: OBI Architecture

Clients
OBI Presentation Services
OBI Server
OBI Repository (.rpd)
Data Sources

Module 3: OBI Components

OBI Administration Tool
OBI Answers
Intelligence Dashboards

Module 4: Repository Basics

Oracle Business Analysis Warehouse
DAC and Informatica Server
Informatica Server ETL
Sample Request Processing
Using the OracleBI Administration Tool
Repository Directory & Files

Module 5: Building the Physical Layer of a Repository

Defining an ODBC System DSN
Setting up Connection Pool Properties
Importing Data Sources (Physical Schema)
Defining Physical Keys and Joins
Creating Alias and Select Tables

Module 6: Building the Business Model & Mapping Layer

Creating the Logical Business Model
Creating Logical Tables, Columns, and Sources
Defining Logical Joins
Adding Calculations to Fact Tables & Building Measures

Module 7: Building the Presentation Layer

Creating a New Presentation Catalog
Modifying Presentation Layer Objects
Rename and Reorder Tables

Module 8: Testing and Validating a Repository

Checking Repository Consistency
Defining Repository in the Initialization File
Testing with Oracle BI Answers & Viewing Server Logs

Module 9: Level-Based Measures & Aggregates

Creating Dimension Hierarchies
Creating Level-Based Measures
Creating & Using Aggregates to Improve Performance

Module 10: Advanced Topics & Real-World Use Cases

Creating Dynamic Repository Variables
Executing Direct Database Requests
Using Time Series Functions in Analysis
Security for Groups & Users, Oracle BI Answers & Dashboards
Filtering, Creating Views, Charts, and Pivot Tables
Capstone Project: BI Implementation Scenario

Target Audience

Business Intelligence professionals looking to hone skills with OBIEE
Students and individuals pursuing a career in Business Intelligence
Project managers, DBAs, data modelers, developers interested in BI solutions
IT professionals seeking cross-training into Oracle BI stack

Why Choose Best Online Trainers?

Instant Access: Get instant access to self-paced training after signup.
Streaming video recording: Watch lessons any time at your schedule, free recording.
Exercises: Practical exercises help you test what you are learning as you go.
Free Demo: Sign up for free demo to check whether the course is right for you and interact with the faculty live.
Experienced Trainers: We only hire the industry’s best trainers
Live free interactive web sessions: Ask questions and clarify your career prospects any time after you complete the course.
Structured Curriculum Schedule: Progress with complete daily interactive lessons and assignments.
Faculty Mentoring: Turn in daily and weekly homework for personalized feedback from faculty.
Virtual Office Hours: Live interaction with the faculty and other students around the world.
Hands on Live Projects: Work on real-world projects with 100% faculty guidance and ratings.

Trainer Profile

Well Experienced Trainers with extensive industry knowledge
10+ years industry and real-project experience in Oracle BI solutions
Proven corporate & academic training backgrounds
Passionate mentor, interactive live sessions available

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K