The sales department of the Hot Cash Corporation is responsible for generating invoices and sending them to customers. In the past months they have received a high volume of calls from clients complaining that they do not receive their invoices. The sales manager investigates the situation and finds that the person in charge of generating the invoices has to wait to receive information from different areas to then generate the invoices and send them to the customers. This situation causes discomfort for the manager because the invoices contain basic information that should be easy to obtain.

Your job as a business intelligence consultant is to evaluate all the invoices and what are the steps to create them, and then recommend the creation of a dimensional model. For this reason, you must analyze the attached invoice document and answer a few brief questions.

1) What type of data can you identify on the invoice?

2) What questions would you ask employees about the business processes they run to complete the information on the invoice?

3) List four activities that you must perform in order to create a dimensional database model and explain the tasks that are performed in each of the activities. These activities should facilitate the delivery of information for the creation of the invoice. One of the example activities could be data transformation.

4) Explain the importance of owning the data stored in the data warehouse and not just in the transactional databases.

Billed To Vandelay Group 123 Main Street Townsville, Ontario M4L2DY