Module 1: Auto Insurance by States in 2020

In this assignment, you are going to create a visualization using the dataset provided. Before you start this assignment, I want to introduce you to the Make Over Monday Project. Makeover Monday is a hugely popular social data project linking hundreds of members from the global data viz community in an effort to create better charts and more useful data stories. You can learn more about Make Over Monday hereLinks to an external site..

In this assignment, you will visualize the auto insurance rate by state in 2020. I found this dataset on Make Over Monday. The dataset is originally published on Data World. You can download the dataset hereLinks to an external site.. To get access to the Make Over Monday website, you need to register on the webpage by clicking on “Join”. Registration is free.

First, open the Excel file in Tableau. Next address the following: 

What is the difference between dimensions and measures on Tableau? What is the color of the “State” pill? What does this color imply? Is State a dimension or a measure? How about Full Coverage? 

Using a bar chart construct a graph to rank states from highest full coverage to the lowest full coverage. 

Using the marks pane, add a different color to each state. 

Using the marks pane, add the amount of full coverage in text to each bar. 

Title this chart “Auto Insurance Coverage by State Bar Chart” and save this chart in a PDF document and title this document “Auto Insurance Coverage by State Bar Chart”. 

Using another type of chart (other than bar) that you think is more effective, construct a graph to rank states from highest minimum coverage to the lowest minimum coverage. 

Using the marks pane, add a different color to each state. 

Using the marks pane, add the amount of minimum coverage in text to the graph. 

Title this chart “Auto Insurance Coverage by State [insert Chart Type here] Chart” and save this chart in a PDF document and title this document “Auto Insurance Coverage by State [Insert Chart Type here] Chart”. 

What do you think: What is the best way to visualize minimum coverage? Why do you think the chart you have chosen is more effective than a bar chart? Explain. 

You can find good examples of visualizations of this dataset on the Data World webpageLinks to an external site.. To get access to Data World, you need to register on the webpage. Registration is free.