Excel SUMPRODUCT Function
Below is an example of the SUMPRODUCT function. SUMPRODUCT multiplies corresponding cells from multiple arrays and returns the […]
Blog
DAX Introduction
What is DAX? DAX stands for Data Analysis Expressions. Data Analysis Expressions (DAX) is a Functional Language that […]
Power Pivot Filtering
As an example, let’s look at the FoodMart database in Excel’s Power Pivot. The first thing to do […]
Excel Pivot and Unpivot
Many of the transformations in Power Query are fairly easy to grasp but other ones, such as Pivotting […]
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 […]
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 […]