The file Foodmart.mdb contains many transactions at a supermarket chain. Open this file in Access, click on Database Tools and select Relationships to see the relationships diagram. This type of relationship diagram is called a Ă˘â‚¬Ĺ“star schema.Ă˘â‚¬Âť The Facts table includes a record for each line item purchased by any customer at any store on any date. The other tables are called Ă˘â‚¬Ĺ“dimensionsĂ˘â‚¬Âť that facts can be broken down by. This type of database is set up perfectly for pivot tables, where you can break down facts (Revenue or Units Sold) by dimensions. In Microsoft Query, develop a query that uses all of the tables. It should have the following fields: Revenue and Items Sold from Facts; all fields except DateID from Dates; all fields except ProductID from Products; City, Region, State Province, Country, Marital Status, and Gender from Customers; and City, Region, State Province, and Country from Stores. Note that City, Region, State Province, and Country have the same names in the Customers and Stores tables, which can be confusing. Therefore, for each of these, use the Add Column menu item from the Records menu to select these fields and give them names like Customer City and Store City. Return the data to a pivot table in Excel. Then create an interesting pivot table, where you break down Revenue or Items Sold by any of the various dimensions.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You wonâ€™t have to worry about the quality and deadlinesOrder Paper Now