00:00Hey friends, welcome back.
00:07Now the great thing for our measures, which we have calculated in the last video, is the
00:11flexibility on how we can use them.
00:14Because remember, what I told you, that measures are actually calculated on the fly.
00:19So they do not store any value.
00:21And this means also that they can be completely flexible and be used everywhere in our report.
00:27And also for all the dimensions in our model, as long as we have the relationships in place.
00:33What I mean by that is, for instance, here, we currently analyze our various KPIs, in
00:39this case, total sales, total cost, total profit, or also the margin for each of the
00:44products.
00:46But what if we would like to analyze this by a different dimension?
00:49So let's just say I would like to see, we can see here the total sales by year, but
00:53maybe I'd like to see now the total profit by year.
00:56So I could simply go in here, in this one, and I can go to the data section here, and
01:02then I could say, here for my year, and the y-axis here, I'd like to add some data.
01:07So I can click on add data here, and then I can say, in here, I'd like to use one of
01:10my measures.
01:11And then I could say, I'd like to see this, for instance, as well for the total profit.
01:15So I can click on total profit, and now I can see here my total sales, as well as my
01:19total profit.
01:21Or if I only want to see the total profit, I can completely get rid of the sales.
01:24And now I can see here the total profit for each of the different kinds of years I have.
01:29So you can see, whatever kind of visual you use could be a pie chart, donut chart, a bar
01:34chart, or also a map where you display the countries and visualize, for instance, the
01:40profit margin for each of the countries.
01:41So you can use your measures quite everywhere in your report.
01:45And the flexibility could also be within any kind of visualization, like a table structure.
01:50For instance, you could say, in here, we have, currently, as I said, the data by product
01:55name.
01:56But what if now your superior comes, and she tells you, well, that's great, but I'd like
02:00to need, or I'd like to have this as, for instance, for each of the, in this case, the
02:04customers.
02:05I'd like to know who are our profitable customers, not the products.
02:09And she asks you, can you do this?
02:10And you say, yeah, sure, I can do that, no problem.
02:13Now, you can simply, even control C, select the first, control C to copy this, and then
02:19you can go to a new page, for instance, because I just created a new page because I don't
02:23have any space here left.
02:24But you go in here and say, control V to paste it, and now you could say, instead of showing
02:28this for the product name, I can simply go in here to the selection, I can remove the
02:33product name like that, and I can see my sales and the other KPIs aggregated, and then I
02:39could say, simply, add some data, and now I'd like to see this for, as we said, for
02:44the customers.
02:45So I can go to my customer table here, or search directly to go to customer, and there's
02:50customer name, and I can select this customer name, and now I can see the customer name
02:54in here.
02:55And for each customer, I can see here my KPIs.
02:59And of course, normally, you would like to see the customer name at the first row, that's
03:03the first entry here, the first column, sorry, then, of course, simply use it and drag it
03:08up and place it on top, like, let me just place it here, and let's actually get rid
03:13of the sum of total sales, let's just close the column, so of course, get rid of that,
03:17and I'll get our customer name here, and we can see the total sales, the total cost, and
03:21total profit, and the margins.
03:24And if you would like to know who are the most profitable customers, I can simply go
03:27in here, take a look at the profit margin, and I can sort it, the table by the profit
03:31margin, like that, and then I would see here, the most profitable customer in this case
03:36is Donald Reynolds, with 43.51%.
03:41So you can clearly see that it's quite easy and quite flexible to use your measures in
03:46any kind of visualization, and answer the questions that your superiors or your colleagues
03:51might have quite quickly, and do this in a visual way as well, not only tables, we use
03:56a table here as an example, but of course, as I said before, you can use any of those
04:00visualizations, which best fits your needs.
04:03So that's it actually for this video.
04:05So hopefully, you have seen how easy it is, and I encourage you, do this yourself, try
04:09it out, feel free also to try out maybe other visualization types, and then I'll see you
04:14in the next video.
04:15Until then, best guys.
Comments