DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

5.8. EXERCISES

1. Indicate if true or false:

   1. Requirements definitions for a sales processing operational system and a sales analysis data warehouse are very similar.

   2. Managers think in terms of business dimensions for analysis.

   3. Unit sales and product costs are examples of business dimensions.

   4. Dimension hierarchies relate to drill-down analysis.

   5. Categories are attributes of business dimensions.

   6. JAD is a methodology for one-on-one interviews.

   7. It is not always necessary to conduct preinterview research.

   8. The departmental users provide information about the company's overall direction.

   9. Departmental managers are very good sources for information on data structures of operational systems.

   10. Information package diagrams are essential parts of the formal requirements definition document.

2. You are the Vice President of Marketing for a nation-wide appliance manufacturer with three production plants. Describe any three different ways you will tend to analyze your sales. What are the business dimensions for your analysis?

3. BigBook, Inc. is a large book distributor with domestic and international distribution channels. The company orders from publishers and distributes publications to all the leading booksellers. Initially, you want to build a data warehouse to analyze shipments that are made from the company's many warehouses. Determine the metrics or facts and the business dimensions. Prepare an information package diagram.

4. You are on the data warehouse project of AuctionsPlus.com, an Internet auction company ...