/
Kimball Lifecycle: Overview
Save to my account
Sign up
Report Bug
Kimball Lifecycle: Overview
View
Lecture 3_ Kimball Lifecycle and Dimensional Modelling_DWM.pptx_removed.pdf Flashcards
Study
Question
What is the focus of the Kimball Lifecycle?
Answer
The Kimball Lifecycle focuses on the purpose of a Data Warehouse, which is a copy of transaction data specifically structured for query and analysis.
Question
Who is associated with the Kimball Lifecycle?
Answer
Ralph Kimball is associated with the Kimball Lifecycle.
Question
What does the Program Project Planning module assess?
Answer
The Program Project Planning module assesses the organization's readiness for a DWBI initiative, establishes the preliminary scope and justification, obtains resources, and launches the program/project.
Question
How do Program Project Planning and Business Requirements Definition interact?
Answer
There is a two-way arrow between program/project planning and the business requirements definition due to the interplay between these activities.
Question
Why is aligning the DWBI initiative with business requirements crucial?
Answer
Aligning the DWBI initiative with business requirements is absolutely crucial because best-of-breed technologies won't salvage a DWBI environment that fails to focus on the business.
Question
What does the Top Track Technology Track involve?
Answer
The Top Track Technology Track involves technical architecture design, which establishes the overall framework to support the integration of multiple technologies.
Question
What is meant by 'shopping list' in the context of architecture design?
Answer
Using the capabilities identified in the architecture design as a shopping list means evaluating and selecting specific products based on those capabilities.
Question
What does the Middle Track Data Track begin with?
Answer
The Middle Track Data Track begins by translating the requirements into a dimensional model.
Question
What happens to the dimensional model in the Middle Track Data Track?
Answer
The dimensional model is then transformed into a physical structure.
Question
What strategies are focused on during the physical design phase?
Answer
The focus during the physical design phase is on performance tuning strategies such as aggregation, indexing, and partitioning.
Question
What is the role of the ETL system in the Kimball Lifecycle?
Answer
The ETL system plays a crucial role in the overall data warehousing process.
Question
What is developed during the Bottom Track BI Application Track?
Answer
The Bottom Track BI Application Track involves the design and development of the BI applications.
Question
When is the DWBI project considered done?
Answer
The DWBI project isn't done when you deliver data; it is considered done when BI applications, in the form of parameter-driven templates and analyses that satisfy a large percentage of the business users' analytic needs, are delivered.
