Thursday, September 3, 2009

Get Started OBIEE

Get familiar with the basic terminology:

http://en.wikipedia.org/wiki/Business_intelligence

Before you start with anything get up to speed with dimensional modeling.

(Get familiar with the works of Ralph Kimball)

Get a clean (virtual) machine and first install an Oracle database. The 10g express version is OK for starters.

http://www.oracle.com/technology/software/products/database/index.html

Maybe you want to brush up your DB skills:

http://www.oracle.com/technology/obe/11gr1_db/index.htm

Next get the latest version of OBIEE

http://www.oracle.com/technology/software/htdocs/devlic.html?url=/technology/software/products/ias/htdocs/101320bi.html

Download the documentation:

http://www.oracle.com/technology/documentation/bi_ee.html

If you have everything installed work trough the OBE tutorials on OBIEE.

http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/index.html

Don’t not only copy the click but be sure you understand what is happening!

Download and install the extended sales sample RPD and CAT. Dissect every report and dashboard to understand how the reports work.

http://download.oracle.com/technology/products/bi/files/oracle_bi_sample_analysis_setup_files.zip

Have a good look around at the OTN forums. Most questions have been asked before.

http://www.blogger.com/OBIEE? forumid=378

OBISE forum:

http://forums.oracle.com/forums/forum.jspa?forumID=404

Read the works of Stephen Few on how to design a good dashboard from the visual standpoint:

http://www.perceptualedge.com/articles/Whitepapers/Common_Pitfalls.pdf

http://www.amazon.com/Information-Dashboard-Design-Effective-Communication/dp/0596100167

Learn to create reports and dashboard which people need, which is often completely different of the reports and dashboard they intentionally asked for…

http://www.orm.net/

Configure your OTN account so that you “watch” certain users. Looking around at the forum you soon learn which users give the most valuable answers.