DataSense

I am often asked usually by programmers - What is Data Warehousing & how do I learn it? I explain to them we use all the same tools that you do but differently. That’s when I coined the term Data Sense. It describes the essence of Data Warehousing and separates Data Warehousing from rest of Programming. Every aspect of IT from Hardware / Software infrastructure to Design, Development and QA is done with massive data flows and need for data precession accuracy and meaning.

Sunday, March 18, 2007

Why do Most data warehouses Fail?

  1. Datawarehouse is treated like any other application in the company and same people put it through the same process that worked for other applications.
  2. Lack of understanding of the mess that the application sources to data warehouses are in and an optimistic expectation of data quality.
  3. Lack of understanding of the columes of data involved and the false expectations that the vendors set. Yes SSAS will work for this volume we were told. But in reality a vastly toned down version with 10 % of requirements will work on a 64 cpu box we found after months of work.
  4. .....
Posted by at