/
Program/Project Planning & Management
Save to my account
Sign up
Program/Project Planning & Management
View
Lecture 3_ Kimball Lifecycle and Dimensional Modelling_DWM.pptx_removed.pdf Flashcards
Study
1
Question
What is the primary aim of the SDLC?
Answer
The SDLC aims to produce high-quality software that meets or exceeds customer expectations and reaches completion within time and cost estimates.
2
Question
What is the Kimball Lifecycle?
Answer
The Kimball Lifecycle is a framework for program and project planning and management in the context of data warehousing and business intelligence.
3
Question
What are the initial activities in the DWBI initiative?
Answer
The DWBI initiative begins with a series of program and project planning activities, which include assessing readiness, scoping and justification, staffing, and developing the plan.
4
Question
What is the most critical factor in assessing readiness for a DWBI initiative?
Answer
The most critical readiness factor is to have a strong executive business sponsor who has a clear vision for the DWBI systems' potential impact on the organization.
5
Question
What is a key motivation for tackling the DWBI initiative?
Answer
Having a strong compelling business motivation to solve critical business problems is essential for garnering the resources required for a successful launch.
6
Question
What does feasibility include when assessing readiness?
Answer
Feasibility includes technical and resource feasibility, but data feasibility is the most crucial. Data feasibility is a major concern because there is no short-term fix if you are not already collecting reasonably clean source data at the right granularity.
7
Question
What is required during the scoping phase of a DWBI project?
Answer
Scoping requires the joint input of the IT organization and business management to ensure the scope is meaningful to the business and manageable for IT.
8
Question
What does justification entail in a DWBI initiative?
Answer
Justification requires an estimation of the benefits and costs associated with the DWBI initiative, with the hope that the anticipated benefits grossly outweigh the costs.
9
Question
What is not sufficient financial justification for a DWBI project?
Answer
Delivering a single version of the truth or flexible access to information is not sufficient financial justification.
10
Question
What is essential to determine the quantifiable impact of improved decision-making?
Answer
You need to peel back the layers to determine the quantifiable impact of improved decision-making made possible by the DWBI initiative.
11
Question
What type of team is required for DWBI projects?
Answer
DWBI projects require the integration of a cross-functional team with resources from both the business and IT communities.
12
Question
What are the business roles in a DWBI project?
Answer
Business roles include Business Sponsor, Business Driver, Business Lead, and Business Users.
13
Question
What are the IT roles in a DWBI project?
Answer
IT roles include Project Manager, Technical Architect, Data Architect, Database Administrator, Metadata Coordinator, ETL Architect, and ETL Developer.
14
Question
What should key team members do when developing the project plan?
Answer
Key team members should develop estimates of the effort required for their tasks, as the project manager cannot dictate the amount of time allowed and expect conformance.
15
Question
What should the project plan identify to ensure the project remains on track?
Answer
The project plan should identify acceptance checkpoints with business representatives after every major roadmap milestone and deliverable.
16
Question
What vulnerability do DWBI projects face related to project scope?
Answer
DWBI projects are vulnerable to scope creep largely due to a strong need to satisfy business users' requirements.
17
Question
What options do you have when confronted with scope changes?
Answer
You can increase the scope, play the zero-sum game, or say no. However, scope decisions should not be made in an IT vacuum; the right answer depends on the situation.