Assignment # 4: Time Series Visualization Using Tableau Public

 The goal of this assignment is for you to create a time-series visualization using Tableau Public based on a curated dataset. You will work with Monthly Modal Time Series data sourced from Data.gov, which contains 12 different variables. Click here 

Download hereto download this set (this data set was created in Microsoft Excel format). You will select 6 variables of your choice from the 12 available in this dataset. Remove the other 6 variables to focus your analysis on meaningful trends.  Upload the modified dataset to Tableau Public and design a time-series visualization that effectively communicates insights from your selected variables.
Post your work in Tableau in your blog and share your with us

Submission Guidelines

•Post a brief reflection on your blog explaining:

•Why you selected only six variables

•The insights gained from your time-series visualization

•Any challenges encountered in working with Tableau Public







The six variables I have chosen are Year, Collisions with Motor Vehicles, Collisions with Person, Ridership, Vehicle Revenue Hours, and Vehicle Revenue Miles. I wanted to compare these variables over a period of time. To be more specific, from 2014 to 2019. I believe these variables are able to showcase a relationship between the time spent operating a vehicle could lead to a higher possibility of either collisions with other vehicles or even people. At first I made a separate graph for each variable over a period of time. At the end, I merged all of the graphs to demonstrate the relationship between these variables. My findings were surprising. From the years 2014 to 2016, collisions with vehicles and people show an increase. However, ridership decreases during these years.

I did have some challenges when working with Tableu but like any new platform, I have to continue getting used to it. 



Vehicle Revenue Miles per Year





Vehicle Revenue Hours per Year



Collisions with Motor Vehicle per Year




Collisions with people per year




Ridership per year






All Variables 



















Comments

Post a Comment

Popular posts from this blog

Final Project

Image
What Affects College Graduation Rates? LIS4317 Final Project After a long semester, we have reached the end of LIS4317, Visual Analytics! Using what I have gained from this course, I will establish work that will represent the numerous topics covered. The best way to accomplish this is by answering a question or issue that I am experiencing in my own life. In a few short days, I am expected to graduate from the University of South Florida. A challenging, but rewarding experience to which I will be forever grateful for. However, this brought upon the question of college graduation and the hurdles that come along with completion. What factors play into an individual graduating? How many people actually graduate from college? Do specific locations lead to more college graduates? How much does financial aid impact the graduation process? Using this dataset titled  College Completion Dataset , from Kaggle, I will answer these questions through various visualization methods.  The so...
Read more

Module # 12

Image
  Your assignment is to create your first visual Social Network analysis. You can select from any two platforms you feel more comfortable with. The first is called  NodeXL Links to an external site. . It is based on Microsoft Excel support platform. To download NodeXL package for Microsoft Excel click  here Links to an external site.  (Links to an external site.) Links to an external site. . Make sure you have Microsoft Excel in your computer. For full documentation on how to use NodeXL, click  here Links to an external site.  (Links to an external site.) Links to an external site. . ( https://www.smrfoundation.org/nodexl Links to an external site. ) The second option is using Rstudio. In my presentation, I used ggnet2: network visualization with ggplot2. The creator of this page is  Ehsan Aghaei.  (Links to an external site.) Links to an external site.  You can find the full documentation on his code o...
Read more

Module # 13

Image
Your assignment: Create a simple animation and discussion the result in your blog posting.  Reference to Yihui Xie's and animation R package website, click  here . A note, his package now available via CRAM repository and not GitHub.  For Bryan's blog posting on Animation in R, click  here   A note: In order to post your work on blog, you need to save your animation. The code for saving the image you created in R is as follow: saveGIF({     for (i in 1:10) plot(runif(10), ylim = 0:1) }) Working on this assignment was incredibly interesting. Before this module, I had no idea we could create animations through R studio.  Below is an animation for the code that was given for this assignment.  > saveGIF({ + for (i in 1:10) plot(runif(10), ylim = 0:1) + }) Now I will focus on my rendition of an animation through R.  The first animation I created was a relatively simple one where I demonstrated an investment account after a cons...
Read more