Here are several Knowledge Network resources that give users a closer look at data warehousing.
The typical ROI-based business case will not work well for selling a data warehousing initiative to upper management. While there may be some long-term savings that can be quantified, they will almost certainly be outweighed by costs. The real benefits of data warehousing are indirect: the ability of your company to make better, faster decisions resulting in cost savings or increased revenue. This checklist contains key points you should highlight when you go before any group of upper-level managers to pitch a data warehousing initiative.
ETL-Extract, Transform and Load-is the process by which data from multiple systems is consolidated, typically in a data warehouse, so that executives can obtain a comprehensive picture of business functions, e.g., the relationships between marketing campaigns, sales, production and distribution. The process is complicated and has been the subject of numerous books. Anyone undertaking an ETL project for the first time will have to do some serious research. Here is a high-level checklist of the important topics.
Find out the basics of data warehousing and how it facilitates data mining and business intelligence in this excerpt from Data Warehousing for Dummies. This book shows you how to involve users in the testing process and gain valuable feedback, what it takes to successfully manage a data warehouse project, and how to tell if your project is on track.