You landed your dream job as a top manager in BestCars, one of the largest car companies in the world.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Part 1 – Data Analytics – Azure Task (40 points)

1. Congratulations! You landed your dream job as a top manager in BestCars, one of the largest car companies in the world. Your first task is to predict your company monthly sales in different markets (different countries). Your data include attributes about the country, and date and online activity data. Below is the description of the attributes:

 

Variable Description

Year Year of sales

Month Month of sales

new.site Indicator if a new website was used

country Country of sales

language Website language

 

Sales Total monthly sales

WebVisits Number of monthly visits to the website

KPI1 Monthly KPI 1 count

KPI2 Monthly KPI 2 count

KPI3 Monthly KPI 3 count

KPI4 Monthly KPI 4 count

avg_trends Google trends data

sum_local_wiki_visits Wikipedia total monthly visits

avg_local_wiki_visits Wikipedia average monthly visits

 

 

Your goal is to build a model to predict the Sales variable.

Your dataset is the file Sales_kpis_data.csv located in the “Final Assignment Datasets” folder.

The file includes 348 rows on monthly data from 9 countries.

a. Test different models (25 points):

i. Run different prediction models in Azure ML, for each model, describe the data preparation, the model you run (provide print screens), the different input parameters, and show the out-of-sample accuracy of your models?

ii. Which model will you implement for predicting sales?

 

b. Feature Selection (15 points)

 

Run additional prediction model that includes the feature selection option in Azure ML. The goal is to improve the accuracy of your model compared to the previous results (1a). Describe the model and explain:

i. How did you choose the number of features?

ii. Which methods did you use?

 

 

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