Tiny MeasuresIMDB
Now it’s time to create some Measures in the Tiny IMDB database. A measure is a DAX formula […]
imdb
Get Other Tables
Now we need to get other tables and create the relationships After we’ve imported all of the tables […]
Get Ratings from Tiny
Next we’ll use Power Query to bring in the ratings data into the Data Model. There are no […]
Build the Tiny Data Model
Below is a link to the downloadable Excel file that contains a sheet with the table we will […]
IMDB Writers and Directors
Let’s go ahead and add a bit more. We’ll add the writer’s and directors’ tables. Below is the […]
IMDB Titles Known For
Each person in the database can be known for certain titles (moving pictures/movies). We need to “normalize” these […]
IMDB Primary Profession
In the IMDB database, each person in the namebasics.tsv file may have none or more professions. There are […]
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 Data Model Introduction
Tiny Data In this series of posts (“Tiny IMDB Data Model”) we’ll look at the Internet Movie Database […]
IMDB and the Excel Data Model
What if we wanted to import this database into Microsoft Excel and work with it? We want to […]