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
What is evaluated and Select from Product Selection and Installation?
Hardware Platform
Database management system
data staging tool
data access tool
End User App Specification is?
Recommended set of standard for end User Apps
End User App Development
Involves Configuring the tool metadata and constructing the specified reports
Deployment is?
Convergence of technology, data and enduser apps accessible form the business users’ desktop
Maintenance and Growth
Providing ongoing support and education to the business users
Ensure that the processes and procedures are in place for effective ongoing operation of the warehouse
Embrace change as a sign of success
Project Management
Project management ensure that Business Dimensional Lifecycle activities remain on track and in sync
What are activities occur throughout the lifecycle ( Project Management Stage)??
Monitoring project Status
Issue tracking
Change Control
Development of communication plan
What does the Dimensional Lifecycle focus on?
Sequencing and Concurrency, not timelines
When is the life cycle. most effective ?
When used to implement projects of manageable yet meaningful scope.
