heritage
Instructions: Use the Heritage Coffee data provided in Canvas to create pivot tables and a dashboard. Based on the information available to you in your pivot tables and dashboard, provide answers to the following questions.
Team Members:
Q1 The owner of Heritage Coffee believes the summer help does not provide adequate service quality and would like to revisit their hiring policy. Does the data support this supposition and decision? (in this example June, July and August represent summer months).
Q2 The owner of Heritage Coffee understands that the metrics associated with competitiveness influence customer satisfaction (see “categories of marketing metrics” in Marketing Strategy slides). To gain a better understanding of how well her business is performing, the owner would like you to visually depict which aspects of her business are improving, flat and declining.
Q2b Based on your findings, what recommendations might you make to the owner?
Q3 What trends do you see in relation to overall experience and likelihood to recommend? How do you reconcile differences between the two if they exist?
Q4 Which social media platform has seen the most growth in terms of followers?
Q5 You have hired an intern to monitor and respond to comments made on two of the four social media platforms you currently have a presence on. Which platforms would you assign the interns to and why?
Q6 You ran an email campaign in March 2019 to promote Heritage Coffee’s App. Was it effective? Graphically depict the effect of the email campaign on app downloads.
Submit the following to Canvas:
- Your written answers to each of the questions above. Highlight the question in bold font and provide your answer below.
- A screenshot of a dashboard with each of your six tables.
This assignment will not be graded; however, it will count toward class participation.
