Dataset overview and preparation

0:00 So in employee data you could see this uh I have mentioned like you know employee ID then employee name department role and joining date okay and also I have put them know certain values and round so around uh 50 rows are there okay so 50 rows are there in this table you could see this in training status data like know count this 1,00 count okay so I have prepared and if you see the training data so it is having training ID Then training name right category like you know it is technical leadership soft skills and or and like you know it is it is technical leadership or soft skills if you check the level like it is advanced level intermediate level or beginner level okay so these are the cate levels I have put duration uh hours okay like it is 9 hours 1 hour 9 hours 7 hours 8 hours whatever way it is so I have put the random data now training status data also if you see this here then I have mentioned here as employee ID then training ID then assigned date when this uh course or training it was assigned to uh the particular um uh person okay particular person and what was the

1:34 completion date okay so completion date is also there and if it is completed okay then a status I have marked as completed if it is not then it is uh you know marked as pending now learning hours what was the learning hours and what was the score like know so we we check the score right so this is the data these are the data which I have prepared and if you check the date data so in date data also I have it's a normal one like you know date month year quarter week and days of week okay so like the data I have uh mentioned over here now now what I have to import the data what we will do here is that we will click in the excel workbook and then this is our data set so I'm going to select this once it is selected so what will happen at this uh excel okay and What about the tables it has?

1:58 It