Homework #4: Movies Dashboard

Data Preprocessing

Before starting my visualizations, I decided what I wanted to graph and excluded all columns and rows that were null or would be of no use. I decided that I wanted to keep the MPAA rating so I subsetted the data to only include movies with an MPAA rating. Also, I decided that since not all of those movies had budgets, I subsetted the data to only include movies with budgets as well. Lastly, I excluded the r columns because I did not see a use for these. Here is the code that I used to do this.

Functionality

• Basic
• Create a prototype of your dashboard in Tableau Public
• Three panels - Number of Movies by MPAA Rating, Rating of Movie vs. Length of Movie, and Average Budget of Movie for each decade
• Two Techniques - Bar plots, and Scatter plot
• Moderate
• Implement the prototype in D3
• Using three different SVGs - created the same plots as Tableau with the same variables and techniques
• Advanced (Pending)
• Implement interactivity between panels
• Click on bar in top chart to filter by that MPAA Rating

How To Interact

• Tableau
• Can hover over the bars or the points to see the values and the movie title
• Can click on the bar or point to fade out the rest to show more detail
• D3
• Can hover over the bars or points to see the values and movie title
• Can click on the bar in top chart to filter both scatter and other bar plot to show only the movies with that MPAA Rating (pending)

Explanation

• The reason I chose to visualize my dashboard like this was because I wanted to see the MPAA Rating and the details behind each of the movies. First, I wanted to just see the overall distribution of the ratings. Majority of the movies listed had no rating, which is why we only end up with less than 2000 movies (after filtering with the budget as well). From this we can see that the majority of the movies are rated R. Then, I wanted to see if there was any correlation between the length of the movie and how people rate it. This we can see in the scatter plot. Lastly, I wanted to include budget somehow so I created another plot that showed the average budget. This I ended up showing by decade. With this last plot, I was hoping to include interactivity where when we filter the top plot by MPAA Rating, we could see the average budget for those movies by decade (instead of the overall).