SQL Add Column
What is the SQL statement that adds a column to an existing table? The SQL statement is the […]
Database
SQL Update Statement
The UPDATE statement is used to modify the existing records in a table. The syntax is as follows. […]
Kaggle Introduction
What is Kaggle? Wikipedia says: “Kaggle, a subsidiary of Google LLC, is an online community of data scientists […]
Data Model Examples in Excel
Do you want to work with a few small & sample data models in Excel to practice the […]
Tiny MeasuresIMDB
Now it’s time to create some Measures in the Tiny IMDB database. A measure is a DAX formula […]
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 […]
Microsoft’s FoodMart Database
It’s always very helpful to have a database to work with when you are learning software such as […]
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 […]