Reference no: EM133594057

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.

Assessment Description

The data provided for the assessment represents two store's sales revenue. 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. To provide conclusions, students must use visual inspection, error metrics, and information criteria on the test data.

Assessment Instructions

As a group:

Part A

Use descriptive analytics to compare the two stores in terms of sales revenue.
Provide key insights or findings.

Part B

Use Tableau to generate Holt-Winters forecasts of the next 5 months for the two stores.
Analyse the results of the forecasts in terms of: (1) Accuracy, (2) Alignment with the historical trend, (3) Alignment with the historical seasonality.

Part C

Use Exploratory to generate ARIMA forecasts of the next 5 months for the two stores.
Analyse the results of the forecasts in terms of: (1) Accuracy, (2) Alignment with the historical trend, (3) Alignment with the historical seasonality.

Part D

For each store, compare Holt-Winters and ARIMA forecasting models and advise which models to use.

Part E

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.

As individuals:

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

Attachment:- Forecasting Project.rar