11 Steps to Successful Data Warehousing
Mining your corporate data for valuable customer information can improve your business performance. But it's not as simple as it sounds.
By Phillip Blackwood
There are 4 reader comments on this topic. Add yours!
More and more companies are using data warehousing as a strategy tool to help them win new customers, develop new products, and lower costs. Searching through mountains of data generated by corporate transaction systems can provide insights and highlight critical facts that can significantly improve business performance.
Until recently, data warehousing has been an option mostly for big companies, but the reduced costs of warehousing technology make it practical -- often even a competitive requirement for -- smaller companies as well. Turnkey integrated analytical solutions are reducing the cost, time, and risk involved in data warehouse implementations. While access to the warehouse was previously limited to highly trained analytical specialists, corporate portals now make it possible to grant data access to hundreds or thousands of employees.
Following are some steps to consider in implementing your data warehousing solution. 以下是一些措施,考虑在实施数据仓库解决方案
1. Recognize that the job is probably harder than you expect.
Experts frequently report that 30-to-50 percent of the information in a typical database is missing or incorrect. That situation may not be noticeable -- or may even be acceptable -- in an operational system that focuses on swiftly很快地and accurately processing current transactions. But that percentage of error is totally unacceptable in a data warehousing system designed to sort through millions of historical records to identify trends or select potential customers for a new product. And, even when the data is correct, it may not be usable in a data warehouse environment.
For example, legacy system programmers often use shortcuts to save disk space