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
- Buying business intelligence software: Top 11 considerations
- Gartner: Business intelligence software market grew 13% in 2007
- Risky business: How to assess risk during software purchases
- Data quality management for 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
Should operational reporting come out of a data warehouse? Get an expert's take, plus learn about the relationship between operational systems, ... Continue Reading
Find out how you can learn business intelligence (BI), get business intelligence training and discover why analytics is the key to marketing efforts ... Continue Reading