MSDA 673 MODULE 5 HOMEWORK (50 POINTS)  Please copy your Homework 4 submission and save it as “MSDA 673 – M5 HW Your name.”  Add your full name to the title of the dashboard and story (e.g., dashboard by Ying Wang)

MSDA 673 MODULE 5 HOMEWORK (50 POINTS)

 Please copy your Homework 4 submission and save it as “MSDA 673 – M5 HW
Your name.”
 Add your full name to the title of the dashboard and story (e.g., dashboard by Ying
Wang). Otherwise, I will give you 0 points.
 Be sure to save your Tableau file as “.twbx” type, upload it to your Tableau Public
account, and paste the link in this file.
Visual 1 (28 points): Dashboard

1. Using Donut Chart, Dual Layer Map (Chart), and Pareto Chart to create a dashboard.
   a. change the size of dashboard into automatic
2. Format the dashboard:
   a. check the color legends to ensure one color only represents one thing in the
   dashboard
   b. convert color legends into floating objects and make them close to their
   corresponding charts; remove them from the dashboard if they are not needed.
   c. remove duplicated filters if any.
   d. make the filter(s) apply to all worksheets
   e. change the style of the filter(s) into single value (dropdown)
   f. remove all titles
   g. add a dynamic title on the top of the dashboard; add your full name to the title
   h. apply the filter(s) to the dynamic title
   i. move the filter to the right side of the dashboard title
   j. select an image related to cars or car thefts and add it to your dashboard.
   k. add a navigation button to the dashboard and navigate to Dual Line Chart.
   l. Use blank objects to increase the space between charts.
3. In Midwest,
   a. Which car manufacturer’s cars were most stolen (those contribute to 80% of
   total thefts)?
   b. Which state has the highest instances of car thefts?
   c. In that state (your answer in b), which car manufacturer’s cars are most
   commonly stolen?
   Visual 2 (17 points): Storytelling
4. Using the charts related to the car thefts dataset in this Tableau file to create a story
   containing at least three (3) story points
   a. change the size of the story into automatic
   b. 1 st story point: give a brief summary of the story, including the importance of
   understanding car thefts information (you could find some related information
   from the Internet), the main idea supported by the charts
   c. apply at least two (2) data story types in the whole story; feel free to create more
   charts if needed.
   d. Specify the types that you applied in the story:
   e. Add a story title; add your name in the title

2

Submission (5 points):

1. Save your work as (*.twbx) file and name it “MSDA 673 M5 HW – Your Name”.
2. Submit it to your Tableau Public account
3. Paste the link here:
   URL:
4. Submit this word document and your tableau file to the blackboard.