Robatelli’s Continuing Case Solution Chapter 13
Do not make these Teaching Notes available for the general public. Please do not post
Teaching Notes on an open website where they can be scanned by Google. When the
Teaching Notes have been posted openly online in the past, it has caused problems for
faculty at other institutions who are using the Teaching Notes in their classes.
a. Describe the purpose of a data warehouse and describe how Annheuser-Busch
uses data warehousing.
A data warehouse is a collection of enterprise wide data and external data gathered
b. Describe the purpose and use of data mining and describe how Anheuser-Busch
uses data mining.
Data mining is the process of analyzing the data in a data warehouse to determine
trends, patterns, or relationships in the data. For example, Anheuser-Busch uses
c. Describe how data warehousing and data mining can facilitate reporting and
analysis at Robatelli’s.
A data warehouse and data mining could be similarly used Robatelli’s. Robatelli’s
would first need to build a data warehouse that would include detailed sales data by
source: store, phone and web. In addition to this internal sales data, the company
more time consuming and labor intensive task. Data mining uses the power of the
computer to analyze large volumes of data to search for sales patterns or trends.