Components of A Successful Data Warehouse一个成功的数据仓库组件.pptVIP

Components of A Successful Data Warehouse Chris Wheaton, Co-Founder, Client Advocate Presentation Information Presentation: Successful Components of a Data Warehouse The purpose of this presentation is to provide attendees with the understanding of how to build a successful data warehouse/business intelligence solution. Presentation Information Author: Chris Wheaton Biography: Chris Wheaton is a Co-Founder of BASE Consulting Group, Inc. He initiated and has contributed to the development of the Business Intelligence and Data Warehousing Certificate Program at the University of California, Berkeley Extension and is a lecturer in the program. He has presented on Data Warehousing topics at conferences throughout the United States including the Business Objects and Oracle Applications User Conferences. Contact Information: E-mail: cwheaton@ Phone: (510) 628-3300 Ext. 223 Agenda Data Warehouse ? What is it? Why do it? Why do they fail? How do you control business risk? How do you control technical risk? Many names for the same thing Decision Support System (DSS) Executive Information System Management Information System Business Intelligence Solution Analytic Application Data Warehouse Six terms for the same thing: a system for helping companies get the information they want, when they want it…etc. Data Warehouse Objectives Business Access to specific high-value information on a timely basis. Analysis Makes the restructured data available to users via user-friendlier query and reporting tools. Reporting Technical Gets the data off of the transaction system for analysis. Performance Restructures and integrates the data so that it is easier to use for reporting and analysis. Integration Data Warehouse Risks Business Content Does the solution answer the right questions? Does the solution have enough data? User Acceptance Is it too complex for the average user? Is the data timely enough? Technical Performance Is the performance of the user queries satisfactor