How to get started with OBIEE

I always come across people who are interested in learning OBIEE, and they become curious to know about BI. They always ask me how to learn OBIEE.

My first answer is to get familiar with Data Warehousing concepts. A good understanding of the following is needed to succeed as an OBIEE Developer:

- Database/ Data Warehouse/ Data Mart

- SQL

- Data Modeling

- OLTP & OLAP Systems

-  Star & Snowflake Schema

- Facts & Dimensions

- Slowly Changing Dimension

- Other DW concepts- Hierarchy, Confirmed Dimension, Bridge Table, Implicit Fact, Fact less Fact, Aggregate table and more

A lot can be learned from Wikipedia as well, some of the topics about BI and Data Warehousing are very well explained.

Read The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling to build an understanding of dimensional modeling.

Once you are through with all of the above start working on Oracle by Examples http://apex.oracle.com/pls/apex/f?p=9830:bi:1287755467524366::NO:::

Join OTN to gain from other’s experiences. Please follow Forum Etiquettes. I would suggest start reading the questions which have been answered in the forums.

And of course, there are so many blogs on OBIEE that can help you develop your OBIEE skills. So, join me in the journey of OBIEE.

Cheers!

Deepak