Project: Movies Data Analysis, Part 1

Let’s tackle a new set of data! This data is from The Movie Database (Links to an external site.). (It was downloaded a couple of years ago, so it is slightly dated, but we can practice with it nevertheless!)

Working through this project together (using my videos), we can take what we’ve been working on this term and revisit, review, and put it into practice!

Download & Setup

Start with this file:

TMDB_5000_movies.xlsx

Make a copy and rename it:

Yourlastname_Movies_Part1.xlsx

Detailed Instructions

This is a two-part project. In this project, we will open the data, get it ready for analysis, and then conduct some analysis to get some interesting insights into this data.

Follow this video guide, both Video 1 and Video 2:

Video 1

https://youtu.be/f1lMQBEgmuU (Links to an external site.)

Video 2

https://youtu.be/FpAvUHQzRfI (Links to an external site.)

If you’d like to download the videos for easier use offline, here are links to downloadable versions from my OneDrive:

Video 1 (24:18) (Links to an external site.)

Video 2 (Links to an external site.) (15:34) (Links to an external site.) (Links to an external site.)

Submit

Submit your completed Excel file after following the steps in Videos 1 and 2 above!

Discussion: Movies Data Analysis Part 1

Use this discussion board to share tips, recommendations, and discussion regarding the projects in this module. To foster dialogue, I’m requiring everyone to post something — whether a question, a reflection, or feedback to other users.

Here are recommended ideas to prompt your contributions:

Have you gotten stuck? You’re undoubtedly not alone. Please describe your problem and include screenshots if relevant.

Can you provide help in response to another student’s question? If so, please do!

Did you discover any helpful tips in this process? Please share it. Provide relevant screenshots, links, etc.

Project: Movies Data Analysis, Part 2

Now let’s enrich our analysis of this movies data by adding some calculated fields and creating corresponding pivot tables and charts.

Begin where you left off

Make a copy of the Excel file you used for Part 1 of this project.

Name the new file: Yourlastname_Movies_Part2.xlsx

Detailed Instructions

Pick up where we left off last time, with Video 3 and 4:

Video 3

https://youtu.be/PGxUmBgUEGw (Links to an external site.)

Video 4

https://youtu.be/dBApVIg0JIM (Links to an external site.)

If you’d like to download the videos for easier use offline, here are links to downloadable versions from my OneDrive:

Video 3 (10:16) (Links to an external site.)

Video 4 (11:47) (Links to an external site.)

Submit

Submit your completed Excel file after following the video guide!

Discussion: Movies Data Analysis Part 2

Use this discussion board to share tips, recommendations, and discussion regarding the projects in this module. To foster dialogue, I’m requiring everyone to post something — whether a question, a reflection, or feedback to other users.

Here are recommended ideas to prompt your contributions:

Have you gotten stuck? You’re undoubtedly not alone. Please describe your problem and include screenshots if relevant.

Can you provide help in response to another student’s question? If so, please do!

Did you discover any helpful tips in this process? Please share it. Provide relevant screenshots, links, etc.