Corporate Sponsorship Sponsorship at the executive level is necessary to make the warehouse a priority within the organization.

Project Manager Project management of the warehouse team is needed to ensure the warehouse is aligned with the business needs and to develop project plans to support the warehouse as it matures. The Project Manager manages the overall project, performs project reviews, works to accomplish the project tasks identified in the project plan, manages day-to-day activities, generates regular status reports, conducts regular status meetings, manages change control process, coordinates contact with all other vendors, and ensures the project's timely and successful completion.

Data Modeler The data modeler creates the subject area diagram, the logical data model, and the data warehouse data model, as well as conducting discussions with key business analysts and end users to identify requirements and data sources.

Select group of end users and business analysts This group works with the data modeler to identify the data model data sources and to identify requirements. These groups’ participation will ensure that the highest return on the data warehouse investment is delivered to your business.

The relationship between the end users and the data warehouse project team works something like:

Business End Users Data Warehouse Project TeamIdentify strategic data Develop the data modelDefine data archive requirements Provided data archiving and retrievalApprove data source Identify data sourceDetermine level of granularity Do extracts, transformations, and loadsIdentify data integrity issues Identify data integrity issuesDefine DSS applications Develop DSS applicationsTrain the end users Train the trainerDefine the data Document the data

Table 3-1. End User and Project Team Relationship

Data Warehouse Architect concentrates on the architecture and infrastructure aspects of the project, with the flexibility and extensibility of the data warehouse as the primary goal. The data warehouse architect assists in conducting readiness assessments, creating management procedures, planning, and implementing the infrastructure. After gathering requirements, the technical and data architectural support requirements must be defined. Data collection rates, volumes and timing from every point-to-point in the warehouse dictate the network capacity, transfer rates, storage volumes and growth rate of the warehouse.

Database Administrator creates the physical database schema, manages performance, creates sizing estimates, performs backups, assists with loads, and implements security.

Programmer/Analyst creates extraction/transformation load & post-load programs.

Business Analyst is knowledgeable in the needs and requirements of end users. Documents end user requirements and maintains business measures descriptions. Business analysts provide valuable knowledge and guidance from both the users' and business perspective, bringing a positive relationship with the business departments to the project. The analysts can assist with the preparation and transformation of corporate operational data into business-analysis-oriented data, in addition to assisting with the reconciliation of warehouse data and historical data.

End User Access Tool Programmer/Analyst: Leads the installation, implementation, and demonstration of the end user tool and creates standard query templates as identified in the requirements analysis.

Additional support staff involved in the data warehouse project will include:

• System administration technical support: sets up the technical environment installs hardware, operating systems, storage devices, networks, and maintains the operations of the system.
• Trainer: creates the training curriculum and trains the end users
• Help Desk: Supports the end users in accessing the data warehouse

Subject matter experts: OLTP source system expert; facilitates the extraction process including the extraction scheduling

Data Stewards: Resolves data integration issues; determines data security; documents data definitions; calculates, summarizes, maintains and updates business rules. Power end user who understands the data, the tool, and the information it provides.

Send mail to webmaster@donmeyer.com with questions or comments about this web site.
Copyright © 1998,2000 Data Mining & Analysis, LLC