1
00:00:00,180 --> 00:00:03,820
Hello and welcome back to this video now in the last video we learned.

2
00:00:04,050 --> 00:00:05,820
What's the interface of Poppea looks like?

3
00:00:05,830 --> 00:00:08,670
So we had a little tour, but now let's actually dive into it.

4
00:00:08,970 --> 00:00:11,120
So let's practice it first.

5
00:00:11,280 --> 00:00:15,120
There's a window and you can see I have opened up the complete new PABI report.

6
00:00:15,270 --> 00:00:16,740
So let me actually close here.

7
00:00:17,040 --> 00:00:18,630
And it's actually import data here.

8
00:00:19,200 --> 00:00:25,530
And is that in our first exercise here, we want to import XML data so you can either click on here

9
00:00:25,530 --> 00:00:31,050
to import data from Excel or you can go up here, Excel, or you simply go to getData Excel.

10
00:00:31,200 --> 00:00:37,380
Or the fourth option would be to go to more and then also wait until the window opens the window and

11
00:00:37,380 --> 00:00:38,590
then choose XML from here.

12
00:00:38,720 --> 00:00:41,080
So always what exactly do exactly the same.

13
00:00:41,580 --> 00:00:43,910
So for me, I simply click on Excel up there.

14
00:00:44,190 --> 00:00:46,140
So import data from Microsoft Excel workbook.

15
00:00:46,320 --> 00:00:49,550
And by the way, you find this workbook also in the resource section of the course.

16
00:00:49,560 --> 00:00:51,910
So download Excel five first to follow along.

17
00:00:52,470 --> 00:00:56,450
So if I go to Excel here, then I can choose my path by the easy way.

18
00:00:57,000 --> 00:01:02,730
So if I click on this and then I click on Open, what you see is a connect no to this file.

19
00:01:03,000 --> 00:01:05,880
And what will happen is a new window will appear just seconds.

20
00:01:06,000 --> 00:01:06,770
And there it is.

21
00:01:07,560 --> 00:01:08,940
This is a so-called navigator.

22
00:01:09,240 --> 00:01:12,870
The navigator now allows us to specify what exactly do we want to have?

23
00:01:13,440 --> 00:01:19,890
And here I have two tables or actually I have a sheet which is called gaming here and also have a table,

24
00:01:19,920 --> 00:01:21,450
which is called gaming table.

25
00:01:22,230 --> 00:01:24,450
And you see, that's the data itself.

26
00:01:24,450 --> 00:01:27,520
If you click on it and let me maybe make this a little bigger for you.

27
00:01:27,840 --> 00:01:29,280
So this is what the data looks like.

28
00:01:29,430 --> 00:01:35,070
So if you open the Excel file, you see exactly this kind of data here, like country price or the amount

29
00:01:35,070 --> 00:01:36,680
sales, product, profit and region.

30
00:01:37,230 --> 00:01:41,550
And if I click on the gaming here, this option, you see exactly the same data.

31
00:01:42,000 --> 00:01:42,670
So why is that?

32
00:01:43,380 --> 00:01:48,450
So this here, this is all I can refer to the sheet of this Excel file, the gaming sheet.

33
00:01:49,020 --> 00:01:50,930
This, on the other hand, refers to a table.

34
00:01:51,360 --> 00:01:56,760
So if you have created the table of data in the sheet, then you will see here that the table icon,

35
00:01:56,760 --> 00:02:04,560
which differs because it has a little blue header line and this allows us to only import the data on

36
00:02:04,560 --> 00:02:05,400
this specific table.

37
00:02:05,850 --> 00:02:11,070
So that's exactly the difference between those two, because that say you have this gaming sheet created

38
00:02:11,220 --> 00:02:15,810
in your underlying data, also in the actual file, but on the gaming sheet, there's additional information.

39
00:02:15,810 --> 00:02:19,290
So you have additional data which you do not want to import into poverty.

40
00:02:19,890 --> 00:02:23,610
Now, of course, you can still clean it with the poker ed.

41
00:02:23,610 --> 00:02:25,080
We'll cover this in the next couple of videos.

42
00:02:25,380 --> 00:02:28,290
But why importing all the data and then clean it?

43
00:02:28,440 --> 00:02:31,410
If you don't need it, simply choose only the table.

44
00:02:31,410 --> 00:02:33,230
You want to have an unemployed the table.

45
00:02:33,660 --> 00:02:39,630
So this allows you to make sure that even if someone else or you will change your file in the future,

46
00:02:39,630 --> 00:02:45,210
the specific sheet, as long as this table still exists and you have only imported the table, you will

47
00:02:45,210 --> 00:02:50,010
only import the data from the table and avoid importing additional information you don't want.

48
00:02:50,580 --> 00:02:55,260
So that is why a best practice, at least from my point of view and experience, is choose the table

49
00:02:55,710 --> 00:02:58,920
just in case the data in this table is enough for you.

50
00:02:59,010 --> 00:02:59,700
Choose the table.

51
00:03:01,450 --> 00:03:05,570
So that is that, but in our case, it wouldn't make any difference if we take this one option.

52
00:03:05,590 --> 00:03:08,830
Let me then take this one or if we can take this one and take this one.

53
00:03:09,400 --> 00:03:13,120
But because I think it's best practice if you have a table and you only want to have the data from the

54
00:03:13,120 --> 00:03:14,350
table, choose a table here.

55
00:03:16,530 --> 00:03:21,780
As soon as you have done this, you can then also here refresh the data that is also available here.

56
00:03:21,790 --> 00:03:27,360
By the way, this would mean that just in the meantime, you connect to the data and in this specific

57
00:03:27,360 --> 00:03:30,150
moment, someone is changing the underlying data source.

58
00:03:30,510 --> 00:03:34,640
Then you could simply click refresh here and you would see immediately the changes.

59
00:03:35,370 --> 00:03:37,770
So the data file itself is not locked normally.

60
00:03:37,770 --> 00:03:42,570
At least you can someone can edit it and you can then click on refresh and you would see the the latest

61
00:03:42,570 --> 00:03:43,320
refresh of the data.

62
00:03:47,040 --> 00:03:51,780
And finally, if you want to load the data, there are two options here, which is load, which is already

63
00:03:51,780 --> 00:03:52,510
highlighted in yellow.

64
00:03:52,530 --> 00:03:54,330
That is why probably most people will click on it.

65
00:03:54,570 --> 00:03:56,130
But there's also this transform data.

66
00:03:56,610 --> 00:04:00,470
This transform data would mean that we do not load the data directly into PABI.

67
00:04:00,690 --> 00:04:02,910
Instead, what we do is we open the Pocari.

68
00:04:02,910 --> 00:04:07,200
Ed, as I've told you, this is the data cleaning and transformation tool which is available for us

69
00:04:07,500 --> 00:04:11,130
in public and we will cover this as a promise in the next couple of videos.

70
00:04:11,340 --> 00:04:15,990
But you could simply shape and clean your data up front before you load it into public.

71
00:04:16,110 --> 00:04:21,079
This is where you can click on Transform data and then the query Ed would open for us.

72
00:04:21,089 --> 00:04:22,430
Now for the simple file.

73
00:04:22,650 --> 00:04:25,700
We simply tecolote because we have seen the data here.

74
00:04:25,770 --> 00:04:26,920
The data looks fine to us.

75
00:04:27,030 --> 00:04:31,380
We also specify that we want to have the table and then we click on simply download, import the data.

76
00:04:35,030 --> 00:04:39,270
Just a second, and you can see that podia is connected to the data and is importing the data.

77
00:04:39,860 --> 00:04:45,050
Now it's done and we can see on the at list on the site that now we have our gaming table here.

78
00:04:45,300 --> 00:04:45,580
Right.

79
00:04:45,620 --> 00:04:48,710
And you can see it, storage mode, latest refresh and so on.

80
00:04:48,950 --> 00:04:54,170
And you can see all the different kinds of fields we have in inside like country or the amount price,

81
00:04:54,170 --> 00:04:55,950
product, profit region and sales.

82
00:04:56,060 --> 00:04:59,990
So all these fields here are exactly the column headers in the underlying data source.

83
00:05:00,680 --> 00:05:06,650
You also see a little well, some I can hear that simply refers to the fact that if you specify a specific

84
00:05:06,650 --> 00:05:10,360
column as numeric column, then it will automatically create the sum here.

85
00:05:10,400 --> 00:05:15,050
It would automatically also when you create a visualization based on this, you will automatically get

86
00:05:15,170 --> 00:05:20,000
the total profit, for instance, here, the total sum of this column or the total sales, if you want.

87
00:05:21,690 --> 00:05:24,010
If you want to have a look at the data, this is where.

88
00:05:24,030 --> 00:05:28,100
Remember, there are different kinds of views and probably also this data view here.

89
00:05:28,380 --> 00:05:34,530
And if you click on it, you also see here the table again with the country price, Automan sales,

90
00:05:34,530 --> 00:05:35,790
product, profit and region.

91
00:05:35,850 --> 00:05:36,630
So exactly that.

92
00:05:36,930 --> 00:05:41,150
Exactly the same tables as Excel could be viewed here in the state of U.

93
00:05:42,590 --> 00:05:47,810
And under just did you see it under the model view that we currently have one specific table here which

94
00:05:47,810 --> 00:05:51,170
is there, we can't connect it to any other kind of data because we don't have it.

95
00:05:51,290 --> 00:05:52,460
But for now, that's not necessary.

96
00:05:53,240 --> 00:05:58,310
What I will do is I simply go back up here to my first you and you see your results with your data.

97
00:05:58,790 --> 00:06:04,670
So what we need to do when we want you to visualize something now, please take the specific field we

98
00:06:04,670 --> 00:06:11,300
want so we can either click first on a realisation like let's say we would like to have a bar here.

99
00:06:11,540 --> 00:06:17,270
I can click on a budget, click on it, then I can see my template and then I could simply click on

100
00:06:17,270 --> 00:06:17,570
sales.

101
00:06:17,570 --> 00:06:19,070
For instance, I can take this year.

102
00:06:19,370 --> 00:06:24,200
And then what I see is I see a little bit out here, which, by the way, I can drag around and place

103
00:06:24,200 --> 00:06:24,710
it anywhere.

104
00:06:24,740 --> 00:06:25,070
Right.

105
00:06:25,430 --> 00:06:26,470
Or make it big forward.

106
00:06:27,140 --> 00:06:31,880
But you see that this will be one way to first select your specific template.

107
00:06:32,790 --> 00:06:38,910
We should remove this press delete to remove it when you selected so specific template like ones here

108
00:06:39,150 --> 00:06:42,570
or here, the donor chart, click on it and then you simply click the fields.

109
00:06:42,570 --> 00:06:47,820
You want instance sales here and you can see that now the shop is filled with the sales volume, which

110
00:06:47,820 --> 00:06:49,720
is almost thirty four thousand.

111
00:06:51,330 --> 00:06:54,720
Now, the other way would be that you can simply take a specific field.

112
00:06:55,290 --> 00:07:00,750
And the difference is when I take sales, yes, simply ticket instead of using a visualization up front,

113
00:07:01,290 --> 00:07:04,380
then by default I get a budget, as you can see here.

114
00:07:04,380 --> 00:07:06,200
And this is true for all numerical fields.

115
00:07:06,660 --> 00:07:11,670
So if I click somewhere on my blank canvas and then choose another field, like, for instance, profit,

116
00:07:11,880 --> 00:07:12,450
click on it.

117
00:07:12,780 --> 00:07:13,950
I will see that again.

118
00:07:13,950 --> 00:07:15,280
It gets here a bar chart.

119
00:07:15,570 --> 00:07:20,250
So this is the default charge which which get created if you use a numerical field.

120
00:07:22,090 --> 00:07:27,130
Also, make sure that if you want to create a new chart, a new fossilisation, first click somewhere

121
00:07:27,130 --> 00:07:33,880
on a blank canvas, because if I click on the profit, if as long as if it's still selected like this

122
00:07:34,090 --> 00:07:38,440
and then I choose another kind of visualisation in Spain, for instance, I'd say I'd like to see a

123
00:07:38,440 --> 00:07:40,270
pie chart, click on a pie chart.

124
00:07:40,540 --> 00:07:43,270
Then you see that you change the specific visual.

125
00:07:44,210 --> 00:07:48,710
So if you want to change a visual, simply select it and then choose a different kind of visualization

126
00:07:48,710 --> 00:07:49,670
here that works.

127
00:07:50,330 --> 00:07:54,700
But if you do not want to change it, just make sure that you first click somewhere on the blank canvas

128
00:07:54,710 --> 00:08:02,120
so your unteach or on select all the visuals you have and then choose another well, your field wants

129
00:08:02,270 --> 00:08:06,320
or choose and the visualization to create a specific template and then fill in the fields.

130
00:08:06,770 --> 00:08:07,070
OK.

131
00:08:09,190 --> 00:08:13,960
Besides these options here, we also have TextField, like, for instance, country here is TextField

132
00:08:13,960 --> 00:08:16,040
Corindi or product or region.

133
00:08:16,720 --> 00:08:22,090
So if I click on product here, what you see is that by default, Parubiy is creating a table.

134
00:08:23,140 --> 00:08:27,490
So for TextField Sparboe, as always, by default, creating tables like this one here.

135
00:08:29,300 --> 00:08:33,559
Now, if you want to add additional data to the table here, for instance, I would like to see my products

136
00:08:33,559 --> 00:08:38,299
here, as you can see here, which is here, a unique list of products, because if I take a look at

137
00:08:38,299 --> 00:08:42,620
my data here, you see that for the products here, we have several times PlayStation, which have been

138
00:08:42,620 --> 00:08:45,970
sold or Xbox or Nintendo and so on or PC down there.

139
00:08:46,490 --> 00:08:49,220
But what Tobii gives us here is simply a unique list.

140
00:08:49,580 --> 00:08:51,260
So distinct values of this products.

141
00:08:52,370 --> 00:08:56,510
And then we could add additional data to this to this specific visualization.

142
00:08:56,540 --> 00:09:01,750
So for the this gets to the table, for instance, we'd like to see the sales amount for each product.

143
00:09:02,390 --> 00:09:08,360
Then what we could do is either we select this option here and drag it here undervalues because you

144
00:09:08,360 --> 00:09:11,800
can see in value system the only product we can drop it here.

145
00:09:12,020 --> 00:09:15,820
And then what we get is we get the sum of sales for each product.

146
00:09:16,160 --> 00:09:22,370
And in total this around thirty four thousand euros or dollars, whatever kind of currency is, you

147
00:09:22,370 --> 00:09:24,410
can see the same if you have over the bar.

148
00:09:24,740 --> 00:09:27,490
It is exactly the same amount as the total sales.

149
00:09:28,190 --> 00:09:30,140
But now you're simply for each product.

150
00:09:31,460 --> 00:09:35,870
The same is true for the prophet, if you like the prophet, then in your table and drop it from here,

151
00:09:36,080 --> 00:09:39,440
you get additional information here for the prophet, for instance, for each product.

152
00:09:40,010 --> 00:09:45,500
So it seems to them if you want to remove something, you simply click on a little cross symbol here

153
00:09:45,890 --> 00:09:46,580
on CROSSFIRE.

154
00:09:46,820 --> 00:09:48,320
And now you can see that the prophet is gone.

155
00:09:49,490 --> 00:09:55,900
Another way to get data to this table is instead of dragging, dragging and dropping it like this,

156
00:09:56,210 --> 00:09:57,770
you can also simply take it.

157
00:09:58,160 --> 00:10:03,170
So if you click on this take option here, you also see that we are simply adding the data down there

158
00:10:03,470 --> 00:10:04,100
to the table.

159
00:10:05,740 --> 00:10:11,350
If you want to change the order, simply choose profiteer and drag it on top of sales, drag and drop

160
00:10:11,350 --> 00:10:11,520
it.

161
00:10:11,680 --> 00:10:16,030
And now you can see that the profit is the first column next to the product and the sales is the last

162
00:10:16,030 --> 00:10:16,210
one.

163
00:10:16,660 --> 00:10:19,840
So by simply dragging and dropping them around, you can adjust the order.

164
00:10:20,290 --> 00:10:23,580
If you want to prove something, simply click on this little symbol here.

165
00:10:24,460 --> 00:10:29,230
And if you want to do additional things on the down arrow and they can also see different kinds of options,

166
00:10:29,230 --> 00:10:31,030
like what kind of aggregation do you want to have?

167
00:10:31,180 --> 00:10:34,060
You want to have the some, you want to have the average minimum and so on.

168
00:10:34,240 --> 00:10:35,830
These options are also available for year.

169
00:10:37,810 --> 00:10:43,140
But that's it for creating a table, so by default, remember that if you do not choose a specific ritual

170
00:10:43,150 --> 00:10:49,360
up front and then at your data to it, by default, Poggio will create bar charts for numerical data

171
00:10:49,510 --> 00:10:52,300
and tables for, in this case, text data.

172
00:10:53,640 --> 00:10:58,070
And each of those visuals, like, for instance, the bar chart here, the pie chart as well as here,

173
00:10:58,110 --> 00:11:01,360
this chart here table is completely customizable.

174
00:11:02,040 --> 00:11:07,430
What I mean by that is currently here we are in actually the field option here, right?

175
00:11:07,440 --> 00:11:12,810
If you have what you can see the fields now next to the fields here, there's also this formatting option.

176
00:11:12,900 --> 00:11:16,950
I call it the paintbrush, but this is only my personal naming for that.

177
00:11:17,790 --> 00:11:22,290
So if you click this, what you see is then you have additional options to style your table.

178
00:11:22,910 --> 00:11:28,080
So here I would highly recommend you go through all these options and try them out.

179
00:11:28,440 --> 00:11:31,560
So understanding, for instance, you could see their different kind of styles.

180
00:11:31,770 --> 00:11:36,990
So if I go to alternating rows, click on this, then you see that the table changes the style of the

181
00:11:36,990 --> 00:11:37,320
table.

182
00:11:37,800 --> 00:11:40,980
And here simply try out what's available and what fits best your needs.

183
00:11:42,180 --> 00:11:44,520
Right, John Sparks, and then we'll talk about it.

184
00:11:44,820 --> 00:11:46,140
So for me, that's a little too much.

185
00:11:46,410 --> 00:11:50,670
That's why if you want to go back so you can always click on this river to default, which is available,

186
00:11:50,700 --> 00:11:51,990
and then you can see the original table.

187
00:11:52,470 --> 00:11:53,400
So for me, that's fine.

188
00:11:53,580 --> 00:11:56,190
But I just want to try out the different kind of ditherer.

189
00:11:56,610 --> 00:11:58,260
And the same is true for other things.

190
00:11:58,260 --> 00:12:01,290
For the grid, for instance, you want to add additional grids.

191
00:12:01,500 --> 00:12:05,220
So maybe you can see this on the screen now added to a vertical grid line.

192
00:12:05,460 --> 00:12:07,530
I can either take this or take this.

193
00:12:07,530 --> 00:12:08,670
I can also adjust the color.

194
00:12:09,030 --> 00:12:12,790
If you call here, you see that I make this blue, then I would have a blue color for that.

195
00:12:13,260 --> 00:12:15,510
So everything individually is customizable.

196
00:12:15,780 --> 00:12:19,770
You just need to take a look at here this formatting or what I called paintbrush option here.

197
00:12:20,890 --> 00:12:25,030
And there are a lot of things, so just in case you do not find something immediately, go to the search

198
00:12:25,030 --> 00:12:25,960
option and search for it.

199
00:12:28,230 --> 00:12:32,850
So column headers, the same is true here, you can adjust the font size, the background color and

200
00:12:32,850 --> 00:12:34,390
so on the text size here.

201
00:12:34,560 --> 00:12:38,610
So if I make this bigger, you see that now I'm creating bigger headers here on the table.

202
00:12:38,860 --> 00:12:39,110
Right.

203
00:12:39,510 --> 00:12:40,640
The same is true for the value.

204
00:12:40,680 --> 00:12:43,830
So in case the values are too small for you, go with this values option here.

205
00:12:44,100 --> 00:12:45,060
Click on values here.

206
00:12:45,340 --> 00:12:48,920
Adjust the font background Karlan's on or simply only the size.

207
00:12:48,990 --> 00:12:54,330
You can go on here in a you can also, by the way, simply highlight this and then type in a number

208
00:12:54,360 --> 00:12:57,390
like 15 and then you can see that the number here gets bigger.

209
00:12:57,630 --> 00:12:59,190
So totally up to you how you want to do that.

210
00:12:59,700 --> 00:13:04,830
And there's also always this revert option, which is also available for you simply if you want to go

211
00:13:04,830 --> 00:13:05,880
back to the default settings.

212
00:13:07,800 --> 00:13:12,720
And on the totals, this would, of course, refer to this Tolia, so the last line in your table,

213
00:13:12,870 --> 00:13:14,490
which again is also customizable.

214
00:13:15,390 --> 00:13:19,650
So here I just want to highlight this, try it out yourself, go through all the options which are available

215
00:13:19,650 --> 00:13:20,080
for you.

216
00:13:20,100 --> 00:13:21,860
I just want to show you a few of them right now.

217
00:13:22,380 --> 00:13:28,020
And one good thing, from my point of view, simply, as soon as you're done, collapse it get back

218
00:13:28,020 --> 00:13:29,460
again because there's so many options.

219
00:13:29,460 --> 00:13:31,760
And if you do not do that, then you need to scroll a lot.

220
00:13:31,920 --> 00:13:36,180
So that is why choose what you want and then simply collapse it back like that.

221
00:13:36,180 --> 00:13:38,990
And then you have a little more space in here, don't you?

222
00:13:39,000 --> 00:13:42,290
Just grow too much under conditional formatting.

223
00:13:42,300 --> 00:13:43,500
You can take this here as well.

224
00:13:43,800 --> 00:13:46,400
Then you can see, you can specify what do you want to format.

225
00:13:46,680 --> 00:13:48,770
So the product, the profit or the sales.

226
00:13:49,050 --> 00:13:52,800
So for instance, let's go with the sales numbers here and then you can see you can adjust different

227
00:13:52,800 --> 00:13:54,450
things here, like the background color.

228
00:13:54,450 --> 00:13:59,010
You can turn this on and then, of course, you can go on the advance controls here, click on this

229
00:13:59,010 --> 00:14:01,080
one and then you can see additional things here.

230
00:14:01,170 --> 00:14:05,940
Like if you want to adjust the background color for the sales, you can see that currently they are

231
00:14:05,940 --> 00:14:12,090
like that simply because here you can find all the color scale apply to values only or values and totals.

232
00:14:12,150 --> 00:14:17,430
If you do that, then of course it will also change for the town's needs to be a few settings here.

233
00:14:17,760 --> 00:14:19,820
But this is also something you can specify here.

234
00:14:19,920 --> 00:14:24,630
So how you want to actually adjust your specific tailored to your needs, you can play around the colors

235
00:14:24,630 --> 00:14:24,920
here.

236
00:14:25,200 --> 00:14:32,100
So if I make this orange here like this one and now if it would apply this, if if I click here now

237
00:14:32,200 --> 00:14:37,680
to fill out the field, feel sorry and to value minimum, let's say the minimum here is 6000.

238
00:14:37,950 --> 00:14:39,890
Yeah, like that's the maximum value here.

239
00:14:39,900 --> 00:14:43,470
Specify this for let's say eleven thousand four now.

240
00:14:43,680 --> 00:14:47,570
And if you click OK here, you would see that now you get different kind of color here.

241
00:14:47,820 --> 00:14:50,370
So this is something you can adjust here and that's advanced controls.

242
00:14:50,610 --> 00:14:54,150
So based on what kind of field do you want to base on in this case?

243
00:14:54,150 --> 00:14:57,940
Currently it's the sum of the sales, which is the sales field now.

244
00:14:58,110 --> 00:15:00,020
Or you can also choose another kind of field.

245
00:15:00,060 --> 00:15:06,510
Also interesting because you basically could even depending on what makes sense or not, but you could

246
00:15:06,720 --> 00:15:07,590
form it here.

247
00:15:07,800 --> 00:15:09,780
The sales based on another field.

248
00:15:09,900 --> 00:15:13,120
So I can, for instance, format the sales based on the profit.

249
00:15:13,140 --> 00:15:17,600
This could also be an option because maybe I have a lot of sales, but the profit itself is low for

250
00:15:17,610 --> 00:15:19,800
specific product that could also be done here.

251
00:15:20,310 --> 00:15:22,170
And diverging can take this year.

252
00:15:22,170 --> 00:15:25,980
Then you can see that the colors are just in the house to have a center color here.

253
00:15:26,430 --> 00:15:31,290
But this is something you can simply adjust exactly the way you want it here for different kinds of

254
00:15:31,290 --> 00:15:34,800
in this case, as you can see here, different kinds of columns in your table.

255
00:15:35,770 --> 00:15:41,200
And so that would be an option for that at Mantic this year, for now, simply to go back.

256
00:15:41,830 --> 00:15:44,730
This would be the font color or the background color.

257
00:15:44,890 --> 00:15:46,550
You can do the same for the font color.

258
00:15:46,810 --> 00:15:52,300
So this would here simply form with the font color, even though now you can see the six thousand fifty

259
00:15:52,390 --> 00:15:53,680
you can't even see anymore.

260
00:15:53,770 --> 00:15:55,970
So there you would have to try a little bit different color.

261
00:15:56,680 --> 00:15:58,600
So that is why I don't use the font color.

262
00:15:58,930 --> 00:16:01,870
What's more interesting, at least for me, is, for instance, the data bars.

263
00:16:02,260 --> 00:16:06,430
So if I click on data bars here, you can see that now you have some kind of data bars which also allow

264
00:16:06,430 --> 00:16:11,790
you here to highlight what kind of in this case, what kind of sales you're more higher than others.

265
00:16:11,830 --> 00:16:14,940
So this could be an interesting background, but of course, you don't have to use it.

266
00:16:14,980 --> 00:16:16,210
Just an option I can show you here.

267
00:16:17,380 --> 00:16:22,450
And I think are Aitken's and PaPeRo, so if you go to a concert here, you can see those icons like

268
00:16:22,450 --> 00:16:24,880
these ones here, which can also adjust your table.

269
00:16:25,140 --> 00:16:26,800
So a lot of options here are available for you.

270
00:16:26,830 --> 00:16:30,550
And as I said, try them out yourself and see what works for you.

271
00:16:30,640 --> 00:16:30,880
All right.

272
00:16:32,300 --> 00:16:35,000
And the other things are some of them are kind of self-explanatory.

273
00:16:35,030 --> 00:16:39,650
So the background you want to change to color for the background of your table, do you want to change

274
00:16:39,660 --> 00:16:40,680
Borderfree for your table?

275
00:16:40,700 --> 00:16:43,040
You can apply this to you want to apply a shadow.

276
00:16:43,220 --> 00:16:47,690
If I click on the shadow option here, you can see that now for the visual that we have this shadow

277
00:16:47,690 --> 00:16:48,280
effect here.

278
00:16:48,410 --> 00:16:53,840
Also, maybe there's something you want to do here with your visuals itself could also be applied here

279
00:16:54,260 --> 00:16:58,800
and always if you want to remove something, simply Montegut and then you can see the original you back,

280
00:16:58,800 --> 00:16:59,050
right.

281
00:17:00,230 --> 00:17:01,730
So that these are the options here.

282
00:17:01,760 --> 00:17:04,730
And as I said before, depending on what kind of visual you choose.

283
00:17:04,760 --> 00:17:08,930
So if I take on this one, here is the budget, then I would see different options here for formatting.

284
00:17:09,050 --> 00:17:09,359
Right.

285
00:17:09,650 --> 00:17:12,230
So data colors, for instance, here, data labels.

286
00:17:12,230 --> 00:17:12,800
Interesting.

287
00:17:12,800 --> 00:17:15,050
If I take this, then I will see the data label up there.

288
00:17:15,079 --> 00:17:15,369
Right.

289
00:17:15,800 --> 00:17:17,210
Which also can then be formatted.

290
00:17:17,780 --> 00:17:22,750
So just let me show it to your data label here for the display units currently set to order.

291
00:17:22,910 --> 00:17:26,780
And you can also see maybe a little bit small, but you can see 34 currently.

292
00:17:27,380 --> 00:17:32,230
If you want to see the key, you want to see the complete number, simply go here and say no.

293
00:17:33,050 --> 00:17:37,220
And then what you see here is now it states thirty four thousand two hundred.

294
00:17:37,970 --> 00:17:43,890
So you can also just hear the display units or simply would refer to the best, which Paul thinks is

295
00:17:43,890 --> 00:17:44,150
the best.

296
00:17:44,150 --> 00:17:45,800
But it's also something you can adjust here.

297
00:17:46,040 --> 00:17:50,420
If you have the numbers, then might be the abbreviation for millions or billions or even trillions.

298
00:17:50,420 --> 00:17:51,050
Could be interesting.

299
00:17:52,150 --> 00:17:57,580
And you, of course, can apply the color as well as the position itself and also the texture.

300
00:17:57,610 --> 00:18:01,230
So if I make here this also 15, you see that now this number is bigger.

301
00:18:01,780 --> 00:18:06,910
But as I said, the main idea here is really that you can adjust this for any kind of official you have,

302
00:18:07,120 --> 00:18:11,260
simply select the visual, because then you have the option to go to the specific formatting option

303
00:18:11,260 --> 00:18:14,650
here and then adjust the specific formats for each of those visualizations.

304
00:18:14,800 --> 00:18:17,050
OK, so this is that for that.

305
00:18:17,980 --> 00:18:22,600
OK, so that was set for the tables as well as for, for instance, the bar chart.

306
00:18:22,840 --> 00:18:26,350
Maybe one last thing here is the country now.

307
00:18:26,350 --> 00:18:28,120
The country is actually a geographical field.

308
00:18:28,480 --> 00:18:34,810
So that is why if I simply click on country here, what you see is that PABI is creating a map for me

309
00:18:34,810 --> 00:18:35,370
automatically.

310
00:18:36,010 --> 00:18:40,390
So Poppea is smart enough yet to recognize that this is a geographical field.

311
00:18:40,600 --> 00:18:45,640
So these country names and that is why it's creating those country names here directly on them on a

312
00:18:45,640 --> 00:18:45,900
map.

313
00:18:46,970 --> 00:18:51,440
It's different from the table itself, even though I could selectively you'll always remember that you

314
00:18:51,440 --> 00:18:53,750
can change any words you simply selected first.

315
00:18:53,900 --> 00:18:54,980
Now the map is selected.

316
00:18:55,190 --> 00:18:58,730
And then if I would like to have a table, I can always go click on table here.

317
00:18:58,730 --> 00:19:02,980
And then I would see a unique list of my countries here currently sort of alphabetical order.

318
00:19:03,980 --> 00:19:08,810
But if I go back to my here this map visualization, I can see dots on a map.

319
00:19:10,630 --> 00:19:17,830
And just in case you do not, this is not working for you because sometimes click on the, um, sometimes

320
00:19:18,040 --> 00:19:22,690
if you click on this and, you know, you have a country, it does not stay in the country.

321
00:19:22,690 --> 00:19:26,530
It simply refers to the table because it thinks it's simply a string.

322
00:19:26,530 --> 00:19:27,350
It's not a country.

323
00:19:27,640 --> 00:19:32,100
So if this is not working for you, what you could do is you simply first select it.

324
00:19:32,320 --> 00:19:34,550
So as I said, it clicked on the country here.

325
00:19:34,690 --> 00:19:36,670
So let me ask you one more time country.

326
00:19:36,730 --> 00:19:39,670
You can see on the Top Ramen bar, they are the normal Rippon's.

327
00:19:40,090 --> 00:19:46,000
But if you take a specific, um, in this case, a specific column of your table and country, you see

328
00:19:46,000 --> 00:19:50,320
that now there are two additional fields, which is the table towards as well as the column towards

329
00:19:50,860 --> 00:19:52,070
an under column towards.

330
00:19:52,600 --> 00:19:56,320
There is actually the option here under Theta category Kolditz.

331
00:19:56,320 --> 00:20:00,220
Uncategorized, but you can click on this and then change it to something.

332
00:20:00,370 --> 00:20:02,140
For instance, in our case that would be country.

333
00:20:02,410 --> 00:20:05,680
It's also continental latitude, longitude, postal code and so on.

334
00:20:05,830 --> 00:20:10,720
So you can change the data type and sometimes it works for people that you first need to select country

335
00:20:10,720 --> 00:20:11,870
here instead of leaving.

336
00:20:11,890 --> 00:20:12,610
Uncategorized.

337
00:20:13,300 --> 00:20:16,540
And you will also see that if I country here, let me take it.

338
00:20:16,930 --> 00:20:20,020
You see that now a little globe I can appears here.

339
00:20:20,320 --> 00:20:24,130
This is referring to the fact that's probably as treating this field now as a geographical dimension.

340
00:20:25,410 --> 00:20:30,090
And the way I want the reason why I want to highlight this year is really the following that I have

341
00:20:30,090 --> 00:20:36,210
seen for some students that if you leave it as uncategorized, then the visualization works as it does

342
00:20:36,210 --> 00:20:36,570
for me.

343
00:20:36,990 --> 00:20:42,320
And for some they had you had used the first converting to a geographical field.

344
00:20:42,580 --> 00:20:48,000
So notice click on the field itself, go to the column tools and on the column tools here, change the

345
00:20:48,000 --> 00:20:51,990
data category to country just in case the and category doesn't work for you.

346
00:20:53,770 --> 00:21:00,580
So for the map, always remember, for each visual, simply check out what is under formate, because

347
00:21:00,580 --> 00:21:05,340
for the map, for instance, we also see not only here category, which is going to be turned off,

348
00:21:05,350 --> 00:21:09,880
I can turn this on and then I would see also the country names here, which at least one might point

349
00:21:09,880 --> 00:21:13,120
you if you already looks better than without the names.

350
00:21:13,870 --> 00:21:18,850
And then we can also go to the bubbles here and the bubbles allow us to increase the bubble size.

351
00:21:20,030 --> 00:21:21,530
So, for instance, I can make this bigger.

352
00:21:22,620 --> 00:21:23,260
Like that, right?

353
00:21:23,760 --> 00:21:28,650
That's already interesting, but what I currently see here is I can see bubbles, but they all have

354
00:21:28,650 --> 00:21:29,390
the same size.

355
00:21:30,210 --> 00:21:35,430
So maybe and this is probably the case that you also see this year for different kind of products,

356
00:21:35,430 --> 00:21:37,170
but also be true for the countries.

357
00:21:37,470 --> 00:21:38,300
For each country.

358
00:21:38,310 --> 00:21:39,420
We have different kinds of sales.

359
00:21:40,050 --> 00:21:44,910
So what if we like to connect the size of the bubble to the specific sales figure in this country?

360
00:21:45,630 --> 00:21:50,670
Then we can go back to the year, the first year the fields view, and then we see that.

361
00:21:50,670 --> 00:21:53,250
And here we have country put in the location.

362
00:21:53,790 --> 00:21:56,670
We have a legend, a latitude, longitude and also a size year.

363
00:21:57,180 --> 00:22:00,570
So if we track the sales now into the size drag and drop its.

364
00:22:01,440 --> 00:22:06,510
Like that, you see that now we have different sets of bubble sizes based on the states in this country

365
00:22:06,780 --> 00:22:09,630
and from my point of view now the bubbles are a little bit too big for me.

366
00:22:09,900 --> 00:22:15,180
So I go back to the formating option and go back to my bubbles here and say, I'd like to reduce the

367
00:22:15,180 --> 00:22:20,760
size here, maybe even use a slider, or yet tend to go inside and type in some value in here.

368
00:22:20,940 --> 00:22:24,710
Let's say let's try 10 and see that the bubbles now shrink a little bit.

369
00:22:24,720 --> 00:22:24,950
Right.

370
00:22:25,110 --> 00:22:27,630
So also something we can adjust here for the baptizes.

371
00:22:29,480 --> 00:22:34,520
So this is an option which we can then use in order to highlight actually the different kinds of sales

372
00:22:34,520 --> 00:22:36,860
numbers for this specific kind of countries in Amapa.

373
00:22:38,310 --> 00:22:42,800
And there's one other option I'd like to show you here, because a few of those settings like title

374
00:22:42,810 --> 00:22:45,570
background and so on, these are actually available for all the visuals.

375
00:22:45,810 --> 00:22:50,850
But there are certain kinds of options here under the formating, which are only relevant for specific

376
00:22:50,850 --> 00:22:51,210
visual.

377
00:22:51,540 --> 00:22:56,250
For instance, for the map, we have the bubbles as well as the bubble size right here.

378
00:22:56,620 --> 00:22:59,490
But we also have next to that's this heat map option.

379
00:23:00,030 --> 00:23:01,980
So you can go and heat map here.

380
00:23:02,160 --> 00:23:05,100
And then instead of bubbles, you can see heat maps.

381
00:23:05,790 --> 00:23:10,200
And again, you would you go to heat up here and then you can play around with the radius as well as

382
00:23:10,230 --> 00:23:10,960
the units here.

383
00:23:11,610 --> 00:23:14,520
So if you set the radius, let's say, trought maybe 50.

384
00:23:14,670 --> 00:23:14,930
Right.

385
00:23:15,180 --> 00:23:18,460
And you can see now the heat map itself is already bigger here.

386
00:23:19,020 --> 00:23:20,640
So this is something you need to play around this.

387
00:23:20,760 --> 00:23:21,690
There's no best practice.

388
00:23:21,690 --> 00:23:25,370
It's simply trial and error and maybe a little bit experience when you use a CPM.

389
00:23:26,190 --> 00:23:28,650
So let me take this one now and go back to my Roberts.

390
00:23:28,680 --> 00:23:30,670
Just wanted to show you that that's available for you as well.

391
00:23:32,190 --> 00:23:36,540
And another thing which I like to point out here for the map, the last thing here is actually the map

392
00:23:36,540 --> 00:23:39,200
styles, because some people like the default map.

393
00:23:39,210 --> 00:23:40,290
Some people don't like it.

394
00:23:40,510 --> 00:23:45,630
Then if you do not like it, simply go under theme here on a map starts and try out the other themes

395
00:23:45,630 --> 00:23:46,500
which are available for you.

396
00:23:46,750 --> 00:23:52,030
For instance, aerial would look like that, or there's also dark which would like that and so on.

397
00:23:52,080 --> 00:23:59,200
So these are the fields or fields which are available by default for Parvizi for this specific map here.

398
00:23:59,350 --> 00:24:01,860
Let's go back to wrote is the default Wando gentlemen.

399
00:24:02,550 --> 00:24:07,410
And always, if you do not like your changes, you have always the option to revert to default simply

400
00:24:07,410 --> 00:24:07,920
to go back.

401
00:24:09,450 --> 00:24:15,290
OK, so that's it for the first part here, just to explore what's available for us in the next part

402
00:24:15,330 --> 00:24:16,530
will create our first report.

403
00:24:16,710 --> 00:24:17,670
So stay tuned for that.