Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:05,160 --> 00:00:09,690
In this lesson, we're going to be looking at how we create dashboards within Power BI service.
2
00:00:09,780 --> 00:00:14,010
Now, this may get a little bit confusing because you may be looking at this report at the moment and
3
00:00:14,010 --> 00:00:15,660
going, Isn't this a dashboard?
4
00:00:15,660 --> 00:00:20,130
It's got key metrics, it's got key information, it's got the key summaries of the information that
5
00:00:20,130 --> 00:00:21,090
I want to see.
6
00:00:21,090 --> 00:00:21,990
And that would be right.
7
00:00:21,990 --> 00:00:24,270
It would be a sort of dashboard that you may present.
8
00:00:24,300 --> 00:00:27,600
However, it's got different terminologies in the pub, your service.
9
00:00:27,600 --> 00:00:32,400
So when we talk about reports, reports normally tend to be something that you can view on a larger
10
00:00:32,400 --> 00:00:32,910
screen.
11
00:00:32,910 --> 00:00:35,260
So you could look at this over your laptop.
12
00:00:35,280 --> 00:00:40,260
However, if you were trying to view this report on your phone and may be a problem because your phone
13
00:00:40,260 --> 00:00:42,170
has got a much smaller screen size.
14
00:00:42,180 --> 00:00:47,190
So what Microsoft did was when they were designing the pub, your service was to differentiate between
15
00:00:47,190 --> 00:00:52,770
a dashboard and a report and mostly to help with some of the mobile technologies so that when you're
16
00:00:52,770 --> 00:00:58,710
viewing information on your phone, you may be able to view key components of your report in a way that
17
00:00:58,710 --> 00:01:01,240
would be quite easy for your phone to work with.
18
00:01:01,260 --> 00:01:06,030
So in the next lesson, we're going to be looking at mobile reports in a little bit more detail.
19
00:01:06,030 --> 00:01:09,660
But in this one, we're going to start off by just creating our first dashboard.
20
00:01:09,660 --> 00:01:15,510
And what you do with the dashboard is you actually take components and you actually pin them into your
21
00:01:15,510 --> 00:01:16,250
dashboard.
22
00:01:16,260 --> 00:01:20,490
So you'll see at the moment that I've put my cursor onto a pin visual option.
23
00:01:20,490 --> 00:01:24,840
So where you see this icon, this allows you now to pin that into a dashboard.
24
00:01:25,080 --> 00:01:26,190
In this case.
25
00:01:26,190 --> 00:01:32,250
Also, please note that you, if you've got any filters on it, will take the filters into the dashboard
26
00:01:32,250 --> 00:01:32,640
as well.
27
00:01:32,640 --> 00:01:35,310
So the filtered data will actually go to the dashboard.
28
00:01:35,310 --> 00:01:36,810
But let's show an example of this.
29
00:01:36,810 --> 00:01:38,310
So we're going to start with pin visual.
30
00:01:38,310 --> 00:01:42,600
I'm going to click on that and you'll see that it will come up with an option and it says, Where do
31
00:01:42,600 --> 00:01:43,710
I want to send this to?
32
00:01:43,740 --> 00:01:48,740
Now I do have an existing dashboard that was actually created when we bought the data set into the pub
33
00:01:48,740 --> 00:01:50,580
by service right at the beginning of the course.
34
00:01:50,580 --> 00:01:51,600
But we're not going to do that.
35
00:01:51,600 --> 00:01:55,770
We're actually going to create our own dashboard and we're going to call it our sales dashboard.
36
00:01:56,190 --> 00:01:58,380
So we're going to include that.
37
00:01:58,890 --> 00:02:02,580
So we're going to say that we want our sales dashboard, we're going to pin that in there.
38
00:02:02,910 --> 00:02:07,320
And you can see now that we can go to the dashboard and and it's been pinned and we can also look at
39
00:02:07,320 --> 00:02:08,280
the mobile layout.
40
00:02:08,310 --> 00:02:12,270
As I said, the next lesson we're going to be looking at mobile and a bit more detail, but let's just
41
00:02:12,270 --> 00:02:14,940
go ahead and pin a few more visualizations in here.
42
00:02:14,940 --> 00:02:17,310
So let's include our total profit in this case.
43
00:02:17,310 --> 00:02:19,200
Now it is going to be into an existing dashboard.
44
00:02:19,200 --> 00:02:21,450
We're going to put it into our sales dashboard.
45
00:02:21,450 --> 00:02:22,740
So we're going to accept that.
46
00:02:22,890 --> 00:02:24,630
Let's put our trend graph in.
47
00:02:24,630 --> 00:02:26,640
So again, we've got to open visual here.
48
00:02:26,640 --> 00:02:30,270
So we're going to pin that in existing dashboard, pin that in there.
49
00:02:30,510 --> 00:02:35,400
Again, let's use this also our column graph and pin that in.
50
00:02:35,400 --> 00:02:39,630
So you'll see now that we've got a couple of pins that we've done.
51
00:02:39,630 --> 00:02:44,760
So if we go back to our workspace, go back to the my workspace, what you'll now see that is in your
52
00:02:44,760 --> 00:02:49,980
all or your content is that you've now got the sales dashboard that has been created.
53
00:02:50,490 --> 00:02:51,330
Let me click on that.
54
00:02:51,330 --> 00:02:52,680
This will now open.
55
00:02:52,680 --> 00:02:58,050
And what it does is it now shows you each of those visualizations as just its own visualization.
56
00:02:58,140 --> 00:03:03,570
Now, please note, when you're pinning visualizations into a dashboard, you can actually pin visualizations
57
00:03:03,570 --> 00:03:04,920
from different reports.
58
00:03:04,920 --> 00:03:07,140
So it doesn't have to be all from one report.
59
00:03:07,140 --> 00:03:10,260
You could have different reports and then actually pin those in there.
60
00:03:10,620 --> 00:03:14,250
So what you can do with this now is you can actually resize these if you want.
61
00:03:14,250 --> 00:03:18,930
By the way, if you click on it, you actually go straight back to your report, which is a little annoying.
62
00:03:19,050 --> 00:03:19,860
I keep doing that.
63
00:03:19,860 --> 00:03:21,660
But over there, there we go.
64
00:03:21,660 --> 00:03:25,500
What I wanted to show you is you can actually resize these if you wanted to.
65
00:03:25,500 --> 00:03:30,180
Resize the size doesn't always go to where you want it to go.
66
00:03:30,180 --> 00:03:30,870
Oh, there we go.
67
00:03:31,110 --> 00:03:32,130
That's one option.
68
00:03:32,940 --> 00:03:39,150
So we've now got these elements, as I say, into our dashboard, and it's been put into its own dashboard.
69
00:03:39,270 --> 00:03:42,420
Now, one of the reasons, as I say, is for our mobile layout.
70
00:03:42,420 --> 00:03:45,570
So in the next day, so we're going to be looking at that in a little bit more detail.
71
00:03:45,600 --> 00:03:50,010
What I do want to look at while we care, though, is that we do get some additional functionality that
72
00:03:50,010 --> 00:03:52,140
you can use within your your service.
73
00:03:52,290 --> 00:03:58,050
So if we go to our total sales and you click on the three ellipses, you will see that a set of options
74
00:03:58,050 --> 00:03:59,400
will be presented to you.
75
00:03:59,400 --> 00:04:04,350
So we do have abilities to be able to add comments and as we said before, be able to put this into
76
00:04:04,350 --> 00:04:07,920
teams, copy the visual as an image, go to the report itself.
77
00:04:08,700 --> 00:04:12,570
However, the one that I wanted to focus on, there's a couple that I want to focus on, but the first
78
00:04:12,570 --> 00:04:14,570
one I want to focus on is manage alerts.
79
00:04:14,580 --> 00:04:18,990
So when you got these card elements, you can actually create alerts for these.
80
00:04:18,990 --> 00:04:22,050
So when you say manage alert can add alert rule.
81
00:04:22,050 --> 00:04:29,730
And what you can decide is that if this goes above or below a specific threshold, then a alert will
82
00:04:29,730 --> 00:04:30,780
be generated.
83
00:04:30,780 --> 00:04:33,540
And you can also say how often do you want to be notified?
84
00:04:33,540 --> 00:04:36,780
So you can say I'm at most every 24 hours or at most an hour.
85
00:04:36,780 --> 00:04:42,540
So this will now send an email to you if your system goes above or below those thresholds.
86
00:04:42,540 --> 00:04:43,980
So that's the first thing you can do.
87
00:04:44,010 --> 00:04:50,160
You can actually create alerts, but please note it is normally only on these card visualizations that
88
00:04:50,160 --> 00:04:50,880
you can do it.
89
00:04:51,390 --> 00:04:56,400
The next part that I wanted to speak a little bit about was the ability to be able to create insights.
90
00:04:56,400 --> 00:05:02,400
So Microsoft has been using artificial intelligence pattern recognition systems.
91
00:05:02,400 --> 00:05:07,110
It's basically been working a lot on the fact of trying to use artificial intelligence to assist with
92
00:05:07,110 --> 00:05:08,220
data analysis.
93
00:05:08,220 --> 00:05:14,340
So if you click one of these cards or even there we go, I've just gone back to it again.
94
00:05:14,430 --> 00:05:18,150
Let's let's get back to our sales dashboard.
95
00:05:18,180 --> 00:05:23,720
If you go even to one of these here, you'll see that you can also view the insights on a specific visualization.
96
00:05:23,730 --> 00:05:30,930
So you can view the insights for a whole report, or you could do it for just one component or one visualization.
97
00:05:30,930 --> 00:05:36,180
So if we go to view insights, you'll now see that it will now look at what the information that is
98
00:05:36,180 --> 00:05:37,320
behind this card.
99
00:05:37,320 --> 00:05:40,200
And you can see now that it's searching for insights.
100
00:05:40,200 --> 00:05:45,090
And what it does is it gives you a visualization and it then gives you a description of what it has
101
00:05:45,090 --> 00:05:45,780
found.
102
00:05:45,780 --> 00:05:50,430
So basically it's saying this account that store accounts for the majority of sales, no discount is
103
00:05:50,430 --> 00:05:51,960
noticed to be more sales.
104
00:05:52,200 --> 00:05:56,110
The computers and camcorders, cameras and camcorders have noticeably more sales.
105
00:05:56,130 --> 00:06:01,950
So basically it's trying to go through this, do data analysis and then export inside to you.
106
00:06:02,160 --> 00:06:04,920
I would suggest that try this with your own data.
107
00:06:04,920 --> 00:06:10,410
You may find that it's still quite in development, probably got a bit of work to do, but this is really
108
00:06:10,410 --> 00:06:15,660
where they're trying to take things as to support your data analysis is being able to give you these
109
00:06:15,690 --> 00:06:16,770
these insights.
110
00:06:17,430 --> 00:06:20,010
So we're going to just exit focus mode on that one.
111
00:06:20,010 --> 00:06:22,680
And as I say, you also you'll find these options.
112
00:06:22,680 --> 00:06:24,840
You can give insights on this one as well.
113
00:06:24,840 --> 00:06:30,270
So if we go to view insights, get insights there and again, now you'll see that.
114
00:06:31,090 --> 00:06:33,850
It will generate these insights for us to look at.
115
00:06:35,050 --> 00:06:37,510
Can actually do this if you go back to report as well.
116
00:06:37,510 --> 00:06:42,670
So if we go back to the my workspace, go back to our sales report, you will see that there is a get
117
00:06:42,670 --> 00:06:44,380
insights for the report itself.
118
00:06:44,380 --> 00:06:49,390
So on that it will now look at the entire report and look to generate insights.
119
00:06:49,630 --> 00:06:50,440
So there we go.
120
00:06:50,440 --> 00:06:56,200
We've now got some insights that have been created so you can see recent trends on some cells.
121
00:06:56,200 --> 00:06:57,190
Deep trend.
122
00:06:57,700 --> 00:06:59,470
Some options that it has found.
123
00:06:59,920 --> 00:07:02,500
As I said just there, you can experiment with that.
124
00:07:02,500 --> 00:07:02,920
See?
125
00:07:02,950 --> 00:07:04,150
See what you can find.
126
00:07:04,550 --> 00:07:04,750
Okay.
127
00:07:04,750 --> 00:07:06,880
We're going to conclude that lesson in the next one.
128
00:07:06,880 --> 00:07:11,590
We're going to continue to look at using our dashboards and seeing how we can use them in the mobile
129
00:07:11,590 --> 00:07:12,310
reports.
130
00:07:12,310 --> 00:07:13,690
I will see you in that lesson.
12943
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.