case study 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

case study 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

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

case study 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: $__________

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality