Skip to content.

EWSolutions

Sections
Home » World-Class Training » World-Class Data Warehouse Training » Data Warehousing Project Management

Data Warehousing Project Management

Overview

Data warehouse projects present a unique set of management challenges that can stymie many experienced information system project managers. This complex suite of database and applications requires a tailored methodology to ensure that the project is well-organized, analyzed and executed, delivering value to the data warehouse users. This course will offer a methodology for creating a successful data warehouse, based upon actual experiences. The attendee will gain an understanding of the importance of managing a data warehouse project using standard information systems project management techniques that have been enhanced for a data warehouse project, the critical success factors of data warehousing and offer some suggestions for avoiding common problems. As an added benefit, participants will examine and critique a data warehouse case study where they can apply the lessons learned in this workshop.

Benefits To Your Company

  • Demonstrate critical success factors of data warehousing
  • Learn measuring results from a data warehouse project, including a cost-benefit analysis
  • Show how to select the right software and vendors
  • Develop roles and responsibilities of the data warehouse project team
  • Provide a methodology for addressing data warehousing development

Who Should Attend

  • Project managers
  • Business systems analysts
  • Data or process analysts
  • Test engineers
  • Business unit managers
  • Solution architects
  • Business information managers
  • Data architects

Learning Objectives

  • Develop a realistic project plan for a data warehouse or other decision support systems project
  • Prepare cost / benefits projections and other project management oriented artifacts for a data warehouse project
  • Study best practices in project management, as applied to data warehousing projects
  • Learn how to work collaboratively to develop and refine your project management skills

What Makes This Certified Course Unique

This EWSolutions-certified class is workshop focused since design concepts are best learned from doing. The final workshops are oriented to solving problems that you have in your current projects. The workshops allow you to learn how the concepts are applied and how to develop skills in data warehouse project management for any organization.

Course Outline

  1. Introduction
  2. Overview of data warehousing and decision support systems
  3. Planning the data warehouse project
    • Goals and objectives
    • Critical success factors
    • Business problems in data warehousing
    • Measuring results
    • Risks, issues, challenges in data warehouse project management
    • Selecting the first data warehouse project
  4. Business focus in data warehousing
    • Business knowledge
    • User types and challenges
    • Communication
    • Fundamentals of requirements gathering for data warehousing
      • Interviews
      • Questionnaires
      • Workgroup / JAD sessions
      • Surveys and observations
  5. Data warehouse methodology overview
    • Iterations
    • Development approaches and challenges
    • Major development steps
  6. Data warehouse project planning
    • Fundamentals of project planning
    • The project plan
      • Work breakdown structure
      • Tasks
      • Milestones
      • Deliverables
    • Scheduling
    • Resources
    • Estimating
    • Controlling the project
      • Change management
      • Risk management
      • Team management
    • Project management tools and methodology
    • Developing the project plan
    • Maintaining the project plan
  7. Project communication
    • Best practices
    • Team meetings
    • Team documentation
    • Issue resolution
    • Resource management
    • Developing and maintaining a communication plan
  8. Data warehouse tool selection project
    • Writing an RFI / RFP / PFQ
    • Tool selection team
    • Vendor management
    • Tool selection
    • Service level agreements
    • Incorporating tools into a data warehouse
  9. Data warehouse project documentation
    • Templates
    • Questionnaires
    • Surveys
    • Cost / benefits analysis
    • Summaries
  10. Workshop conclusion
    • Summary, additional exercises, sources for further reading, etc.

Standard Duration

  • 3 days (may be customized as needed)

To learn more about how EWSolutions can provide our World-Class Training for your company or to request a quote, please feel free to contact Dr. Anne Marie Smith, our Director of Education at AMSmith@EWSolutions.com or call her at 856.468.6194

LEARN MORE ABOUT Data Warehousing