Answered step by step
Verified Expert Solution
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 SO Nitrogen Dioxide NO Particulate Matter PM and PMCarbon Monoxide
CO OzoneO etc.
Central Pollution Control Board is executing a nationwide 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
AirQualityAnalysis
Data.zip
Demonstrate the VISUALISATION CONTEXT
WHO?KNOW YOUR AUDIENCEFirst 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
WHAT?
What are you trying to communicate? What questions are you trying to
answerdisplay in your visualizations? Write these as specific questions. You need
to come up with questions at least, each of which will be answered using one Viz.
Data preparation needed to answer the specific queries must be done.
Present the BIG IDEA.
It should: articulate your point of view, convey whats at stake, and be a
complete and single! sentence.
HOW?
a Chart : What type of viz did you create? Why did you select the viz that you did?
b Chart : What type of viz did you create? Why did you select the viz that you did?
c Chart : 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 Gestalt principles employed.
e For each of the Visualisation, mention how you strategically used preattentive
attributes to draw the audience's attention.
Create your dashboard
Deliverables
Zipped file containing
The word doc with answers to question through above.
The tableau workbooktwbx with SheetsEach sheet should have visual and
Dashboard comprising all three visuals.
The source file after preprocessingif any
The file name should be the respective group name.
Deadline
The strict deadline for submission of the assignment is EoD.
Late submissions wont be evaluated.
How to submit
This is a group assignment.
Each group consists of up to 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.
Evaluation
Sl
No
Criteria Description
Know your audience.
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.
WHAT?
Effective Formulation of
Contextual Questions
Identify what needs to be communicated very clearly
and frame the questions accordingly justifying the
context.
BIG IDEA The Big Idea can help us get clear and succinct on the
main message we want to get across to our audience
Choice of appropriate visuals
Identify the appropriate visuals for communicating the
message
No clutter in the visuals
The visuals presented should not have any unwanted
elements that reduces the understanding of data
Audience attention
The visuals presented should have the right kind of
visual cues that helps the audience to focus the
attention wherever required.
Dashboard in Tableau
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 HISHER PARTICIPATION AS WELL AS TEAMS
RESPONSIBILITY TO ENSURE EVERYONES PARTICIPATION
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started