I CAN SUPPLY DATA SET VIA EXCEL You are a real estate and property management bu

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management business analyst in a big city. Your company’s leadership team supports building reasonably priced housing in areas that have well-performing schools with low school dropout rates (home price and dropout rate are the key factors). You wish to commission a consulting team of business and data analysts to build a full dashboard that will address the best locations for new construction projects within the five boroughs of the city based on the company’s mission and various performance metrics.
You decide to build a basic prototype model of the dashboard using the home price and dropout rate data for one borough. This prototype model will help you explain the project to your company’s leadership before you meet with the consultants who will build the full dashboard with many other predictive factors. You also want to be able to clearly report a data story about the project to the leadership team using your prototype.
To ensure you understand the data that will be included in the dashboard model, you will first need to connect your Excel data with Tableau and look at it visually.
Use the provided “D466 Task 1 Data Set” to complete this task.
Provided model data for the borough:
average three-bedroom home prices by year
average dropout % by year
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Describe the two main factors—home price and dropout rate—in the scenario.
1. Explain, using data from the “D466 Task 1 Data Set,” the current state of home prices.
a. Use Tableau to create an appropriate data visualization that shows the current state of home prices.
b. Identify one design technique you used in the visualization from part A1a and explain how it addresses a common accessibility issue.
c. Identify one design technique different than the one identified in part A1b and explain how it contributes to effective representation of the information in the data set.
2. Explain, using data from the “D466 Task 1 Data Set,” how a change in school dropout rates would affect home prices.
a. Use Tableau to create an appropriate data visualization that shows how a change in school dropout rates (independent variable) would affect home prices (dependent variable).
b. Identify one design technique you used in the visualization from part A2a and explain how it addresses a common accessibility issue.
c. Identify one different design technique than the one used in part A2b and explain how it contributes to effective representation of the information in the data set.