- [Instructor] So let's talk about 2
how to find high-level descriptive statistics 3
for our project data. 4
Now, you may be wondering, 5
"What is a descriptive statistic?" 6
Well, descriptive statistics are anything 7
that takes a large column of numbers, 8
and then turns it into a few numbers. 9
So, think sum, min, max, count and average. 10
Those are our classical descriptive statistic numbers, 11
and ones perfect for using with pivot tables. 12
So, first step is whenever we have project data like this, 13
we always want to turn it into a table. 14
So I'm going to hit Control T here to create a Control T table. 15
Make sure your cursor is within that table region 16
for this to work automatically. 17
Make sure that your table has headers, 18
then you can either hit the Enter key, 19
which I'm going to do, or press OK. 20
Next thing is, I got to get rid of those banded rows. 21
It's just a personal thing. 22
Now, under Table Name, I'm going to call this ProjectData 23
just to keep us organized. 24
And I want to add two different metrics to this. 25
So the first metric I want to add is the budget delta. 26
So you can see in Column E, 27
we have the Budget, Column F, we have the Expenses. 28
You can right-click on G and hit Insert. 29
This is going to create a new column, 30
and in this case, we're going to call it Budget Delta. 31
Hit Enter on that, then you can put in equals 32
in this first cell. 33
And in this case, we're just going to do Budget less Expenses. 34
Simple, right? 35
Hit Enter. 36
We have that right here. 37
And then we also want to get the project length. 38
So, in Column K, starting in Row 1, 39
I'm going to type in Project Length like that. 40
Very similar here, right? 41
We want to take the end date, less the start date, 42
and that's going to give us our duration. 43
All right, so once we've done that, 44
we're ready to create a pivot table. 45
Pivot tables love these special columns we've created, 46
so we're not just stuck using static data. 47
The columns we create also go into the pivot table. 48
So what I'm going to do is I'm going to go to Insert 49
and click Pivot Table. 50
In this top box here, 51
you can see it's automatically populated 52
with our table of data. 53
We're cool with a new worksheet, 54
so just go ahead and hit OK. 55
And then I'm going to zoom out just a little bit here. 56
So now that we've created our pivot table, 57
let's see if we can actually understand the budget deltas, 58
and the project lengths in terms of status and by person. 59
So, first thing I'm going to do is find Status on here. 60
I'm going to drag it all the way down to rows over here. 61
So that's our statuses, 62
and then I'm going to drop in the Assigned To here. 63
Now let's look for our special measures that we created. 64
We have Budget Delta. 65
I'm going to drop that in right there. 66
So that is the sum of our budget delta, 67
and next, we're going to drop Project Length here. 68
So that's the sum of the project lengths. 69
Perhaps it doesn't make sense 70
to have some for both of these. 71
So, let's look at Budget Delta here. 72
I'm going to click on this dropdown. 73
I'm going to click Value Field Settings here. 74
And in this case, I want to get the minimum 75
just for my knowledge. 76
So, this is the smallest budget delta. 77
We can see that some of these are negative, 78
so that's not necessarily good. 79
Next, let's take a look at Project Length. 80
I'm going to click on this down arrow here. 81
I'm going to click Value Field Settings. 82
I'm going to change this to Max. 83
Now that you see how to create 84
high-level descriptive statistics using pivot tables, 85
in the next video, we're going to talk about progress charts, 86
so you can actually measure 87
how well you are doing, 88
and see it visually.