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