Monday, January 11, 2010

Business Intelligence - BI

Business Intelligence is definitely a buzz word nowadays in IT industry. Why not, the big IT guys were swallowing up small time BI vendors like craze (IBM on Cognos, SAP on Business Objects, Oracle on Hyperion). For me, it’s time to plan to acquire the skills in this area or else I’ll be left out. For a start, I have started studying the current implementation in Loders Croklaan for better understanding. Well, it’s not that hard. Have you by any chance use PivotTable in Excel? If you have, it’s basically the same thing. The main objective is trying to make sense a large chunk of data in meaningful format. If you are a CEO, you don’t have time to analyse the data but rather is more interested in glancing the current status in two, three minutes. Then you can make the decision immediately. Sounds good right. That why it’s called Business Intelligence. My job currently pretty much doing the reporting for managers. For instance, recently I just completed a complex report for diesel hedging used in Loders Croklaan US. As you can see below, the report (mind you, this was the report I implemented) only consists of rows and columns which may take some time for managers to digest all the information presented.


Business Intelligence takes this to another level. It will summarize all information presented above to something like below. Nice and easily digested. There you go, from here you can make decision in minutes. Smart right? Well, that’s where I’ll be heading. Taking one step higher to world of intelligence information. Well, some of you might think this all can be done thru excel. Owh no, imagine if you have millions and millions of data. Excel max capacity is 65000 which is useful for small kind of reporting. Imagine you are making sales 1000 per day, one year ->approx 400,000, 2 years? 10 years? See how many amounts of data you can have. Business Intelligence excites me and definitely would be my next direction in SAP world.

0 comments:

Post a Comment