Chapter 2 Project Planning and Management

Question 1

Situation Scenarios when Defining the Project?

Answer 1

1. Demand from a lone business zealot
2. Too Much Demand
   3.In Search of Demand

Question 2

Demand From a lone business Zealot

Answer 2

One business exec has a vision about getting better access to better info for better decision support

Question 3

Too Much Demand

Answer 3

Multiple business executives are voicing a need for better information
Need to prioritize the requirements

Question 4

In search of Demand

Answer 4

Can be viewed as demand from a CIO
By Far the most challenging scenario to deal with

Question 5

2 Things before beginning a data warehouse of data mart project

Answer 5

-Understand whether there is demand and where that demand is coming from
-have strong business sponsor and eager users

Question 6

5 Key factors to establish the foundation to ensure a successful DW?

Answer 6

1. Strong Business Sponsors
   2.Compelling Business Motivation
2. IS/Business partnership
   4.Current Analytical Culture
3. Feasibility

Question 7

Strong Business Management Sponsors

Answer 7

-Influential Leader in organization who are well respected by others
-Sponsors should be strong, realistic and have basic understanding of data warehousing concept

-

Question 8

Compelling Business Motivation

Answer 8

DW that align with strategic business motivations stand a good chance of succeeding

Question 9

IS/Business Partnershi

Answer 9

Successful DW result from a joint business and IS effort in which both groups share responsibility for the initiative

Question 10

Current Analytical Culture

Answer 10

When business community does not currently place value on information and analyses, it’s readiness is questionable

Question 11

Feasibility

Answer 11

-refers to tech feasibility
-better shape if the overall infrastructure is already in place
-premary feasibility concern relates to data

Question 12

What are techniques to address readiness shortfall

Answer 12

-High-level Business requirements analysis
-Business requirements prioritization
-Proof of Concept

Question 13

How to develop a preliminary scope?

Answer 13

-Scoping is still a best-guess exercise at this point
-attempt to make as few promises as possible but enough to identify benefits and cost associated with going forward

Question 14

Guidelines for developing the preliminary DW project scope

Answer 14

-Joint effort by IS and Business representatives
-Initial scope is manageable
-focus on single Business requirement supported by data
-limit users
-establish success criteria

Question 15

Scope Refinement

Answer 15

Same size, contents may change

Question 16

Scope Creep

Answer 16

Expand the demensions

Question 17

Building Business Justification

Answer 17

-Identify anticipated costs and benefits
-Compare predicted financial return against the predicted investment
-Determine Financial returns and benifits
-Figure out ROI

Question 18

Planing the project

Answer 18

-Establishing the Project Identity
-Staffing Project
-Develop the Project Plan

Question 19

Establish the project Identity

Answer 19

Project needs a name and/or logo

Question 20

Staff Project

Answer 20

-Same staff may fill multiple roles
-Sponsor and Drivers
Project Managers and Leads
-Core Project Team (FT and PT)
-Special Teams
External Consultants

Question 21

Develop Project Plan

Answer 21

-Integrated and detailed plan
-Track ( Resources, Original Estimated effort , Start date…)

Question 22

Managing the Project

Answer 22

• Unique Characteristics of data warehouse
  -Project Team Kickoff Meeting
  -Monitor Project Status
  -maintain Project Plan and Project docs
  -manage scope
  -Communications plan to manage expectations

Question 23

Unique Characteristics of DW

Answer 23

-Cross-Functional Implementation team
-Iterative development cycle
-Inevitable data issues
-Elevated visibility

Question 24

Project Kickoff meeting

Answer 24

Get teh entire project team on the same page in terms of where the project currently stands and where it hope to go.

Question 25

Monitor Project Status

Answer 25

Key to achieving coordination between numerous resources and task

Question 26

maintaining project plan and project documentation

Answer 26

-integrated project plan should be updated weekly to accurately reflect progress
-project falls behind schedule, have courage to acknowledge to management and sponsors