From the course: Excel PivotTables: Mastering PivotTables and PivotCharts
Join today to access over 24,900 courses taught by industry experts.
Getting to know IMDb - Microsoft Excel Tutorial
From the course: Excel PivotTables: Mastering PivotTables and PivotCharts
Getting to know IMDb
- [Instructor] I want to take a minute or two and talk about the IMDB movie database since we will be working with this file for the first few chapters of the course. If you're not familiar with IMDB, it's an acronym that stands for the Internet Movie Data Base and it contains all sorts of information about movie titles released around the world. So we'll be looking at a cut of the IMDB data for the first several sections, which gives us movie titles, attributes, budgets, and revenues from 1920 to 2015. And this is a great file to use to practice pivot table concepts because it contains a number of interesting dimensions and measures. Now the way to think about dimensions, it's kind of those columns that you can use to categorize your data, to roll it up or break it down in interesting ways. So in this case our dimensions include the movie title, the release date, whether it was color or black and white, what genre it falls into, the language, country, rating, and lead actor and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.