2.8. EXERCISES

  1. Match the columns:

    1. a.nonvolatile data

    2. dual data granularity

    3. dependent data mart

    4. disparate data

    5. decision support

    6. data staging

    7. data mining

    8. metadata

    9. operational systems

    10. internal data

    1. roadmap for users

    2. subject-oriented

    3. knowledge discovery

    4. private spreadsheets

    5. application flavor

    6. because of multiple sources

    7. details and summary

    8. read-only

    9. workbench for data integration

    10. data from main data warehouse

  2. A data warehouse is subject-oriented. What would be the major critical business subjects for the following companies?

    1. an international manufacturing company

    2. a local community bank

    3. a domestic hotel chain

  3. You are the data analyst on the project team building a data warehouse for an insurance company. List the possible data sources from which you will bring the data into your data warehouse. State your assumptions.

  4. For an airlines company, identify three operational applications that would feed into the data warehouse. What would be the data load and refresh cycles?

  5. Prepare a table showing all the potential users and information delivery methods for a data warehouse supporting a large national grocery chain.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.