Database Design Introduction
Over at the website SQL Server Central they have series of articles that they group into what they […]
Blog
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 […]
Excel Filter Function
The new Excel FILTER function is one of the new dynamic arrays that are available in Microsoft 365. […]
Excel Date and Time
All dates in Excel has an associated date value, which is how Excel calculates the passage of time […]
Excel SUMPRODUCT Function
Below is an example of the SUMPRODUCT function. SUMPRODUCT multiplies corresponding cells from multiple arrays and returns the […]
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 […]