O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4.8. EXERCISES

  1. Match the columns:

    1. top-down approach

    2. single-vendor solution

    3. team roles

    4. team organization

    5. role classifications

    6. user support technician

    7. executive sponsor

    8. project politics

    9. active user participation

    10. source system structures

    1. tightrope walking

    2. not standardized

    3. requisite for success

    4. enterprise data warehouse

    5. consistent look and feel

    6. front office, back office

    7. part of overall plan

    8. right person in right role

    9. front-line support

    10. 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?

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required