Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem Statement The air quality index ( AQI ) is an index for reporting air quality on a daily basis. It is a measure of

Problem Statement
The air quality index (AQI) is an index for reporting air quality on a daily basis. It is a measure of
how air pollution affects one's health within a short time period. The purpose of the AQI is to help
people know how the local air quality impacts their health. The pollutants monitored are Sulphur
Dioxide (SO2), Nitrogen Dioxide (NO2), Particulate Matter (PM10 and PM2.5),Carbon Monoxide
(CO), Ozone(O3) etc.
Central Pollution Control Board is executing a nation-wide programme of ambient air quality
monitoring known as National Air Quality Monitoring Programme (NAMP) and you are part of the
project. As part of the programme, below data has been collected.
Source: This data has been published on Open Government Data platform India by the Ministry of
Environment, Forest and Climate change, and is updated periodically.
You have been tasked to perform an analysis of the data and present the results to the Chairman of
CPCB. With the given context, you need to create a dashboard using TABLEAU. (Use the concepts
learned in the class).
The objectives include
Air_Quality_Analysis
_Data.zip
Demonstrate the VISUALISATION CONTEXT
1. WHO?KNOW YOUR AUDIENCE(First 2 questions are answered for you)
a. List the primary groups or individuals to whom youll be communicating.
CPCB
b. If you had to narrow that to a single person, who would that be?
CPCB CHAIRMAN
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.
Each group consists of up to 3 members. 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
ALL GROUP MEMBERS WILL BE CREDITED THE SAME MARKS. ITS INDIVIDUALS
RESPONSIBILITY TO ENSURE HIS/HER PARTICIPATION AS WELL AS TEAMS
RESPONSIBILITY TO ENSURE EVERYONES PARTICIPATION

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

Advances In Spatial And Temporal Databases 10th International Symposium Sstd 2007 Boston Ma Usa July 2007 Proceedings Lncs 4605

Authors: Dimitris Papadias ,Donghui Zhang ,George Kollios

2007th Edition

3540735399, 978-3540735397

More Books

Students also viewed these Databases questions

Question

Is SHRD compatible with individual career aspirations

Answered: 1 week ago