Your assignment is attached as the PDF. This is a simple assignment from Chapter 12. You will need to study Chapter 12 for this assignment. That is why the due date is at the end of Week 15.
The simple dataset that you will use for this assignment is also attached under assignment.
Please create the pivot tables and paste screen shots of your pivot tables in a word document. Please upload the final word document as your assignment. Please make sure you explain your calculations.
The second assignment is about Pivot Tables in Excel. Below you will find links to several tutorials on Pivot Tables:
Please note that the Pivot Tables that you need to create for your assignment are much simpler then the ones used in these YouTube videos.
Marketing Analytics: Case Studies
© Stephan Sorger, 2013; www.StephanSorger.com 1
MARKETING ANALYTICS: Case Study Name: ____________________ © Stephan Sorger 2013; www.stephansorger.com Date: ________________________
Case No. Chapters Case Title
12 12 Pivot Tables: Multi-Channel Pharmacy
Background: You are the marketing manager for Acme Pharmacies, a pharmacy that goes to market with three distribution channels. The channels consist of a retail store, an Internet website, and a kiosk to place orders inside of an Acme Supermarket. You want to understand how sales in the three channels compare, so you decide to create a set of pivot tables to analyze the situation from different perspectives. 1. You assemble the following data set.
Customer Sales Date Product Channel
Martin Mu $700 January Product A Retail Store
Nora Nu $500 February Product B Website
Peter Pi $200 February Product B Retail Store
Rhoda Ro $600 January Product B Website
Sigmund Sigma $800 January Product A Website
Terry Tau $900 February Product A Kiosk
2. Create a pivot table showing sales by product. State the total amount of sales from Product A. Total amount of sales from Product A: $__________ 3. Create a pivot table showing sales by product and by date. State the total amount of sales from Product A for the month of January. Amount of sales from Product A for January: $__________ 4. Create a pivot table showing sales by product, by date, and by channel. State the total amount of sales from Product A for the month of January, sold through the website channel. Amount of sales from Product A for January, sold through website: $__________
