nplementation. They compiled a list of 1 l major tasks that could be performed in paralle Establishment of service-level agreements and data-refresh requirements Identification of data sources and their governance policies Data quality planning Data model design ETL tool selection Relational database software and platform selection Data transport Data conversion Reconciliation process Purge and archive planning End-user support 2. List and discuss the most pronounced dw implementation guidelines Senior management must support development of the data warehouse. The Dw needs a project champion at a high position in the organization chart Benefits of a Dw project may be difficult to measure, so management support makes it more likely the project will receive funding Web-based data warehouses may need special security requirements These ensure that only authorized users have access to the data Users should participate in the development process. Their participation essential for data modeling and access modeling. User participation ensures that the dw includes the needed data and that decision makers can retrieve the data they need DW implementation requires certain skills from members of the development team: in-depth knowledge of database technology and the development tools used 3. When developing a successful data warehouse, what are the most important risks and issues to consider and potentially avoid? Starting with the wrong sponsorship chain Setting expectations that you cannot meet Copyright C2018 Pearson Education, Inc.9 Copyright © 2018Pearson Education, Inc. implementation. They compiled a list of 11 major tasks that could be performed in parallel: Establishment of service-level agreements and data-refresh requirements Identification of data sources and their governance policies Data quality planning Data model design ETL tool selection Relational database software and platform selection Data transport Data conversion Reconciliation process Purge and archive planning End-user support 2. List and discuss the most pronounced DW implementation guidelines. • Senior management must support development of the data warehouse. The DW needs a project champion at a high position in the organization chart. Benefits of a DW project may be difficult to measure, so management support makes it more likely the project will receive funding. • Web-based data warehouses may need special security requirements. These ensure that only authorized users have access to the data. • Users should participate in the development process. Their participation is essential for data modeling and access modeling. User participation ensures that the DW includes the needed data and that decision makers can retrieve the data they need. • DW implementation requires certain skills from members of the development team: in-depth knowledge of database technology and the development tools used. 3. When developing a successful data warehouse, what are the most important risks and issues to consider and potentially avoid? • Starting with the wrong sponsorship chain • Setting expectations that you cannot meet