Going to Kalediscope 2009

Next week is Kalediscope 2009, last year I learned a ton of great info. This year has even more content, and I'm looking forward to seeing some old Essbasers. I will blog some of the things I take away from the conference. If you are around shoot me an email.

How to go end-to-end in Business Intelligence in 1 week

Going from beginning to end in Business Intelligence in 1 week, these are the steps I would take. This could all happen in 1 week if you have the environment setup and data available to use.

0. Start--Gather requirements quickly and then rapidly Prototype.
1. Secure the data--If you have no data, then you have no system.
2. Understand the data--How does it work, what nuances do you need to be aware of?
3. Build the star schema--Keep it simple, find 11-13 total possible dimensions max for your first run.
4. Load Using EIS--It's a simple tool to load using Hyperion EIS, that can take your star schema into a workable protype model.
5. Build your Essbase cube from EIS--Dont' worry too much about calculations, etc
6. Repeat steps 3-5 until you come close to a point where showing a business user could add some insight and create some depth.
7. Finish the prototype and start the steps over with more detailed requirements. I've even finished whole reporting systems in 1 week before :)