Header - EWS 2021

Affiliated with:

DW 201 – Data Warehousing Project Management

Duration: 3 – 5 days

This seminar will offer a methodology for creating a successful data warehouse, based upon actual experiences and the works of Adelman and Agosta. 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 some suggestions for avoiding common problems.

Free Consultation

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name

Description

Data warehouse projects present a unique set of management challenges that can stymie many experienced information system project managers. This complex suite of databases 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 seminar will offer a methodology for creating a successful data warehouse, based upon actual experiences and the works of Adelman and Agosta. 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 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.

This course is workshop-focused since design concepts are best learned by 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.

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

Seminar Content

  • Introduction
    • Overview of Data Warehousing and Decision Support Systems
  • 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
  • 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
  • Data Warehouse Methodology Overview
    • Iterations
    • Development approaches and challenges
    • Major development steps
  • 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
  • Project Communication
    • Best practices
    • Team meetings
    • Team documentation
    • Issue resolution
    • Resource management
    • Developing and maintaining a communication plan
  • 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
  • Data Warehouse Project Documentation
    • Templates
    • Questionnaires
    • Surveys
    • Cost / Benefits Analysis
    • Summaries
  • Workshop Summary, Additional Exercises and Reference Materials

About the Course Designer

This training was designed by David Marco, PhD, an internationally recognized authority on data and AI governance, to help teams succeed in real organizational conditions. The curriculum equips participants with practical judgment, shared language, and decision clarity that hold under scale, risk, and executive accountability.

David Marco PHD EWSolutions

Featured Courses

DW 102 – Data Warehousing 101 – IT Professionals

This course is presented in a straightforward manner and assumes that attendees have no prior knowledge of decision support concepts...

DGS 301 – Data Stewardship Training

This intensive course will provide an introduction to data governance, its purpose, and how it can be implemented. The attendees...