In the following problems, you will import and analyze data from the Foodmart.accdbDownload Foodmart.accdb file. This is an Access database file with five related tables: Customers, Dates, Facts,...

In the following problems, you will import and analyze data from the

Foodmart.accdb


Download Foodmart.accdb




file. This is an Access database file with five related tables:

Customers, Dates, Facts, Products, and Stores. The Facts table, with

over 250,000 rows, has a row for each sale of a product during part of

1997 and 1998. Four of its fields are foreign keys relating the sale to

the other four tables. Its other two fields, the “facts,” are Revenue

and UnitsSold from the sale.

Submit an Excel workbook for each of the following two problems:

1. Use Power Query to create a Data Model consisting of relevant fields
   
   from the Facts and Products tables, where “relevant” means they are
   
   needed for the following. Use a pivot table to find the top three
   
   products in terms of the highest number of sales transactions.


2. Do the same as in the previous problem but now include the Dates
   
   table in the import and find the top four products in terms of the
   
   highest number of sales transactions in 1998.