Forecasting Beer Demand at Anadolu Efes Beer
Phase 1 Descriptive Analytics
In this first phase of the case study you will conduct a descriptive analysis of the case data (provided in the Data.xlsx excel file)
Complete the following task (listed below). Your deliverable is a Word document containing visuals that you create and any associated commentary. This document does not need to be in a formal style.
Task 1 Plot monthly beer demand. Describe the patterns you observe in this plot in a short paragraph.
There are 84 data points (months). Do not use a pivot table, just plot the raw data and describe what patters you see.
X Axis = Time (Jan, Feb, Mar)
Y Axis = Beer Consumption
Show beer consumption over time using raw data.
Task 2 Plot the tourist data (by country). Use a single appropriate plot. Describe the patterns you observe in this plot in a short paragraph.
Tourist data over 84 months. Mention spikes in beer consumption in the summer or fall by each county.
Describe the patterns you notice on a word doc.
Task 3 Create appropriate plots to evaluate the idea that consumers substitute products based upon price. For example, if beer prices are already low, a consumer may choose beer over raki. Write a short paragraph summary of your findings.
Relationship Beer vs Raki (local liquor)
Just a raw data plot not using a pivot table, just a visualization.
Task 4 Create an appropriate plot to evaluate the effect of Ramadan on beer consumption. Write a short paragraph summary of your findings.
Plot how Ramadan (religious holiday) reduces beer consumption. It’s not always on the same dates each year use the table on the attached word (instructions) doc to know the dates for the plot.
Let me know if you have any more questions. Thank you!
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."