Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem Statement Coronavirus disease 2019 (COVID19) is an infectious disease caused by severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2). It was first identified in December

Problem Statement Coronavirus disease 2019 (COVID19) is an infectious disease caused by severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2). It was first identified in December 2019 in Wuhan, Hubei, China, and has resulted in an ongoing pandemic. As of 17 September 2020, more than 29.8 million cases have been reported across 188 countries and territories with more than 940,000 deaths; more than 20.3 million people have recovered. As the number of cases were increasing day by day, Indian Government has taken multiple measures to handle the situation which includes the lockdown for the entire nation. However, the primary purpose of the lockdown was to slow down the spread of the disease and give time to governments, both Centre and states, to be better prepared on all fronts to deal with the fallout of rising infections and a drastically slowing economy. Assuming the trajectory of new cases starts showing a flattening curve, the costs of extending the lockdown will far exceed the benefits. Now there are discussions about partial reopening of Colleges /Schools as well. With the Government planning to reopen colleges, the principal of the Engineering College where you studied wanted to give an awareness webinar to the students before they start attending classes. Knowing that you are a Data Science Consultant, he thought that you would be the best candidate for the purpose. With the given context, you need to create a dashboard using TABLEAU. (Use the concepts learned in the class).

Data preparation has to be done. If required, feel free to make proper assumptions about the data and the analysis process to be followed. Dont forget to mention the assumptions at the right places. states.xlsx state_wise_daily.csv

india state wise covid data

Consider adding the below disclaimer to your dashboard. Disclaimer: I am a data visualization student, not an infectious disease expert or epidemiologist. This dashboard was created only to fulfil the academic requirements of the course and should not be used for medical decision making. .I bear no responsibility towards the correctness of the data. The disclaimer can be added as a footnote or other text on the page, as a tooltip, or even as a collapsible floating container that almost requires that a reader review and close the box to view the visualizations. The objectives include Demonstrate the VISUALISATION CONTEXT 1. KNOW YOUR AUDIENCE (First question is answered for you) a. List the primary groups or individuals to whom youll be communicating. The students of Engineering College b. If you had to narrow that to a single person, who would that be? c. What does your audience care about? d. What action does your audience need to take? e. What is at stake? What is the benefit if the audience acts in the way you want them to? What are the risks if they dont? 2. WHAT? What are you trying to communicate? What questions are you trying to answer/display in your visualizations? Write these as specific questions. You need to come up with 3 questions at least, each of which will be answered using one Viz. Data preparation needed to answer the specific queries must be done. 3. Present the BIG IDEA. It should: (1) articulate your point of view, (2) convey whats at stake, and (3) be a complete (and single!) sentence. 4. HOW? a. Chart 1: What type of viz did you create? Why did you select the viz that you did? b. Chart 2: What type of viz did you create? Why did you select the viz that you did? c. Chart 3: What type of viz did you create? Why did you select the viz that you did? d. For each of the Visualisation, identify at least 3 Gestalt principles employed. e. For each of the Visualisation, mention how you strategically used pre-attentive attributes to draw the audience's attention. 5. Create your dashboard

2. Deliverables Zipped file containing 1. The word doc with answers to question 1 through 4 above. 2. The tableau workbook(.twbx) with 3 Sheets(Each sheet should have 1 visual) and 1 Dashboard comprising all three visuals. 3. The source file after preprocessing(if any). The file name should be the respective group name. 3. Deadline The strict deadline for submission of the assignment is EoD. Late submissions wont be evaluated. 4. How to submit This is a group assignment. All members of the group will work on the same problem statement. Each group should zip the deliverables and upload in CANVAS in respective locations under ASSIGNMENT Tab. Assignment submitted via means other than through CANVAS will not be graded 5. Evaluation Sl. No Criteria Description 1 Know your audience. (10%) Getting to know our audience and understanding their needs and what drives them is an important early part of the process for successfully communicating with data. 2. WHAT? Effective Formulation of Contextual Questions (25%) Identify what needs to be communicated very clearly and frame the questions accordingly justifying the context. 3 BIG IDEA (10%) The Big Idea can help us get clear and succinct on the main message we want to get across to our audience 4 Choice of appropriate visuals (25%) Identify the appropriate visuals for communicating the message 5 No clutter in the visuals (10%) The visuals presented should not have any unwanted elements that reduces the understanding of data

6 Audience attention (10%) The visuals presented should have the right kind of visual cues that helps the audience to focus the attention wherever required. 7 Dashboard in Tableau (10%) Use Principles of Effective Dashboard Design to come up with an interesting Dashboard .

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

PC Magazine Guide To Client Server Databases

Authors: Joe Salemi

1st Edition

156276070X, 978-1562760700

More Books

Students also viewed these Databases questions