Data warehousing

1. State any three factors that indicate the continued growth in data warehousing and business intelligence. Can you think of some examples?

2. Why do data warehouses continue to grow in size, storing huge amounts of data? Give any three reasons.

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

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

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.

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

a. an international manufacturing company

b. a local community bank

c. a domestic hotel chain

Solution: