But that assumes the ONLY reason people built data warehouses was because their operational data needed to be in a relational format. That simply is not the case.
Data warehousing is not a disease to avoid. It often enables business analysis (performance management and reporting) for business people. This is accomplished by performing the data integration and data cleansing necessary to provide business data that is consistent, correct, current and comprehensive.
Why is this data integration necessary? Too often, data is spread across many applications with different definitions and reference data. This reference data, often referred to as master data management (MDM) or dimensional data (in data warehouse-speak), includes product, customer, employee and other organizational structure data that is not readily available for real-time queries without a data warehouse. In addition, being able to have historical data available for trending and year-over-year analysis is generally best supported by a data warehouse.
It is more than likely that you need a data warehouse and it is best if you plan for one right away. If you fail to plan and build one then you will probably build a series of data silos to support each new set of reporting requirements that you have. This accidental architecture will hurt your business by limiting its visibility into data it needs to operate and grow. It will hurt your IT group, too, because it will be far more costly to create and maintain this haphazard array of data silos than if you were to build the data warehouse from the beginning.
More about business intelligence tools and data warehouses
Dig Deeper on Business intelligence software
Related Q&A from William McKnight
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI ... Continue Reading
Find out when you should use a DBMS with your data warehouse, and learn about the future of data warehousing data management and current state of ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.