How a retail organisation could use the forecast

Reference no: EM133506889 , Length: word count:1000

Data-driven Decision Making and Forecasting

Assessment - A Forecasting Project

Your Task
Apply forecasting techniques to a given dataset and provide a business application of the forecasts. The report is worth 30 marks (see rubric for allocation of these marks).

Assessment Description

A dataset from a retailer that has more than 45 stores in different regions (Public data from Kaggle) has been sourced. The data provided for the assessment represents two stores. Store number 20 has the highest revenue within the country and store 25 does not have a high volume of sales. The objective of the assessment is to develop different demand forecast models for these stores and compare the forecast models in terms of accuracy, trend, and seasonality alignment with the historical data provided. Students must use visual inspection, error metrics and information criteria on the test data to provide conclusions.

Assessment Instructions

In class: You will be presented with a dataset in class. As a group, analyse the dataset using Tableau and Exploratory.io.

You will provide an oral presentation of the group work in parts A to C during the third hour of the workshop.

Write a 1000-word report which briefly summarises the analysis and provides suggestions for further analysis.

As a group:

Part A

- Use Tableau to compare the two stores in terms of sales using adequate visualisation(s).
- Run Holt-Winters forecasts of the next 5 months for stores 20 and 25. analyse the results of the forecasts in terms of:
o Accuracy
o Alignment with the historical trend
o Alignment with the historical seasonality

Part B

- Use Exploratory to generate ARIMA forecasts for stores 20 and 25.
- Create visualisations, interpret and describe your findings.
- Analyse the forecasts in terms of:
o Accuracy.
o Alignment with the historical trend.
o Alignment with the historical seasonality.

Part C

Prepare a presentation:
• Include key findings.
• Highlight methodologies.
• Advise which methods to use for each store.
• Recommend improvements in terms of forecasting for the retailer.
•
Note: All members of the group should be involved in the presentation. The allocated time for the presentation will be decided by your lecturer.

As individuals:

• Briefly summarise the analysis.
• Outline how the dataset, visualisations and forecasts could be improved.
• Describe how a retail organisation could use the forecast for its operation.

Reference no: EM133506889

Questions Cloud

Define relationship of juvenile justice system : Define relationship of juvenile justice system: Restorative justice Court process for juveniles Diversion/alternatives to arrest

Describe desired patient outcomes from a proposed outcomes : Describe your desired patient outcomes from a proposed intervention and the potential impact of the quality improvement project.

What is being done to prevent situations like the one : What is being done to prevent situations like the one you described from happening, or is anything being done at all? For example, have any policies been

Which might actually help strengthen national security : The relationship between trump administration and the dfferent dictators around the world could have long term negative national security implications.

How a retail organisation could use the forecast : DATA4400 Data-driven Decision Making and Forecasting Briefly summarise the analysis Outline how the dataset, visualisations and forecasts could be improved.

What are the evidence of climate change : How did we get to the "11th hour" and this critical moment with our natural environment? (try to tie together things we've been discussing all term).

Design a business email message to send to all the employees : Design a business email message to send to all the employees in your department. These employees are your peers. The email will be from you and will include

Explain the business judgment rule : Explain the "business judgment rule". Describe the provisions of the Corporations Act that empower directors to take commercial risks.

What is purpose of incubation at 50oc when making yogurt : What is the purpose of incubation at 50oC when making yogurt? What is happening to the milk as we culture yogurt?

User Account

All Pages