9740413132 | 9341080909 viinfotech999@gmail.com

OBIEE Training

Vi INFOTECH is one of the top quality OBIEE training institutes in Bangalore with highly experienced and skilled trainers. Vi INFOTECH Bangalore also offers placement assistance for students who enrolled in Advanced and Oracle OBIEE Training Courses. We offer advanced OBIEE, Oracle Business Intelligence, Security in OBIEE

OBIEE Training Institute

Become an Expert in OBIEE Programming with Vi INFOTECH OBIEE learning programmes. Main highlights of our OBIEE Programming, OBIEE, Security in OBIEE, OBI ARCHITECTURE Training in Bangalore (BTM Layout) include Intensive Practical Training, Advanced Learning Materials & Tools, Friendly Classrooms etc

OBIEE Course

What you'll learn

OBIEE Reporting

OBIEE Course Reviews

The course is practical oriented. Good place for learning.

OBIEE Course Content

DATAWAREHOUSING 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
Star Schema Design & Confirmed Dimension, Fact less Fact Table, Types of Facts
Slowly Changing Dimensions( SCD )

OBIEE Installation & Configuration

Installation of Database
Installation of OBIEE Meta Data using Repository Creation Utility
Installation and Configuration of OBIEE
Testing of Sample Reports and RPD
Configuration of BI Sample schemas

Introduction to Oracle Business Intelligence

What is BI ?
What are the other BI tools ?
What is OBIEE ?
History of OBIEE ?
What you are going to learn in OBIEE ?
Introduction on OBIEE Repository Design & Development
Introduction on OBIEE Answers and Dashboards

OBI ARCHITECTURE

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

OBI COMPONENTS

OBI Administration Tool
OBI Answers
Intelligence dashboards

REPOSITORY BASICS

Sample Request Processing
Using the OracleBI Administration Tool
Repository Directory
Repository Files ( Initialization files and log files)
Creating a repository
Connection Pool
Repository Modes ( ONLINE and OFFLINE )
Physical Layer
Business Model & Mapping Layer
Presentation Layer
Presentation Catalogs, Folders and Columns

BUILDING THE PHYSICAL LAYER OF A REPOSITORY

Defining an ODBC System DSN
Setting up connection pool properties
Importing data sources ( Physical Schema )
Verifying the import
Defining physical keys and joins
Creating alias and select tables

BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF A REPOSITORY

Creating the logical business model
Creating the logical tables, columns, and sources
Defining logical joins
Adding Calculation to a Fact Table
Building measures

BUILDING THE PRESENTATION LAYER OF A REPOSITORY

Creating a new Presentation Catalog
Modifying Presentation layer objects
Rename tables
Reorder Table

TESTING AND VALIDATING A REPOSITORY

Checking repository consistency
Defining a repository in the initialization file
Testing a repository using Oracle BI Answers
Message Severity
viewing Server Logs

ADDING MULTIPLE LOGICAL TABLE SOURCES

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

ADDING CALCULATIONS TO A FACT TABLE

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

CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES

Creating dimension hierarchies
Creating level-based measures

USING VARIABLES & INITIALIZATION BLOCKS

Understanding different types of Variables
Creating Repository Variables and session variables and using them in the OBIEE environment
Creating and setting Presentation variables in obiee reports and dashboards

CREATING TIME SERIES MEASURES

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

Security in OBIEE

Oracle Platform Security Service
Exploring Oracle BI default security settings
Creating users and groups

Working with Oracle Business Intelligence Answers

Introduction to Oracle BI Answers
Working with requests in Oracle BI Answers
Using advanced formatting
Creating report Level Hierarchy

Filtering Requests in Oracle Business Intelligence Answers

Introduction to filters in Answers
Adding filter prompts to requests
Using saved requests as filters

Building Views and Charts in Requests

Introduction to Answers views and charts
Creating and editing charts
Performing common view tasks
Creating a column Selector
Creating View Selector

Showing Results with Pivot Tables

Introduction to pivot tables
Formatting pivot tables
Setting aggregation rules and building formulas

Creating Oracle Business Intelligence Interactive Dashboards

Introduction to Interactive Dashboards and pages
Adding Objects to Dashboard
Creating Dashboard prompts
Embedding content in an Interactive Dashboard
Usage of presentation variables

OBIEE Advanced Concepts : Master-Detail linking ,KPI's etc

OBIEE Environment in different software companies
Explain the Real time OBIEE Environment in the software Companies
Explain the different support groups which are part of OBIEE project
The way OBIEE project is developed
Roles and Responsibilities of the Developer,Lead, Testers,etc
OBIEE Requirement Analysis
OBIEE Design and Development
OBIEE testing dev and uAT
OBIEE Migration
OBIEE Infant Care

Star Rating

4.9 average based on 54 reviews.