Showing posts with label CERTIFICATION. Show all posts
Showing posts with label CERTIFICATION. Show all posts

Monday, May 20, 2013

Achieved OBIEE 11g Foundation Suite Implementation Certification? What next?

Oracle's OBIEE certification path has four different exams, all leading to independent certifications. Oracle's exam 1Z0-591 is the key exam to become Oracle 11g certified implementation specialist. It just has one exam that will get the certification required. The screen shot below shows the basic details of this exam:


The above page can be accesed by clicking here (follow this link two times, it only works the second time from what I have noticed)

Once this is cleared, Oracle provides three other complementary certifications, which will add value to any one looking to get more out of the certifications:

1. First is the  "Oracle Database 11g Data Warehousing Essentials" ; Exam Number: 1Z0-515;




Above page can be accessed by clicking here

This really requires working on database side, data mining and Exalytics. It complements OBIEE 11g exam# 1Z0-591. Both #591 and #515 are independent certifications. Note: passing score for this exam is 78%, which is a lot more than 63% for #591.

2. Next exam is "Oracle Business Intelligence Applications 7 for CRM Essentials"; Exam number 1Z0-524



 Above page can be accessed by clicking here

This exam includes BI Apps components, i.e. out of the box mappings, DAC, RPD etc and required knowledge of CRM BI Apps.

3. Next is the "Oracle Business Intelligence Applications 7 for ERP Essentials"; exam number 1Z0-525


Above page can be accessed by clicking here

This exam is some overlap in topics with #524, as it also includes BI Apps. But this one focuses on eBusiness Suite side of BI Apps.

Depending of what you are working on currently, any of these complimentary exams can be given without any specific exam order, as they are all independent certifications. Hope this information helps.

Tuesday, March 26, 2013

PDF dumps for OBIEE 11g Certification exam

I have compiled a list of PDFs that I used for preparing for certification exam. To download the same, follow the steps here:

1. Visit the Oracle documentation page:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/documentation/index.html

2. Click view library - This will open up HTML documentation, which is not very convinient to read, especially for offline reading, so we look for pdf documents.

3. Click Installation Guide - Stop - Once you see table of contents, on the top right side, click on 'PDF' and save a copy. Thats it, you got it.




4. Hit back, and repeat above steps for following documents:

Enterprise Deploymentet Guide
UserGuide
RPDGuide
AdminGuide

These are the 5 documents that I feel are most important to prepare for certification. There are no other dump files for certification, good luck.


Revision: For those of you just starting out OBIEE, Oracle has a live demo environment, which could help you look at the tool before you even start. Follow the post below to view more details:

http://kumar-oraclebi.blogspot.com/2014/01/obiee-live-demo-from-oracle.html


Sunday, March 10, 2013

Great news!!! I cleared OBIEE 11g certification

This past Friday, I cleared OBIEE 11g certification (scored 86%). I was relieved at last. Well, as expected exam was not straight forward, and requires practical experience and good knowledge base of concepts including data warehousing concepts.

Don't be surprised, as there are non scoring questions in the exam, which Oracle specifies before the exam begins. So you may feel you have answered minimum passing questions correctly, yet, overall score may be less. In terms of time allowed, I felt there was plenty of time to attempt all questions, in fact I was done with the exam in under 75 min (out of 120 mins) which includes reviewing questions I marked for later.

My advise to any applicant would be to study basic concepts thoroughly, and read all 11g documents (installation, configuration, RPD and users guide etc).. pretty much everything, unless of course you are lucky enough to be sponsored by your employer for instructor led training meant for certification.

In the results, Oracle specified topic, where you incorrectly answered, so that we can go and pick up those topics later.

Hope this helps.. Good luck.

Update: For anyone interested in the link to Oracle's certification page or to knowing more about complementary Oracle certifications can look at my following blog post about certification paths:

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



~~Arun

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.