00:00:08:16 - 00:00:09:01
Infigo
00:00:09:01 - 00:00:12:09
Insights utilizes
the Metabase platform to visualize
00:00:12:09 - 00:00:15:09
and utilize your platform's data
00:00:15:11 - 00:00:19:04
in its tutorial, we'll take a look
at creating a basic question.
00:00:19:06 - 00:00:22:13
This is Metabase terminology
giving you the means to generate
00:00:22:13 - 00:00:26:23
informational data reports
using intuitive tools.
00:00:26:25 - 00:00:29:21
A basic example
we'll see is creating a question
00:00:29:21 - 00:00:33:17
looking at the total value of orders
taken on a singular storefront
00:00:33:19 - 00:00:36:19
over the past 30 days.
00:00:36:23 - 00:00:39:05
Now, in order to be able
to utilize this functionality,
00:00:39:05 - 00:00:44:01
you will need one of the higher levels
of Insights
00:00:44:03 - 00:00:46:08
bands. So Infinite Insights
00:00:46:08 - 00:00:50:03
Standard will not allow you
to create reports in this fashion.
00:00:50:05 - 00:00:53:03
However, pro, pro plus and enterprise
00:00:53:03 - 00:00:56:03
will allow you to do so.
00:00:56:09 - 00:00:59:00
So within the actual Metabase platform itself, I'm
00:00:59:00 - 00:01:06:17
going to go to the top right
click on new and then question
00:01:06:19 - 00:01:07:27
it. From this point, we're
00:01:07:27 - 00:01:12:02
actually just using this screen here
to choose to format,
00:01:12:02 - 00:01:16:00
to refine the data that we want to use
and show it in the format
00:01:16:00 - 00:01:21:02
that we find useful
for our particular needs.
00:01:21:04 - 00:01:25:09
The first thing we need to do on here
is to pick our starting data.
00:01:25:11 - 00:01:28:19
Now you have the ability to select
between two different things.
00:01:28:22 - 00:01:32:06
One of them is the actual
Infigo platform.
00:01:32:09 - 00:01:35:19
Now this is named training in my case,
and this is due to the name
00:01:35:19 - 00:01:41:09
of my particular platform, which is
training.infigosoftware.com
00:01:41:12 - 00:01:45:07
Yours will be named something different
or you can utilize the outputs
00:01:45:07 - 00:01:49:14
of any previous saved questions.
00:01:49:16 - 00:01:50:26
In our case, we're going to click
00:01:50:26 - 00:01:57:17
on the main bulk of the data,
which is in my case, training,
00:01:57:19 - 00:01:58:06
and then we're going to
00:01:58:06 - 00:02:02:01
select the initial database
that we want to use.
00:02:02:03 - 00:02:05:02
So in this example will only use data from
00:02:05:02 - 00:02:08:18
one of the available provided data tables.
00:02:08:20 - 00:02:12:04
However, as we'll see in later
tutorials, multiple
00:02:12:05 - 00:02:17:00
data tables can be utilized
in a single question.
00:02:17:03 - 00:02:20:03
In this example, we're looking for
the value of orders received
00:02:20:10 - 00:02:23:10
so we can feasibly use
00:02:23:12 - 00:02:32:02
the order dataset.
00:02:32:04 - 00:02:32:17
You'll see that
00:02:32:17 - 00:02:36:10
a few extra
things have appeared on our screen. Now.
00:02:36:12 - 00:02:40:05
We do also within this data section
that we've just placed something in.
00:02:40:07 - 00:02:42:14
We do have this arrow button next to it.
00:02:42:14 - 00:02:44:16
This is not a mandatory step.
00:02:44:16 - 00:02:48:09
However,
the arrow can be used to refine the fields
00:02:48:09 - 00:02:51:09
that are displayed
on the eventual dataset.
00:02:51:17 - 00:02:54:00
So without refining the selected fields,
00:02:54:00 - 00:02:56:26
all data will be displayed by default.
00:02:56:26 - 00:03:00:14
So we'll see data by default
for every single one of these columns
00:03:00:19 - 00:03:02:13
for every single bit of data.
00:03:02:13 - 00:03:08:02
However, for all we interested in certain
pieces of data, we can refine this down.
00:03:08:04 - 00:03:09:14
So for example,
00:03:09:14 - 00:03:15:21
I might only be interested in things
such as the total
00:03:15:24 - 00:03:17:13
and the storefront ID
00:03:17:13 - 00:03:25:16
so I could choose
whatever information I wanted from here.
00:03:25:18 - 00:03:29:19
Now, the purple section that we've got
is filtering, and this allows
00:03:29:19 - 00:03:34:08
us to create filters to narrow down
our answers to these questions.
00:03:34:10 - 00:03:35:07
So it filters allowing you
00:03:35:07 - 00:03:39:11
to refine the displayed dataset
and cut out unnecessary noise.
00:03:39:13 - 00:03:43:05
For example, in this instance,
we will apply to filters
00:03:43:07 - 00:03:48:17
filter one will display order information
for only one storefront on our platform.
00:03:48:17 - 00:03:51:17
So we're not mixing information
from different storefronts
00:03:51:24 - 00:03:55:01
and filter
to ensure that only order information
00:03:55:01 - 00:04:02:06
from the previous
30 dates has been included.
00:04:02:09 - 00:04:03:05
So let's start off
00:04:03:05 - 00:04:06:08
by refining down to a singular storefront.
00:04:06:08 - 00:04:09:10
First of all,
00:04:09:12 - 00:04:12:12
what I want
to do is say add filters to narrow answer,
00:04:12:15 - 00:04:16:11
and we're searching
for a relevant filter in here.
00:04:16:11 - 00:04:20:08
So this is a relevant piece of information
that we want to filter by.
00:04:20:10 - 00:04:21:21
Well, looking for storefront.
00:04:21:21 - 00:04:24:24
So if I start searching for this,
we do have an ID here,
00:04:24:24 - 00:04:28:06
which is storefront ID,
00:04:28:08 - 00:04:29:17
and then we want to actually type
00:04:29:17 - 00:04:32:17
in the data that we want to filter by.
00:04:32:24 - 00:04:35:19
So how you can filter
this field will be controlled
00:04:35:19 - 00:04:38:07
by the type of data contained within it.
00:04:38:07 - 00:04:42:01
So for example, here
we have sort of a numerical I.D.
00:04:42:03 - 00:04:45:10
and as a result,
we're able to enter values to filter
00:04:45:12 - 00:04:48:19
and then control
how these values are used.
00:04:48:21 - 00:04:54:10
The default usage,
for example, is this is icon here.
00:04:54:12 - 00:04:55:04
This means that
00:04:55:04 - 00:04:58:11
only values all of that chosen
ID will be shown.
00:04:58:13 - 00:05:01:10
Alternative things in here
include things such as
00:05:01:10 - 00:05:04:04
is not greater than less than.
00:05:04:04 - 00:05:06:29
So we can refine down and filter
00:05:06:29 - 00:05:11:26
the data based on any of those selections.
00:05:11:28 - 00:05:15:02
Now, in this particular case,
I'm just refining that to one storefront,
00:05:15:03 - 00:05:19:13
which I know as a storefront ID of 66
00:05:19:15 - 00:05:21:07
Click enter
00:05:21:07 - 00:05:28:00
and that's my filter input.
00:05:28:03 - 00:05:31:25
Now for our second filter,
we wish to refine display dates
00:05:31:27 - 00:05:35:21
and for this we're able to select
two fields such as created date
00:05:35:28 - 00:05:38:28
within the order table
00:05:38:28 - 00:05:40:03
so I could search for something
00:05:40:03 - 00:05:43:25
like dates just to see any relevant
00:05:43:27 - 00:05:46:00
particular
00:05:46:00 - 00:05:47:16
associated fields.
00:05:47:16 - 00:05:51:00
There's a few I can choose from
within the order table itself,
00:05:51:02 - 00:05:53:07
and I can select
whichever one is most relevant to me.
00:05:53:07 - 00:05:55:06
So I'll say created date
00:05:55:09 - 00:05:55:29
now because it's
00:05:55:29 - 00:06:00:11
recognized this as a date field,
it will give us inputs
00:06:00:11 - 00:06:03:11
allowing us to specify the dates
we want to consider.
00:06:03:14 - 00:06:06:14
Now, this can be as general as today
00:06:06:21 - 00:06:09:02
could be last month
or it could be in the last year.
00:06:09:02 - 00:06:13:14
Or we can cover a specific time
period and timeframes.
00:06:13:16 - 00:06:15:27
So I could go for specific dates
or relative dates.
00:06:15:27 - 00:06:17:28
For example,
00:06:17:28 - 00:06:19:16
if I want to say it's
within the last month,
00:06:19:16 - 00:06:22:16
I can click on that.
00:06:22:16 - 00:06:26:20
And then if I click back on that data,
I've got some
00:06:26:23 - 00:06:28:29
capabilities there of refining that
00:06:28:29 - 00:06:33:14
last month information even more
So for example, it's saying at the moment
00:06:33:14 - 00:06:37:12
that's the last one month that's giving me
the last complete month by default.
00:06:37:12 - 00:06:40:12
So it's show me the 1st of October
to the 31st of October.
00:06:40:12 - 00:06:49:03
In my case, however, I could, for example,
say encode this month if I wanted to.
00:06:49:05 - 00:06:50:28
Alternatively, if I didn't want one month,
00:06:50:28 - 00:06:57:18
I could change it to a different time
period
00:06:57:21 - 00:07:00:23
current or I can do future dates as well
00:07:00:23 - 00:07:04:13
if that's relevant to a particular search.
00:07:04:13 - 00:07:06:24
if that's relevant to a particular search.
00:07:06:26 - 00:07:09:26
So next we can actually start
to visualize this data.
00:07:09:26 - 00:07:12:23
So the data covered
by the current question being asked
00:07:12:23 - 00:07:15:24
can be viewed at any time
by clicking on the Visualize
00:07:15:24 - 00:07:20:21
button at the bottom of this section.
00:07:20:23 - 00:07:24:14
And what we can see in our example
is that based on our refinement of
00:07:24:14 - 00:07:29:00
displayed columns and filtering of data,
we've got three columns available.
00:07:29:05 - 00:07:31:04
One is showing us the order ID,
00:07:31:04 - 00:07:35:13
one is showing us the relevant storefront
that ID is associated with,
00:07:35:16 - 00:07:39:13
and because we place the filter of 66,
that's always showing us
00:07:39:15 - 00:07:42:12
and we have the associated price as well.
00:07:42:12 - 00:07:46:01
That's the data
that is currently utilizing.
00:07:46:03 - 00:07:48:14
If we want to
apply some additional filtering to this,
00:07:48:14 - 00:07:52:29
if that's not quite the information
we want, we can go back to the editor
00:07:52:29 - 00:08:02:08
with this icon over on the top right
hand side.
00:08:02:10 - 00:08:05:18
So what we might want to do next,
the data that we have there is showing us
00:08:05:18 - 00:08:10:25
the so by showing us the price of all of
the individual orders in the last month,
00:08:10:28 - 00:08:15:03
what we want in our particular case
is a total price of all of those orders.
00:08:15:03 - 00:08:16:27
So we want all of those summed
00:08:16:27 - 00:08:21:09
and we can do this using these summarize
functionality.
00:08:21:12 - 00:08:26:03
So summarize allows you to display
existing data in a more condensed way.
00:08:26:05 - 00:08:30:18
So for our case, for example,
we're looking to display one order price
00:08:30:18 - 00:08:36:07
for the entire month instead of data on
each individual order that's being placed.
00:08:36:09 - 00:08:37:24
If I click summarize,
00:08:37:24 - 00:08:41:15
there's a few different means by
which I can summarize the particular data.
00:08:41:18 - 00:08:44:18
And obviously your choice would depend on
what exactly you're looking for.
00:08:44:24 - 00:08:47:22
And you can enter your own custom
expressions as well
00:08:47:22 - 00:08:51:18
if you have the technical skills to do so.
00:08:51:20 - 00:08:55:01
In this case,
I'm just going to say sum of
00:08:55:03 - 00:08:56:29
and then it's giving us
00:08:56:29 - 00:08:59:24
the ability
to select the information that we want to.
00:08:59:24 - 00:09:03:21
So in our case, as we've mentioned,
we want the sum of all of those
00:09:03:21 - 00:09:05:21
individual order totals.
00:09:05:21 - 00:09:13:23
I can say some of total.
00:09:13:25 - 00:09:15:06
Let's go ahead and click Visualize.
00:09:15:06 - 00:09:15:28
Yes. Again,
00:09:16:01 - 00:09:18:20
and then we can see
that our answer has now been obtained.
00:09:18:20 - 00:09:22:23
So we're seeing just a singular value
which is combining all of those order
00:09:22:23 - 00:09:27:02
total bits of data
that we saw on our previous table.
00:09:27:05 - 00:09:29:14
This is now giving us our required data.
00:09:29:14 - 00:09:36:10
The order total over the past 30 days.
00:09:36:13 - 00:09:38:26
So now this
particular question has been complete.
00:09:38:26 - 00:09:41:09
We want to save it for later use.
00:09:41:09 - 00:09:45:18
So on the top right hand side,
I'm just going to go and click Save
00:09:45:21 - 00:09:47:26
within entering a name
00:09:47:26 - 00:09:51:03
for this particular data,
an optional description.
00:09:51:05 - 00:09:54:06
And then we're specifying a location
on our account
00:09:54:06 - 00:10:06:19
where we want to save this information.
00:10:06:21 - 00:10:08:19
There's a few sections
which are associated
00:10:08:19 - 00:10:11:27
with your particular platform,
or you can save it to your own
00:10:11:27 - 00:10:21:07
personal collection.
00:10:21:09 - 00:10:22:05
Now here you'll see
00:10:22:05 - 00:10:25:05
we have the ability to add this
to one of our dashboards.
00:10:25:10 - 00:10:28:06
The saved questions can immediately
be added to a dashboard,
00:10:28:06 - 00:10:31:06
which is a collection
of different questions and other
00:10:31:06 - 00:10:34:29
data that you wish
to make readily available for review.
00:10:35:01 - 00:10:36:22
At this particular point,
we're going to click on
00:10:36:22 - 00:10:42:02
Not Now as well,
create dashboards in a later tutorial,
00:10:42:05 - 00:10:42:21
and that's it.
00:10:42:21 - 00:10:45:16
That's our first basic question created.