Data Warehouse Design Flashcards
Requirement Gathering
End users provide requirements of organisation.
Physical Environment Set Up
Physical servers and databases set up.
Data Modelling
Identification of data sources.
Extraction, Transformation, Loading (ELT)
Allow quick access without compromising quality of data.
Efficient access to the right data for the right usage by the right people.
OLAP Cube Design
On-Line Analytical Processing.
Identify information that needs to be generated by the data warehouse.
Front-end Development
Employees must be able to understand and use the system to generate reports easily and quickly.
Report Development
Should reports be customized?
How will reports be delivered?
Should access to reports be restricted?
Performance Tuning
Review report delivery process and improve efficiency of the system.
Quality Assurance
Check that standard requirements are met and system performs as promised.
Roll-out to Production
Roll-out may involve employee training.
Production Maintenance
On going maintenance of the system.
Backup processes and monitoring.
Incremental Enhancements
Small changes that improve the overall system while it is live.
