~ Focus Areas

1. Business Value & Strategic Direction
   • Align data warehouse goals and objectives with the corporate goals and objectives.
   • Develop cost/benefit procedures
   • Develop a process for measuring return on investment.
   • Develop a prioritization process.
   • Align mission of the data warehouse to the business drivers.

2. Architecture & Infrastructure
   • Recommend changes to hardware, software, integration of data warehouse tools.
   • Develop an enterprise data warehouse and data mart strategy.
   • Recommend data distribution, replication, and synchronization strategies.

3. Evaluation & Selection of New Tools
   • Develop a methodology for evaluating and selecting vendors.
   • Develop procedures for managing vendors.

4. Data Modeling (Logical, Physical, Mapping)
   • Develop procedures for creating logical and physical data models.
   • Enhance and/or complete the logical data model.
   • Enhance and/or complete capuring the business rules.
   • Develop procedures for logical to physical data model mapping.
   • Develop design review procedures.

5. Data Analysis, Integration & Cleansing
   • Create a process by which data is acquired from legacy source systems.
   • Develop a process for measuring cleanliness of data.
   • Enhance data cleansing transformation rules.
   • Develop data standards.

6. Meta Data Strategy & Repository
   • Enhance and/or complete existing meta data.
   • Evaluate and select a new repository mechanism.
   • Develop a process by which meta data is obtained and documented.
   • Recommend new uses of meta data and the repository.

7. Standards
   • Enhance and/or complete existing standards.
   • Recommend changes to standards to increase their effectiveness.
   • Develop procedures for following standards.

8. Defining the DW Organization (Roles & Responsibilities)
   • Develop a list of roles and responsibilities.
   • Suggest improvements to the structure of the data warehouse group.
   • Provide solutions for potential organizational roadblocks.

9. Procedures & Organization for Testing
   • Enhance and/or complete the test procedures.
   • Recommend changes to the organization and staffing for testing.
   • Develop a procedure for creating comprehensive testing documentation.

10. Application & Delivery
    • Make recommendations to the applications and the types of tools being used.
    • Develop a procedure to increase effectiveness of tools.
    • Develop an intranet and extranet delivery strategy.