Demo Video

watch OBIEE Demo Video

About Trainer

  • Trainer Information

OBIEE 11g along with Data warehousing Implementation Approaches.

  • 11+ Years of IT Overseas and Domestic Experience in IT Industry
  • Worked on multiple domains with various Big MNC’s
  • Certified OBIEE Professional
  • Completed 30+ batches teaching around 200 students

The Course provides all the Pre-requisites for learning OBIEE 11g. We provide Data warehousing Implementation Approaches as a complementary module along with OBIEE 11g.

The OBIEE training includes all real time industry use cases spanning across multiple domains.

Course Outlines

OBIEE Course Curriculum

Click Here for a Complete Course Contents

  • Course Duration : 30 Hours
Data Warehouse concepts
  • Need of Data Warehouse
  • Data Warehousing
  • Data Warehouse Architecture
  • Types of Tables
  • Schema and types of Schemas
  • Data Mart?
  • Data Warehousing Approaches
Installation
  • Installing OBIEE 12c on Windows
  • Installing OBIEE 12c on Linux
  • Migrating RPD and Web-Cat from lower versions to 12c
OBIEE Introduction
  • Why Oracle BI?
  • What is Oracle BI?
  • History of Oracle BI
  • Oracle BI architecture Lower Versions Vs 12c
  • Oracle BI components Lower Versions Vs 12c
OBIEE Administration
  • Repository Basics
  • Building the Physical Layer of a Repository
  • Building the BMM Layer of a Repository
  • Building the Presentation Layer of a Repository
  • Testing Repository
  • Working with Multiple Logical Table Sources
  • Adding Calculations to Fact Table
  • Creating Dimensional Hierarchies & Level based measures
  • Using Aggregate Tables
  • Testing Repository
  • Parent Child Hierarchies
  • Ragged and Skipped hierarchies
  • Using Lookup Table
  • Using Partitions and Fragments
  • Variables (Repository, session, presentation &Request)
  • Modelling Time Series Data & Time based Measures
  • Configuring Many to Many Relationships (Bridge &Helper Table)
  • Deploying Oracle Bi application to multiple countries
  • Localizing Oracle BI Metadata
  • Localizing Oracle BI Data
  • Setting Implicit Fact Column
  • Third Party Reporting Tool Integration
  • Creating Repositories from Multi-Dimensional Data Sources
  • Administering Usage Tracking
  • Multi-User Development Environment (MUDE)
  • Utilities
  • Cache Management
  • Repository Design Principles
  • Disconnected Analytics
  • Alias, Circular Joins & Opaque Views or select tables
Presentation Services or Analytics
  • Introduction to presentation Services
  • Introduction about EM, CONSOLE, ANALYTICS, XMLPSERVER…etc.
  • What is Web Catalog & instance config file
  • Shared Folders, My folders, Shared Filters, My Filters, My Briefing Books
Analytics Reporting
  • Working with OBI Answers
  • OBI Column Properties
  • Drill
  • Navigation
  • Conditional formatting
  • OBI Formulas
  • OBI Filters
  • OBI Sorting
  • OBI Views
  • OBI Request Level Prompts
  • Cascading Prompts
  • Combining with Similar Request
  • Direct Database Requests
OBIEE Dashboards
  • Oracle Business Intelligence Interactive Dashboards
  • Dashboard Objects
  • Section
  • Link or Image
  • Column
  • Embedded Content
  • Text
  • Folder
  • Guided Navigation Link (Static, Conditional and section)
  • Briefing Book Navigation Link
  • Advanced Reporting, Master Detail Linking
  • Simple Action Links
  • Advanced Action Links
  • Dashboard Prompts
  • Types of Dashboard Prompts
  • Page level prompts
  • Dashboard level prompts
  • Presentation Variables
  • Request Variable
  • Scorecards
  • KPI
OBIEE Delivers
  • Introduction to Oracle BI Delivers
  • Developing IBOTS
  • Configuring delivery devices
  • Adding delivery profiles
  • Building Alerts
Job Manager
  • Configuring Job Manager
  • Monitoring Scheduled requests
Oracle BI for Microsoft Office
  • Introduction to Oracle BI for Microsoft Office
  • Working with Oracle BI content in Microsoft Office applications
Catalog Manager
  • Documentation of Web Catalog
  • Deploying Development to test or test to prod
OBIEE Security
  • Authentication and Authorization
  • Creating Users and Groups
  • Object Level Security
  • Data Level Security
  • Presentation Catalog Permissions (Full Control, No Access, Change/Delete, Read, Traverse Folder)
  • Presentation Catalog Privileges (Granted, Denied)
Live Tasks
  • Gathering Requirement
  • Understanding & Analysing Requirement
  • Developing Business Specification Document
  • Developing High Level Design Document
  • Developing Low Level Design Document
  • Following Unique Coding Standards
BI Publisher
  • Introduction to BI Publisher or XML publisher
  • Integrating database
  • Integrating Oracle BI Presentation server
  • Integrating Oracle BI Discoverer
  • Configuring Scheduler
  • Develop BI Publisher Templates using OBI Answer Request
  • Develop BI Publisher Templates using OBI Subject Areas
  • Develop BI Publisher Templates Directly from Data Base
  • Scheduling BI Publisher templates

Course Info

Learn OBIEE

Oracle Business Intelligence Enterprise Edition (Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine.
Oracle Business Intelligence online training is designed for every learner to bring greater business visibility and insight to a wide variety of users.
OBIEE training provides a full range of business intelligence capabilities that allow you to:

  • Collect up-to-date data from your organization
  • Present the data in easy-to-understand formats (such as tables and graphs)
  • Deliver data in a timely fashion to the employees in your organization
  • These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.
OBIEE online training provides a solid foundation on OBIEE 11g step-by-step procedures for building and verifying the three layers of an Oracle BI repository.
Participants will learn to design the Repository, Creating Answers/Analysis Requests, and Interactive Dashboard, Delivers, OBIEE 11g/Fusion Middle ware Security and OBIEE-BI Publisher integration.
Oracle Business Intelligence course is designed for those professionals who are looking for Great career as Consultant in BI Technology.

OBIEE Job Trends

OBIEE USA Job Trends<
OBIEE India Job Trends<