Chapter 1 Flashcards
Project Planning Definition
Address definition and Scoping of the data warehouse project
What does Project planning Include
Readiness Assessment
Business Justification
Other than Readiness assessment and Justification others might include the following in the Project Planning Stage
Resource and Skill-Level Staffing
Project task assignments
duration and sequencing
Project Planning is dependent on…
Business Requirement
Business Requirement Definition
DW Designers must understand the key factors driving the business effectively to determine Business requirement and translate them into design Consideration
What does the Business Requirement establish…
A foundation tracks focused on
Tech
Data
End User Apps
Dimensional Modeling Starts with…
A Matrix that represents Key Business processes and their dimensionality
What serves as a blueprint to ensure the DW is extensible across the organization Over time?
A Matrix
What develops a dimensional model?
Coupling of detailed data analysis on relevant operational source systems with earlier understanding of business requirements
What does Dimensional Modeling Identify?
Fact Table grain
Associated Dimensions
Attributes
Hierarchical drill paths and facts
Physical Design is?
Defining the physical structures necessary to support logical database design
Data Staging Design and Development is?
Three Major Steps:
Extraction
Transformation
Loading
How many Warehouses need to be build for staging Process
Two:
One for initial population of the DW
One for regular, incremental Loads
Technical Architecture Design is?
Establishing the overall architecture Framework and Vision
What 3 factors should be considered under the Tech Arch Design?
Business Requirement
Current Technical Environment
Planned Strategic Technical Directions
