12/22/2010

Oracle Hyperion Performance Scorecards

I'm starting to look at Oracle Hyperion Performance Scorecards at my day job.  It brings back memories working for Z-Tel.  There I had a chance to work on Crystal Scorecard and learned about KPI's (Key Performance Indicators). A KPI is a preset metric and if you meet or exceed you are doing good.  At the time it was pretty new for Seagate Software and my boss and I had several meetings with their developers in England to request modifications to the application.  Crystal sent out 3 contractors to set up the KPI's and my job was to integrated them into Crystal Reports.  I also got a chance to write some MDX code which also seems to be in demand now a days.

Fast forward to now, I'm excited to work with KPI's again.  Basically, Performance Scorecards are designed for executives to glance at the overall business to quickly identify the trouble spots.  You can use the standard Red, Yellow, Green or smiley faces or frowns.  Once the poor performing bucket is identified, you can drill down further to pin point the under performers.  A lot of planning goes into this.  It does not happen by magic.  Turns out, this skill is high in demand so I am real interested in learning.  When you think of Business Intelligence, Scorecards definitely have a place.

In addition, I'm also going to learn Dashboards which is an up and coming skill set.  Oracle's version is called OBIEE and we have about 100 reports in the queue for me to write.  Oracle Business Intelligence Enterprise Edition gathers its data from an OLAP cube or Data Warehouse/Mart.  The OLAP cube contains pre-configured aggregates called Facts which get sliced by Dimensions, populated periodically from extracting data out of an OLTP (Relational Database) server.  But it also can read Excel files, Access Databases as well as SQL-Server databases.  It's quite robust and allows users to write their own reports and puts the power of the data in the users hands.  Quite interesting.

So you can see, I've got my foot in Business Objects (15 years), Microsoft BI with SSRS/SSIS on my part time job and now adding Oracle BI to the mix.  Its all good!

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder