OBIEE Training

OBIEE Training

  • Course Overview

OBIEE Training is a Business Intelligence tool of Oracle. It has very good market value and many of the customers are implementing this solution as Oracle is investing lot of money and Time to be the best BI Tool that is currently available in the market. With the acquisition of many products like Hyperion, Essbase,  siebel and Endeca, oracle is incorporating all those best features as a process of consolidation.

OBIEE Training is the BI solution for the Fusion Middleware platform. all the customers implementing oracle fusion, will find a value in OBIEE implementation in terms of saving and features. As a Learner, It adds a great potential in the market to get a job and get better billing rate. We provide end to end solution in OBIEE Training including the advanced features and integration of different sources.

  • what do you Learn

  • Build and execute analyses to test and verify a dimensional business model
  • Use the Oracle BI Administration Tool to administer Oracle BI Server
  • Use the Oracle BI Administration Tool to build, manage and maintain an Oracle BI repository
  • Build a dimensional business model to address business intelligence requirements
  • Build and use views and graphs in analyses
  • Create and work with KPIs and scorecards
  • Create and modify Oracle BI dashboards
  • Administer objects in the Presentation Services Catalog
  • Build analyses and dashboards

Key features

  • 32 hours of instructor-led training
  • 32 hours of high-quality eLearning content
  • 5 simulation exams (250 questions each)
  • 8 domain-specific test papers (10 questions each)
  • 30 CPEs offered
  • 98.6% pass rate

OBIEE Training                                                                                 Duration :- 4 Days

Data warehousing overview

  • Basics of Data Warehousing
  • What is OLTP and OLAP?
  • Difference between OLTP and OLAP
  • Advantages of OLAP
  • What is Data Marts and ODS?

Dimensional Modeling Overview

  • Introduction to Dimensional Modeling
  • What are Facts and Dimensions?
  • Star schema and Snowflake schema

Introduction to Business Intelligence

  • What is Business Intelligence
  • Where BI tools are Used
  • Why the Oracle Business Intelligence
  • Advantages
  • Architecture, Components
  • Clients – Answers, Delivers, Dashboards and Web administration,
  • Servers- Oracle BI server, Presentation, Scheduler server

Server Architecture

Repository Basics

  • What is Meta data?
  • Creating a Repository using BI Administration Tool
  • Physical, Business Model and Mapping, and presentation layers
  • Properties of repository objects

Building Physical Layer of a Repository

  • Objects of Physical Layer
  •  DSN for a data sources
  • Build physical layer

Building business Model mapping layer

  • Objects of BMM layer
  • Building Business model (creating logical tables, columns, joins)
  • Creating simple measures

Building presentation layer

  • Objects of presentation layer
  • Properties of the presentation layer
  • Build presentation layer

Testing and validating Repository

  • Checking repository consistency
  • Checking Global Consistency
  • Inspecting Oracle Answers inspecting SQL
  • Inspecting log files(Nqquery.log,NQSserver.log)

Adding multiple sources to dimension

  • De-normalizing tables structures in database design
  • Adding multiple sources to existing logical tables source
  •  Adding second table sources

Adding calculations to fact

  • Calculation measures on the basis of physical and logical columns
  •  Using Calculation wizard

Creating dimensional hierarchies and level based measures

  • Creating dimensional hierarchies
  • Use level based measures
  • Create Rank and Share measures

Using aggregation

  • Importing Aggregated Tables into Repository
  • Modeling aggregate tables to speed processing

Using variables

  • Presentation Variables
  • Repository variables
  •  Session variables
  • Initialization Blocks

Multiuser Environment (MUD)

  • Overview on Multiuser Environment (MUD)
  • How to create projects in MUD
  • Checkout and checkin of projects

Modeling time series data

  • Types of SCDS
  • Using of time series functions

Modeling extension tables

  • Purposes of extension tables
  • Modeling extension tables for fact and dimensions

Oracle BI Security

  • Security at object and data level
  • Creating users and User groups
  • Assigning permissions to users
  • Setting Query limits and timing restrictions
  • Authenticating using an external database

Cache management

  • Purge cache and event handling tables
  • Making the table cacheable
  • Setting of cache in NQSCONFIG.INI file

Oracle BI Presentation services

Working with Oracle BI Answers

  • Building Business Requests using Answers
  • Adding filters to Business requests
  • Adding Column Filter Prompts in Answers
  • Views and charts in requests

Creating Oracle Intelligence Dashboards

  • Creating dashboard pages using report requests
  • Creating dashboard prompts
  • Configuring guided navigation links
  • Adding content to dashboard
  • Conditional links and conditional section

Administering OBI Presentation Catalog

  • Using catalog management to maintain web catalog
  • Creating catalog groups, issuing privileges etc

You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

1. Online ,By deposit the mildain bank account

2. Pay by cash team training center location

Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.
Venue is finalized few weeks before the training and you will be informed via email. You can get in touch with our 24/7 support team for more details. Contact us Mob no:- 8447121833, Mail id:  [email protected] . If you are looking for an instant support, you can chat with us too.
We provide transportation or refreshments along with the training.
Contact us using the form on the right of any page on the mildain website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

Find This Training in Other Cities:-

Kolkata,Bangalore,Mumbai,Hyderabad,Pune ,Delhi,Chennai,

Mildain Solutions/Corp Office Delhi(NCR)

HeadQuarter Office:
Plot No 17, C Block Market, Sec 36,
Noida (U.P.)-201301(India)
 
Bangalore office:
Mildain Solutions,
No 7 & 8,Krishna Reddy Layout,
Domlur(Bangalore) 560071(India)
Hyderabad office:
Mildain Solutions
 #20/B/C/3/1,
GANESH GHR & MSY PLAZA,
VITTAL RAO NAGAR,
MADHAPUR,HYDERABAD-500081,

Mumbai office:

Mildain Solutions
5th Floor, Block B, Godrej IT Park,
Pirojshanagar, LBS Marg, Vikhroli West,
Mumbai, Maharashtra
 (+91) 1204326873
(+91) 8447121833
Contact Us

Your Name (required)

Your Email (required)

Contact Number

Course

Location

Query

Drop Us A Query

Your Name (required)

Your Email (required)

Contact Number

Course

Location

Query

REVIEWS

good session..!!
will be useful to improve my technical Knowledge..
Parveen
The concepts of the Instructor was mind-blowing…Lots of Industry examples…Very well organized…
Ajay Nunna
Nice session…!! enjoyed learning new things
Gaurav
Really good training. It helped me to clear a lot of doubts which were present in my mind for a long time.
Raghav
“ The course content is very good and satisfactory. The trainer is also good with his teaching abilities.”
Sameer
Apply the knowledge in understanding the new 11b framework setup in our system.
Apply the skill in day to day operational maintenance of our IT infrastrututre.
Saleel