Develop forecasting models and model evaluation metrics

Assignment Help Other Subject
Reference no: EM133801486

Data-driven Forecasting

Assessment - A Forecasting Project

Your Task
Apply forecasting techniques to a given dataset and provide a business application of the forecasts.

Assessment Description
You will be provided with a dataset and a detailed assessment brief on the day of the assessment.
The data provided for the assessment are a time series of monthly sales revenue for two stores.
The objective of the assessment is to use Exploratory, Tableau, and Excel software to:
describe the time series
develop Prophet and Holt-Winters demand forecast models for the two stores
compare forecasts from these models.

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 D during the third hour of the workshop.

The data set will be posted or emailed to you at the beginning of class in Week 5.
After Class: Individually perform a follow up analysis, based on a different data set, and which will include the use of Excel. Submit your report and Excel file. This component of the assessment is to be submitted via Turnitin, within 48 hours of midnight of the day of your class in Week 5.

As a group:
You will be provided with a dataset and a detailed assessment brief on the day of the assessment. Get It Done Today!

Load data into a BI tool

Develop appropriate plots to characterise data.

Develop forecasting models and model evaluation metrics.

Prepare a PowerPoint presentation with your answers. Include screenshots showing how you use the software, and of the information provided by the software.

Present your slide deck in class in the final hour.

As individuals:
You will be provided with a dataset and a detailed assessment brief on the day of the assessment.

Divide your dataset into train and test data.

Plot training series plus HW forecasts for the test year in Tableau.
Plot training series plus Prophet forecasts for test year in Exploratory.
Selecting from statistics given in Tableau and Exploratory, construct a table of RMSE within the training series by method by store.
Make calculations in Excel and construct a table of RMSE in the test series by method by store.
Comment on the statistics observed in the above steps.
Make calculations in Excel and find the MASE.

Reference no: EM133801486

Questions Cloud

Our judicial system in action : The courtroom is one place where we see our judicial system in action. There are many players in the courtroom, including the judge, jury
Why in the current modern business integration of economic : Why in the current modern business, the integration of economic affairs from design to completion is an important priority for every Manufacturing company?
Exclusionary rule is applied differently to identifications : Explain how the exclusionary rule is applied differently to identifications than other types of evidence and the relevant cases on the issue.
How can you use it as an agile adoption pattern : Consider the Shu-Ha-Ri model of skills acquisition, how can you use it as an Agile Adoption Pattern. Provide an example from your workplace.
Develop forecasting models and model evaluation metrics : Data-driven Forecasting Assessment - Develop appropriate plots to characterise data and Develop forecasting models and model evaluation metrics
How might you remedy that next time : If you felt confident, what added to that feeling of confidence, and how could you replicate it? If you felt nervous, how might you remedy that next time?
Explore parts of westlaw-lexis and bloomberg law : Explore parts of Westlaw, Lexis, and Bloomberg Law, review the layout and features of these three services
How well did the leaders of the organization respond : how well did the leaders of the organization respond and prepare for the change? What worked and what did not work with the strategies they implemented?
Paul is accused of indecently assaulting mary : Paul is accused of indecently assaulting Mary at the Soul Plaza Cinema at around midday on a Sunday morning. At his trial Paul elects to give evidence

Reviews

len3801486

12/11/2024 10:57:05 PM

There are 2 files attached one is the data file and otner one is the assesment brief file. In the brief file the first step is done i have selected the specif data and i have done the date part also in the above shared excell you can start from the point where i mentioned start from here in the word file.

len3801486

12/11/2024 10:56:56 PM

Let me know if you can do the individual part on time Group part is done i want only the individual part

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd