Friday, January 18, 2013

OBIEE 11g Certification Exam

To achieve OBIEE 11g certified profession status, looks like there are two levels of OBIEE 11g certifications available:

First: Exam ID 1Z0-591 - Oracle Business Intelligence Foundation Suite 11g Essentials
  • 120 mins
  • 75 Que
  • 63% passing score (48 questions)
  • The exam questions are based on version OBIEE 11.1.1.5


   
Docs are available: http://docs.oracle.com/cd/E23943_01/bi.htm

The doc link is not going to help much, unless someone wants to read 2.5 GB of documentations. Following topics might help to prepare for exam (ofcourse experience should make up for lack for complete reading):

Exam Topics

Oracle BI and EPM System Overview                                                                                                         
·         Describe how OBIEE addresses business intelligence challenges
·         Describe the Oracle Business Intelligence Enterprise Edition (OBIEE) products
OBI EE Architecture
·         Describe major components of the OBIEE architecture
·         Describe the function of each component
Oracle BI Installation
·         Describe the Installation Architecture for OBI EE
·         Explain system requirements, supported platforms and installation pre-requisites
·         Install OBIEE
OBI EE User Interface Overview
·         Describe the components of OBI EE User Interface
·         Perform Oracle Analysis to construct, modify, and save BI requests
·         Build Dashboards
·         Create BI Delivers
Dimensional Modeling
·         Describe the differences between Transactional and Analytical Systems
·         Describe Data Warehousing
·         Build Dimensions, Facts and Hierarchies
·         Explain Dimensional Modeling
Oracle BI Repository Overview
·         Describe the three layers of the OBI Repository
·         Use the Administration Tool to view and modify the repository
Build Basic Repository
·         Define a System Data Source Name (DSN) for a data source
·         Build the Physical layer of the Repository
·         Build the Logical layer of the Repository
·         Build the Presentation layer of the repository
Repository Testing and Deployment
·         Describe techniques for testing a repository
·         Validate and test a repository
Complex Repository Modeling
·         Describe Derived Metrics and its use
·         Configure Derived Metrics based on existing logical columns
·         Configure Derived Metrics based on physical columns
Advanced Repository Modeling
·         Create Data Partitioning
·         Create Segmentation of Data
·         Create Time Series Data
Building a Repository with Multiple Sources
·         Add multiple sources to an existing logical table source for a dimension in the business model
·         Add a second table source to a dimension in the business model
Hierarchies and Level Based Measures
·         Create a dimensional hierarchy
·         Use level-based measures
·         Create a rank measure
·         Describe Aggregate tables and the purpose they serve
·         Create Aggregate tables in the OBI repository
Using Variables
·         Explain session variables
·         Describe repository variables
·         Describe initialization blocks
·         Implement a dynamic repository variable
Implementation Methodology and Best Practices
·         Describe the implementation phases
Oracle Business Intelligence Enterprise Edition Security
·         Describe authentication and authorization
·         Describe the different levels at which security is enforced
·         Configure security using Security Manager
·         Configure Query Governing controls
Cache Management & Performance Tuning
·         Explain the purpose of cache in OBI EE
·         Configure caching and manage cache files
·         Develop caching strategies
·         Describe the request and data flow in OBI EE
MS Office Integration
·         Use MS Office Plug-In for OBI EE
·         Describe the required components to enable office integration
·         Install and configure MS office server and client for OBI EE
Spatial Integration
·         Explain Spatial Intelligence and Integration
·         Add Map based visualization to OBI EE
Write Back within OBI EE
·         Describe Write Back capabilities
·         Configure Write Back with OBI EE
Essbase Integration
·         Implement Essbase as a Data Source
·         Configure BI Server Metadata for Essbase
·         Explain Essbase Integration

Next Level exam is:
 
Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist

 http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:OBIFS11gOPN

The certification covers skills such as: installing OBIEE, building the BI Server metadata repository, building BI dashboards, constructing ad hoc queries, defining security settings and configuring and managing cache files. The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.

5 comments:

  1. hello does anybody have the actual datadump for OBIEE 11G's SUPPLIER2?

    If u do please email me chuose@gmail.com

    ReplyDelete
  2. what do u mean the next level is 'Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist'??. There is no next level as I confirmed it with an Oracle expert from Oracle university. There is only one exam that is 1z0-591 which should qualify you to be OBIEE certified expert.

    ReplyDelete
  3. Looks like oracle has cleaned up its certification paths from what they were in Jan 2013. As of now, there are three complementary exams, which might be of interest to you. I have posted more details to the post below:

    http://obiee911.blogspot.com/2013/05/achieved-obiee-11g-foundation-suite.html

    Hope this helps.

    ReplyDelete
  4. Does anyone have a practice exam for OBIEE 11g they could share?

    ReplyDelete
  5. Hi can someone help me with the right link to get practice question for OBIEE 1z0-591 Certification exam? please send the link to njiatemlefac@yahoo.com

    ReplyDelete