Skip to main content

Why should I build a datawarehouse? Why do I need to invest on BI?

Well, lets start with basics. Every time you had to recruit a new resource to share the increasing load on your staff, what is the picture you have in mind? An exact clone of the perfect efficient guy X you have with you, who understood the way the company works and feels the direction in which the business went. We know that its not possible as of today to clone people, but what if there was a way the same X you have had a way to do the work he did today in half the time he did today so that in effect he had the time to do twice the work he did today. What if all the associates in your company could do their work in half the time they took today. With rising HR cost today and the huge crisis in getting and retaining brilliant employees this would sound like directly from heaven for CEOs around the world, and has over the past few years which led companies to invest hugely in better and more efficient tools for their employees. Now who among your staff is highest paid most critical of all resources. Its definitely the higher management and analysts who are empowered with the responsibility of making decisions in which the company goes each step. And its these same decisions that make or break the future of a company. For the same reason there are no other employees in your company who need the most intelligent, smart, robust and reliable tools as these people do. This argument alone gives you more that enough reason for any company to pull their act together and building a BI & DWH establishment for themselves. Considering your competition reaching there ahead you and fighting you with a weapon much advanced to your arsenal is a inescapable impetus.

Comments

Popular posts from this blog

Making of a genius

They say there is a genius in all of us. All humans are supposed to be born with similar abilities. Its the environment and experiences that his life goes through that defines where he/she reaches in life. At least so goes philosophy.I had the fortune of doing my bachelors in the most sought after department in the most sort after Engineering college in my state. So for my part I have seen quite a few geniuses in the making. One thing I could pride myself with is my sense of observation of people around me and their habits, and I have come to the conclusion that there is a lot in common among these individuals.That being said, going by the converse theory if all geniuses had similar habits, would developing the very same habits make one a genius? Probably not, but it would definitely give you the same edge these genius have besides the blessed brainpower they possess.So what are these traits that I am talking about?ConfidenceEach one of them knew themselves that they were exception...

Informatica PowerConnect for Webservices

I started working with Informatica powerconnect for webservices with Informatica version 8. I was mighty disappointed to see that the infromatica manual said very little about how to use the transformations. The web wasn’t of much help either. Lots of trial and error, figuring around and hours of calls with Informatica support finally got our mappings working the way it had to. More because the webservice we were calling were rather complex, but even with a far simpler webservice it still is a herculian task getting the thing to work without help.This article is written with the assumption that the reader has gone through the Informatica manual related to power connect for web services.We can use powerconnect as a source, target or consumer transformation. The chance that you use as a consumer transformation being the highest I will talk mostly about that.You start with using a WSDL file that the webservice provider has given you. Most probably this would have been provided this on the...