Friday, January 27, 2012

BI for Currency Exchange Predictor Model


One of the most economically lucrative idea: Currency exchange predictor. What if you knew when the dollar price will go up and by how much, when will it fall. You can earn and pretty much make a living out of this knowledge. And you know what is behind all of this BI !!!
Using the basic knowledge of currency exchange, some awareness of world affairs and guts to invest money is all you need. I had done a very detailed report back in India but sadly it seems I have lost it. Here I have collected the 10 years of U.S. $ data from::
http://www.bankofcanada.ca/rates/exchange/10-year-lookup/

and made something very trivial but on similar lines.
As we see a periodicity in the trend of how US dollar changed over time. Anyone can capitalize on this information and earn bountiful profits.

Industrial Use: I will take my own example here. My company was based in India and our client was GUESS, US. My company used to get money in dollars and it had to pay us in Indian Rupees. This knowledge of when to get the maximum return from our $ earnings made my Vice President put this project infront of us.

The difference

My experience with the BI class till now has been great. I got to learn a lot about data collection from online traffic and the various KPIs and metrics that differentiate a better website from a worse.

But in the last class I felt there was something lacking in the presentations. Everyone
has great data to backup their conclusions but the conclusions were more data-centric rather than business-centric.

To me the picture of business intelligence is composed of data, the information we collect from the data and the reporting where we suggest ways to improve the business. The 3rd component is the most important part of that picture, because even if you have the data and you extract the correct information from it unless you can relate it to the business everything is in vain. Its like watching a suspense movie but without the ending.

The "So what?" question is something I and my classmates need to keep in mind in our future analysis.

Friday, January 13, 2012

I and BI

As an Electrical and Electronics Engineer from BITS, Pilani when I got an opportunity to work for a start-up, Apex Decisions, Bangalore India that works in BI I was confused, because before that day I did not even know what Business Intelligence is.
To my surprise I saw the diverse application of BI in all walks of life. My project area was Retail market with US based clients as GUESS and BigM. I was surprised to see all the sales and promotions run by various retail brands like GUESS, Nike, GAP etc have proper quantitative decisions behind every move. To my surprise I was told that our pilot run with GUESS had increased their yearly revenue by about $20 Million- all because of BI. It was unbelievable for me but as I started working with them and implementing their algorithm and using their tools I could feel how BI can augment a retail business.
Extracting seasonality pattern information from traffic pattern of sales round the year, considering special events like Easter, 4th of July, Thanksgiving and Christmas, and using the tools in the best way possible I could forecast sales patterns for my clients for the coming year.
The biggest surprise was to when my analysis was actually forwarded to GUESS and implemented. The accuracy of my forecast coincided with less that 5% error with their actual yearly sale. This was the moment that ushered me towards BI and couple of months later I find myself in the BI class. Hope my journey takes me to more interesting places. Later.