Creating explorations and models

Objectives: in this exercise we will learn how to create an exploration, and how to create and use models

Creating an exploration

In this exercise we need to:

Add the number of customers per number of orders

Until now we were using the Order exploration, that was getting data from the order table.

Here, we want to have a chart representing the number of customer per number of order. Some customers may not have placed an order, and we want to count them. So we will need to start our exploration from the customer table and group our customer per number of order.

Let's create our exploration :

  • Head to the Workbench

  • Click on the + the "Add an exploration"

  • Select your Jaffle Shop customer table

On our new exploration, we need to have :

  • The number of customers as a metric

  • The number of orders as a dimension.

This number of order columnis not available in the customer table, but we know we have the data in our database. We have a modelization problem, meaning that the data we have is not in a format that allows our analysis. We will create a data model to overcome this problem and create our chart.

Creating our data model

In the workbench, go to the dataset tab and create a new model. We will create a flow (no-code) model that will start from the customer table of Jaffle shop :

Now we can go the the configuration tab of our model to add calculated columns to our Customer table.

For example let's create a full_name column that will contain the first name and last name of our customer. We will use the CONCAT formula in order to do so :

To add the number of order per customer, we will use a rollup column (which consists of a lookup that matches multiple results in a related table and aggregates these results) :

That's it, now we just need to save our model before being able to use this column in our exploration. To do it, set the output on the last step and click on save.

Updating our exploration

We will need to update our exploration to make it use our new "Customer model" instead of the raw customer table. To do so :

  • Go to the exploration

  • Click on the customer table, and replace the raw data table with your model

  • Create your dimensions and metrics

Creating our chart

We can now create our chart using these metrics and dimensions

Last updated