Candidate should learn the topics in OBIEE(Oracle Business Intelligence Enterprise Edition)

Candidate should have the basic database knowledge and ETL(Extraction,Transformation and Load) process(Any tool of ETL),then learn the concepts of OBIEE. OBIEE is a reporting tool,to generate the reports for data analysis.This is reporting tool used most frequently. The concepts of OBIEE includes 

I. Administrator.

• OBIEE and BI Server Architecture.
• Data warehouse Basics.
• Repository basics, structure, features, and functions - Using BI Admin tool.
• Building a Physical Layer (Data sources, connection pool, tables, Keys, Aliases and opaque views).
• Best Practices to follow while building a Physical Repository.
• Building a Business Model (Logical Table, Column, Sources).
• Building a time dimension hierarchy and other dimensions.
• Defining logical models and building measures.
• Learning the Business Model properties.
• Building the presentation layer in Repository.
• Create Presentation layer objects and setting up appropriate properties.
• Testing and validating a repository.
• Deploying the repository to the BI Server.

II. Answers

• Introduction to presentation services  or Analytics - Answers, Dashboards and Delivers.
• Creating reports, filters, formulas, prompts in Answers.
• Exploring Charts and graphs in Answers.
• Creating multiple views of the same report.
• Creating pivot tables and other views.
• Dashboard basics and exploring dashboard editor.

III. Security - Administrator

• Introduction to Security in BI Admin tool and presentation server Administration.
• Creating Users and Groups. Permissions for users and groups.
• Setting up different connection pools, Query limits and timing restrictions.
• Variables – Repository, Session and Presentation Variables.
• Advanced concepts in presentation server.
• Using variables during design and developments.