Developing and Deploying Data Warehouse and Business Intelligence Solutions[开发和部署数据仓库和商业智能解决方案](PPT-40).ppt

Who is Kerr-McGee? Kerr-McGee is an Oklahoma City-based energy and inorganic chemical company with worldwide operations and assets of approximately $10 billion. / Agenda Introduction to DW/BI Concepts Extract, Transform Load (ETL) Business Intelligence / Reporting A Day in the Life DW / BIConcepts Information Management Strategy Structure the systems and data relationships to provide user-friendly customer access to data in order to provide decision-making information. Adding Value to Data Information Pyramid What is a Data Warehouse? A copy of data from one or more On-line Transaction Processing (OLTP) systems specifically structured for Query, Reporting and Analysis (QRA). Data is typically at a summarized level to limit the size and complexity of the data warehouse Data is usually cleansed and merged to create an “apples to apples” comparisons The Idea Behind Data Warehousing Framework Architecture Business Intelligence Data Warehouse Roles Manager Planning and management of entire product or project lifecycle; May assist in ETL BI Interface design and development Data Warehouse Architect – Applies knowledge of technology options, platforms, and design techniques across product and project lifecycle; responsible for design of overall warehouse process ETL Specialist – Analysis and design of extraction, transformation, and loading strategy; development of ETL scripts and procedures Business Intelligence Specialist – Design and development of multidimensional-cubes reports; performance and tuning of chosen technologies Web Interface Specialist – Design and development of application interface elements; coordinates interfaces between application components ETL ETL Challenges Warehouse Complexity Destructive vs. Incremental Loads Integration (mergers/acquisitions) Data integration (consolidation of information) Process integration (consolidation of processes) Smaller windows of opportunity Make decision in a shorter period of time due to competitive, glob