IMDB Primary Profession
In the IMDB database, each person in the namebasics.tsv file may have none or more professions. There are […]
Blog
IMDB Name Basics
The namebasics file has all of the people in it. It has the moving pictures that they are […]
IMDB Unique Genres Query
In order to set up our relationships in the Data Model, we need to create another table. This […]
IMDB Title Basics
The titlebasics file is a good file to start with after you have downloaded it. I re-named the […]
Tiny IMDB Average Rating for each Genre
What is the average rating for each of the genres? Does the Comedy genre rate higher than the […]
Tiny IMDB Average Rating for each Person
This post follows from the previous post in this series of posts using a tiny made-up database that […]
Tiny IMDB Data Model Introduction
Tiny Data In this series of posts (“Tiny IMDB Data Model”) we’ll look at the Internet Movie Database […]
IMDB Repeating Genre Values
In working with the IMDB database tables, you find that each moving picture can have one or more […]
IMDB and the Excel Data Model
What if we wanted to import this database into Microsoft Excel and work with it? We want to […]
Choosing a Chart Type
There are lots of graphs you could use. Not all are great choices. Many times choosing simple and […]
Excel SUMIFS Function
The SUMIFS function, adds all of its arguments that meet multiple criteria. First, let’s compare the SUMIF function. […]
Excel Data Entry Forms
Using Excel’s forms you can make your life easier. How? Forms can help you reduce the number of […]