Build an interactive report that your managers from MEGACORP can use to:

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Description

You have been hired as an analyst by MEGACORP, a toy manufacturing company. MEGACORP has several manufacturing facilitiesacross the United States. Each manufacturing facility consists of two or more production units that create the products. Each unit manufactures toys for a product line (promotional material, action figures, games, and so on). Next month, the Board of Directors is meeting to discuss thefuture of the company. In the meeting, yourmanager has been askedto present a report focusing on profitability for MEGACORP. The report is necessary to help the Board understand the state of the company before it makes any decisions.

 

Dataset

MEGACORP2020 has daily data for each item produced by a unit between 05JAN2008 and 04JAN2020. The data dictionary containsinformation aboutthe manufacturing facilities, production units, and products. In addition, thetablealso has information about expenses, revenues, andprofits. If a unit did not produce a product on a day, one row is written to the table with a non-active unit status (closed, failure, upgrade, or upkeep). Because no products were produced on these units, product ID values are missing. Data quality stewards have already cleaned and grouped the data, created several new columns, and modified some data properties. You still need to ensure that the data used is ready for analysis and reporting.

Note: If you identify any outliers they can be removed from further analysis. You are required to justify and explain the process and list the cases being eliminated.

 

Goal

You are asked to:

Q1. Build an interactive report that your managers from MEGACORP can use to:

o Explore the data and

o Derive insights from their vast pool of transactional data.

Q2. Employ the following techniques to draw interesting insights and help MEGACORP making informed decisions:

o Linear Regression,

o Forecasting.

Q3. Based on your findings, provide an assessment report of MEGACORP by answering the following questions:

o Is MEGACORP a viable company in its present form?

o What are your recommendations to make the company more profitable?

 

Q4. Include a personal reflection on how you can employ one of the four techniques (LR, clustering, DT, forecasting) to your work/research projects/studies (~300 words).

Questions Q1, Q2 and Q4 are open on purpose. The written report consists of a short introduction, data preparation, models, their interpretation, discussion, and a final recommendation to Q3.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme