Chapter 35 Flashcards
1
Q
What are 11 pitfalls in DWH
A
- Weak business sponsor
- Not having multiple servers
- Modeling without domain expert
- Not enough time for ETL
- Low priority for OLAP cubing
- Fixation with technology
- Wrong test bench
- QA not DWH Literate
- Uneducated user
- Improper documentation
- Incremental enhancements
2
Q
What are 10 common mistakes
A
- Indirect interaction
- Ambitious promises
- Liquid requirements
- Senior NOT in loop
- Trying to succeed very first time
- Incorrect assumptions about user competence
- Unrealistic user training
- Isolation between IT users and business users
- Too late the meeting
- Shying from source system people
3
Q
What are 7 key steps for successful DWH
A
- Full type project manager
- Hands off project management
- Do not chase answers
- Assign responsibilities
- Accept many iterations of DWH
- Assign resources for ETL
- Be a diplomat, not a techie
