Programming Question

You will create 2 vizzes and combine into 1 dashboard.

• Viz #1 Show the Rate of Prescription Opioid Overdose Deaths between 2013-2019 by Year for each Sex (Female/Male).
• Viz #2 Show the Rate of Prescription Opioid Overdose Deaths between 2013-2019 by Year for each Race (White, Black, Asian, Hispanic, American Indian)
• Using your Tableau knowledge and the data visualization design principles you’ve learned choose the best type of viz for the data.
• Now combine the above 2 vizzes into 1 dashboard.

10/4/23, 8:09 PM
Week 6 Tableau Assignment
Week 6 Tableau Assignment
Start Assignment
Due Sunday by 11:59pm
Points 100
Submitting a text entry box or a file upload
This assignment will be used to explore the Rate of Prescription Opioid Overdose Deaths per 100,000 population in the US
between 2013-2019.
For this assignment, you will need to use this data obtained from the drugabuse.gov website and Rate of Prescription Opioid
Overdose Deaths by Sex and Race (https://wilmu.instructure.com/courses/58135/files/8995463?wrap=1)
(https://wilmu.instructure.com/courses/58135/files/8995463/download?download_frd=1)
Note: Data is provided on multiple tabs. Review: Tableau Knowledge Base Article on using Multiple Data Sources
(https://kb.tableau.com/articles/howto/connecting-multiple-data-sources-without-joining-or-blending)
You will create 2 vizzes and combine into 1 dashboard.
Viz #1 Show the Rate of Prescription Opioid Overdose Deaths between 2013-2019 by Year for each Sex (Female/Male).
Viz #2 Show the Rate of Prescription Opioid Overdose Deaths between 2013-2019 by Year for each Race (White, Black,
Asian, Hispanic, American Indian)
Using your Tableau knowledge and the data visualization design principles you’ve learned choose the best type of viz for the
data.
Now combine the above 2 vizzes into 1 dashboard.
Data Considerations and Required Resources to Review:
Year dimension: You’ll need to change the data type to date rather than number: Change Data Types
(https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles_datatypes.htm)
Filter Year: You have data for years 1999-2019, you will need to filter to only show 2013 – 2019: Filtering
(https://help.tableau.com/current/pro/desktop/en-us/filtering.htm)
Your name must be in the title of the Dashboard. Finally, submit a TWBX file (packaged Tableau workbook) AND a pdf of the
DASHBOARD you’ve created.
Tableau Assignment Rubric
https://wilmu.instructure.com/courses/58135/assignments/1243433
1/3
10/4/23, 8:09 PM
Week 6 Tableau Assignment
Criteria
Content/Originality
Ratings
Pts
25 to >23.75 pts
DISTINGUISHED.
23.75 to >22.25 pts
PROFICIENT.
22.25 to >20.75 pts
SATISFACTORY.
20.75 to >18.5 pts
MARGINAL.
18.5 to >0 pts
UNSATISFACTORY.
Covers topic indepth with
Covers topic indepth. Subject
Includes essential
knowledge about
Includes
essential
Content is minimal
OR there are
details and
examples.
Subject
knowledge is very
good. Work shows
new ideas and
the topic. Subject
knowledge
appears to be
information
about the topic
but there are 1 or
several factual
errors. Uses other
people’s ideas, but
knowledge is
excellent.
insights.
good. Product
shows some
2 factual errors.
does not give them
credit.
Product shows a
large amount of
original thought.
25 pts
original thought.
Ideas are
creative and
inventive.
Organization
25 to >23.75 pts
Content is well
23.75 to >22.25 pts
Uses titles, keys,
22.25 to >20.75 pts
Content is logically
20.75 to >18.5 pts
Uses titles, keys,
18.5 to >0 pts
There was no
organized using
headings or
and /or scales.
Makes good use of
organized for the
most part with
and/or scales to
organize, but the
clear or logical
organizational
bullet lists to
group related
material. Makes
font, color,
graphics, and
effects to enhance
headings or bullet
lists. Makes good
use of font, color,
overall
organization of
topics appears
structure, just
loss of facts.
Use of font,
excellent use of
font, color,
the viz.
graphics, and
effects to enhance
flawed. Makes use
of font, color,
color,
graphics,
the viz.
graphics, effects,
etc. but
occasionally these
effects etc. but
these often
distract from
detract from the
viz content.
the viz content.
graphics, effects,
etc. to enhance
the viz. Product
is not cluttered
with excessive
words etc.
Visual
Visual
Viz/Spelling/Grammar
25 to >23.75 pts
Two or more
23.75 to >22.25 pts
At least one
22.25 to >20.75 pts
Product was basic,
20.75 to >18.5 pts
Product was basic,
18.5 to >0 pts
Product had
working special
effects such as
working special
effects such as
linear, and
adequate and
linear, and
adequate but did
major
technical
custom
animation,
actions, filters
custom animation,
actions, filters etc.
which were all
contained
appropriate viz.
Product was
not contain any
special effects
which enhanced
difficulties or
did not
contain any
etc. which were
all appropriate
appropriate and
enhanced the
relatively free of
technical
the content of the
viz. Product may
special
effects which
and enhanced
the content.
Product was free
content. Product
was relatively free
of technical
difficulties.
have had minor
technical
problems during
enhanced the
content of the
viz.
of technical
difficulties.
difficulties.
25 pts
25 pts
the viz.
25 to >23.75 pts
Visualization(s)
23.75 to >22.25 pts
Visualization(s)
22.25 to >20.75 pts
Visualization(s)
20.75 to >18.5 pts
Visualization(s)
18.5 to >0 pts
Inappropriate
convey information
correctly with
convey
information
was completed
within time limit.
was not
completed.
choice of
plots; poorly
adequate/appropriate
reference
information.
correctly but lack
context for
interpretation.
Three or fewer
misspellings
and/or mechanical
Information was
inaccurate or
missing.
labeled plots;
plots
missing.
25 pts
errors.
https://wilmu.instructure.com/courses/58135/assignments/1243433
2/3
10/4/23, 8:09 PM
Criteria
Week 6 Tableau Assignment
Ratings
Pts
Total Points: 100
https://wilmu.instructure.com/courses/58135/assignments/1243433
3/3
After completing this week’s Tableau assignment, answer the following questions
relating to assignment. Do not use the questions as headings and provide short
answers. Rather develop 2-3 paragraphs that address the questions overall.
1. Audience. Who might your viz be geared towards? Do you feel you delivered
a clear and concise viz, considering your audience? What features did you
specifically incorporate to tell your story to your audience?
2. Visualization. Your Week 3 through Week 6 visualizations will be incorporated
into a Week 7 Tableau story. How does this week’s viz complement the
visualizations you created in Weeks 3 and 4? Do you think you will make any
adjustments to this week’s or your previous weeks’ visualizations to tell a
cohesive final story? Why or why not?
3. What. What specifically does this week’s visualization tell the audience? Is it
showing any trends, patterns, outliers, or any other relationships?
4. Storytelling. How did you incorporate this week’s lessons from the Knaflic
storytelling text into your visualization? What specific design element(s) have
you intentionally incorporated into your viz and what is your purpose in
including them?
Papers must be written using APA style guide (APA cover sheet, citations/references):
1. Claims and/or point-of-view supported with evidence (sources) and/or logic.
2. Quality of writing (spelling, grammar, succinct yet thorough).
3. Content not to exceed 2 double-spaced pages (excluding cover sheet, tables
and figures, and references page) with Times New Roman, 12-point font.