Create a dashboard with four graphic representations

Assignment Help Other Subject

Reference no: EM132392692

Assignment

You have been hired as a data analyst and one of your first tasks includes selecting a car, primarily for your use, that will become part of the company fleet.

Your manager has already narrowed down the choices to four vehicles: a 2019 Ford Escape, 2019 Honda CRV, 2019 Hyundai Santa Fe, or 2019 Toyota Rav 4. Because you will purchase the car with company funds, your manager has asked you to select a vehicle based on the company's criteria; however, your own criteria for choosing a car are different.

You must use data visualization best practices to create a dashboard, using data you will scrape, and tell a story for your manager to support your car selection.

Criteria 1 (Company Criteria):

Safety features - weighted at 10

Maintenance cost - weighted at 5

Price point - weighted at 7

Criteria 2 (Your Criteria):

Insurance

Fuel Economy

Resale Value

Data Scrapping need to be done through Python and visualization need to be done through Tableau.

Either used Edmunds or JD power site to scrape the data.

Data Scrape

A. Scrape and submit the data for criteria 1 in the scenario.

B. Scrape and submit the data for criteria 2 in the scenario.

Data Configuration

C. Clean the data for criteria 1 and submit with labeled ranges and weights.

D. Clean the data for criteria 2 and submit with labeled ranges and weights. Include the weights you have selected for all three aspects of criteria 2.

E. Combine all the data and submit with labeled ranges and weightings for all six aspects of the criteria sets.

Data Presentation

F. Present your data visually based on criteria 1 in three data visualization or comparative graphic formats.

G. Present your data visually based on criteria 2 in three data visualization or comparative graphic formats.

H. Create a dashboard with four graphic representations, using accurate patterns and proportions, of all of your data for all six aspects of the criteria in the scenario.

Refer to the attachment for the cleaned and uncleaned data.

You can use the Edmund site to obtain the same data for the 2019 model using python.

Attachment:- Data Folder.rar

Reference no: EM132392692

Questions Cloud

Determining the npv of project-niche entertainment systems : Niche Entertainment Systems is setting up to manufacture a new line of video game consoles. The cost of the manufacturing equipment is $1,750,000.

What is the net present value of project : The cost of capital is 18.7 percent p.a. What is the net present value of this project? (in millions to three decimals)

How effective is the airline at controlling the costs : The Airline Research Paper is an individual student effort but with roots in the group collaboration. Students will choose an airline (passenger or cargo).

Rarketable security both for long-term and shorten reasons : What are some of the advantages and disadvantages of holding marketable security both for long-term and shorten reasons?

Create a dashboard with four graphic representations : Create a dashboard with four graphic representations, using accurate patterns and proportions, of all of your data for all six aspects of the criteria.

How much compensation do you expect to earn : You are pursuing your MBA. Total overall debt is $75,000 (6 years). Your desired occupation will earn $55,000 annually.

Standard deduction or itemize deductions : In your reading, you discovered that everyone has the option to take the standard deduction or itemize their deductions.

How you would direct a film based on one of your own stories : Write a Director’s Statement outlining how you would direct a film based on one of your own original stories. Communicate your vision of a film, encompassing it

Calculate an equivalent single amount payable : Calculate an equivalent single amount payable on 1 April 2020 at an interest rate of 12% p.a. compounding half-yearly.

User Account

All Pages