Map Reduce
What is Map Reduce? First of all, this is an advanced topic, however we need to be aware […]
model
Evaluate Supervised Categorical Models
In the forth of four stages of the PACE Framework of Google, lies the Evaluate stage. The first […]
Data Modeling
What is a data model? A data model is the result of a data modeling process. Data modeling […]
Data Model Examples in Excel
Do you want to work with a few small & sample data models in Excel to practice the […]
Power Pivot Filtering
As an example, let’s look at the FoodMart database in Excel’s Power Pivot. The first thing to do […]
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 and the Excel Data Model
What if we wanted to import this database into Microsoft Excel and work with it? We want to […]
Excel Pivot Tables Date Grouping
Dates can be a bit tricky. For the best solution to working with dates in our Pivot Table […]
Excel Table Relationships
Suppose you have two tables of data in Excel that are related. As an example, you might have […]
Microsoft Power Apps
What is Power Apps? Power Apps is a suite of apps, services, and connectors, as well as a […]
C# Lists of Class Objects 2
We are going to move our example along to the next stage after the previous post. Here we […]