- [Instructor] Okay, so what we're going to do here 2
is we're going to take everything 3
we've learned so far in this course 4
and step-by-step, we're going to take it all 5
and put it all into an awesome dashboard. 6
So, let's get started just familiarizing 7
ourselves with the data. 8
So here I have a list of safety incidents. 9
We have our project names on the left. 10
You can take a look at these. 11
The Giggle Gas Plant, what happened? 12
A minor fire caused by a giggling flame. 13
That's real. That happens. 14
Okay, so we have our list of safety incidents over here. 15
We also have some project data. 16
In this case, I already am coming in with the plan value, 17
the earned value and the actual cost. 18
As well, we have some dates 19
and some things that we're going to want to add. 20
So, let's start with the first thing 21
we always want to do when someone sends us data like this, 22
we want to create a table. 23
So, I'm going to put my cursor anywhere 24
in this continuous region of data, CTRL + T, 25
and I just hit enter really quickly 26
'cause I know my table has headers. 27
Turn off those banded rows 'cause they're terrible. 28
And then rename the table to something that reminds you 29
of what the worksheet tab name is. 30
So, in this case, Project space Data, 31
the table name Project, with no space, Data. 32
The other thing I want to do is take a look at these dates. 33
This just won't do, 34
I can't deal with dates that look like this. 35
So I'm going to highlight B2 all the way through C26. 36
Hit that dropdown from on the home tab to change the type, 37
and I'm going to change that to a short date. 38
And I'm going to do the same thing, 39
I'll go to safety incidents over here. 40
Control + T, my table has headers. 41
That looks good, hit okay. 42
I like when you have two different tables 43
to change the colors of these tables. 44
So, I'm going to change the format 45
to an orange format like this. 46
I'm going to highlight this whole thing here. 47
We'll make that a short date. 48
And then, finally, under Table Design, Under Table name, 49
I'm going to rename this to rename this to Safety Incidents. 50
All right, so now that we have this laid out 51
and our data types are set, in the next video, 52
we're going to actually go into calculating those KPIs.