Q
Problem solve Get help with specific problems with your technologies, process and projects.

What is the advantage & disadvantage of using a data warehouse?

What is the advantage & disadvantage of using a data warehouse?

Data warehousing is about making your data work harder and more efficiently. Normalizing data across departments and applications always requires an investment and commitment at the top of the corporate ladder -- this has nothing to do with technology, but more to do with corporate vision. The alternative is usually some type of aggregation of the data at the departmental level to a specified reporting level. For example, reporting sales activity at the product as opposed to at the transaction level. Whether or not this is worth the investment depends upon such factors as interest, available resources, quality and availability of data. The benefit -- the pros -- is that this information can represent a powerful competitive edge in a marketplace. The downside -- the cons -- is that like the tall masted ships in "Two Years Before the Mast," "a data warehouse is like a lady's wristwatch - always under repair" meaning required continuous commitment and investment.

Dig Deeper on Topics Archive

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchSoftwareQuality

SearchAWS

SearchCloudComputing

TheServerSide.com

Close