DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

4.8. EXERCISES

1. Match the columns:

   top-down approach single-vendor solution team roles team organization role classifications user support technician executive sponsor project politics active user participation source system structures

   tightrope walking not standardized requisite for success enterprise data warehouse consistent look and feel front office, back office part of overall plan right person in right role front-line support guide and support project

2. As the recently assigned project manager, you are required to work with the executive sponsor to write a justification without detailed ROI calculations for the first data warehouse project in your company. Write a justification report to be included in the planning document.

3. You are the data transformation specialist for the first data warehouse project in an airlines company. Prepare a project task list to include all the detailed tasks needed for data extraction and transformation.

4. Why do you think user participation is absolutely essential for success? As a member of the recently formed data warehouse team in a banking business, your job is to write a report on how the user departments can best participate in the development. What specific responsibilities for the users will you include in your report?

5. As the lead architect for a data warehouse in a large domestic retail store chain, pre -pare a list of project tasks relating to designing the architecture. In which development phases will these tasks be performed?