Chapter 35

Question 1

What are 11 pitfalls in DWH

Answer 1

1. Weak business sponsor
2. Not having multiple servers
3. Modeling without domain expert
4. Not enough time for ETL
5. Low priority for OLAP cubing
6. Fixation with technology
7. Wrong test bench
8. QA not DWH Literate
9. Uneducated user
10. Improper documentation
11. Incremental enhancements

Question 2

What are 10 common mistakes

Answer 2

1. Indirect interaction
2. Ambitious promises
3. Liquid requirements
4. Senior NOT in loop
5. Trying to succeed very first time
6. Incorrect assumptions about user competence
7. Unrealistic user training
8. Isolation between IT users and business users
9. Too late the meeting
10. Shying from source system people

Question 3

What are 7 key steps for successful DWH

Answer 3

1. Full type project manager
2. Hands off project management
3. Do not chase answers
4. Assign responsibilities
5. Accept many iterations of DWH
6. Assign resources for ETL
7. Be a diplomat, not a techie