{"id":10821,"date":"2018-10-10T05:26:19","date_gmt":"2018-10-10T09:26:19","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=10821"},"modified":"2019-01-10T23:58:42","modified_gmt":"2019-01-11T04:58:42","slug":"most-popular-movies-2006-2016","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/most-popular-movies-2006-2016\/","title":{"rendered":"Most Popular Movies 2006-2016"},"content":{"rendered":"

\"\"<\/p>\n

 <\/p>\n

Introduction:<\/span><\/strong><\/p>\n

From the year 2006 to 2016, what genre of movie was the most popular? which director made the best box office performances? what kind of films were highest rated by movie buffs and critics?\u00a0 <\/span>Based on the dataset of 1000 highest ranked movies on IMDB, I’ve created a brief dashboard that is able to tell you all the answers and give you a quick look of the movie industry from the last decade. <\/span><\/p>\n

 <\/p>\n

Inspiration:<\/span><\/strong><\/p>\n

I\u2019ve always been passionate about the pop culture especially the movies, so from the very beginning I\u2019ve decided to find a dataset that was related to the entertainment industry. When it came to how to interpret the data, Professor Sula suggested I could analyze the data from based on genre or cast. As for how to visually deliver the data, the\u00a0visualization of the 100 greatest movies <\/a>really inspired me a lot.\u00a0 <\/span>It\u2019s an infographic that that includes: title of Movie, year it was made, oscar nominations and wins, budget, gross, IMDB score, genre, filming location, setting of film, and production studio. The movies are ordered by release date, on the left features oscar wins and nominations. The bar graph represents budget in white and gross in black. The circle size is based on IMDB score and the color refers to genre.<\/span><\/p>\n

\"\"<\/p>\n

 <\/p>\n

Materials:<\/span><\/strong><\/p>\n

I found my dataset \u201cIMDB data from 2006 to 2016<\/em><\/a>\u201d from Kaggle<\/a>.<\/span><\/p>\n

It is a data set of 1,000 most popular movies on IMDB from 2006 to 2016. The data fields included are:<\/span><\/p>\n

Title, Genre, Description, Director, Actors, Year, Runtime, Rating, Votes, Revenue, Metascrore<\/span><\/p>\n

Other tools I\u2019ve used are:<\/span><\/p>\n

OpenRefine\u00a0<\/strong><\/em>and<\/span><\/p>\n

Tableau Public.<\/span><\/strong><\/em><\/p>\n

 <\/p>\n

Goals:<\/strong> <\/span><\/p>\n

I wanted to analyze the data from mainly two aspects: genre and director. I hope the infographics could illustrate the most popular genre and the most successful director, as well as their relationship with revenue, metascore and the count of the movies.<\/span><\/p>\n

 <\/p>\n

Methods, Results and Interpretation:<\/span><\/strong><\/p>\n

The first challenge I\u2019ve come cross was to split and transpose columns. In the original dataset, each movie has more than one genre listed in one column. To analyze the movies by their genres, I needed to split each genre into a individual column and then transpose those columns into a same column again but in different rows. I was able to this with OpenRefine. <\/span><\/p>\n

\"\"<\/span><\/p>\n

 <\/p>\n

To present more information in one infographic, I was trying to do the butterfly chart on Tableau. However, due to the limitation of \u201cdual axis\u201d on Tableau, I could only present two measures on each butterfly chart. I had to add another set of “dual axis” on one side of my butterfly chart to provide more information.\u00a0<\/span><\/p>\n

\"\"<\/p>\n

 <\/p>\n

I also tried to put more measures on each side of the dimension, in order of which I had to accept the huge gap between the measures on each side. Because Tableau Public won\u2019t allow size changes of individual columns(at least that was the fate for me the past weekend-_- ).<\/span><\/p>\n

\"\"<\/p>\n

 <\/p>\n

Arranging the sheets and texts on dashboards was also a long series of experiment, failure and experiment again, but fortunately I finally got the result I wanted.\u00a0\u00a0<\/span><\/p>\n

The link to my final dashboard is :<\/span><\/p>\n

https:\/\/public.tableau.com\/profile\/milo8469#!\/vizhome\/Lab2_174\/Dashboard1?publish=yes<\/span><\/a><\/p>\n

 <\/p>\n

Reflection:<\/span><\/strong><\/p>\n

I really enjoyed doing this project. I have learned a lot about the different skills on Tableau and OpenRefine as well as how to deliver the most efficient information, both logically and visually. However, as much as I love the flexibility of being able to choose our own dataset, and the dataset I\u2019ve chosen, I think my choice was a little bit too simple, which has limited my exploration on Tableau. Also, I didn’t involve the time-oriented measure in my infographic. If I had more time and had learnt more about Tableau or other tools, I\u2019d love to add the time measure to my visualization. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

  Introduction: From the year 2006 to 2016, what genre of movie was the most popular? which director made the best box office performances? what kind of films were highest rated by movie buffs and critics?\u00a0 Based on the dataset of 1000 highest ranked movies on IMDB, I’ve created a brief dashboard that is able…<\/p>\n","protected":false},"author":519,"featured_media":10834,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[340,149],"tags":[],"coauthors":[338],"class_list":["post-10821","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-charts","category-labs"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/10\/best_movies.jpg?fit=912%2C934&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-2Ox","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/10821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/519"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=10821"}],"version-history":[{"count":8,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/10821\/revisions"}],"predecessor-version":[{"id":11018,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/10821\/revisions\/11018"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/10834"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=10821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=10821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=10821"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=10821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}