6 hours 3 minutes
welcome to Model eight, in which I'm going to talk about people's tables and people charts.
And the first thing I'm going to talk about is what are actually those people tables?
Well, by definition,
or my loose interpretation of a definition of people Table
Babel Table in Excel
because we're talking of a pure table in excel is the extract off the significant information data from larger table.
So we have large table. And then we summarize this table in a way that suits our needs in order to express information in a desired way.
And the that information is contained in the original data. And we can use that using sums or averages or counting or other statistics.
So you have The definition is I wrote it on the screen and I'm trying to explain this'd in a little bit less sterile maenner
and let's go and just take a sneak peek on how
your table looks. So this is our original daytime. We're going to be using it throughout this module
for a ll the demos. And so this is this is one brother big
It has some 200 plus entries which represent ah reports about activities off some people in Ah, it's a support center of Cole Center
and they were solving some issues that the customers had.
So what we have is we had months separately in a day with India Mentor date Ah ah, in a separate
comb. Then we have the ticket number, which is not really important because they're all different. They're just the
serially determined ticket numbers. Then we have Who did the
the cook who took the call, the name of the technician. We have a customer name and then we have issued category which
there are 10 of them. So it can be softer issue, hardware issue whatever. They're classified in 10 categories,
then have ah, resolution can is it successor failed. So did they manage to resolve the case? The customer
for customer open the ticket and then we have a failure category. So it's fairly category zero. That means is it successfully resolved? And then we have 123 and four
and ah, this, uh, this represents the
so four is the most severe failure type in terms of they didn't solve the case. It all on DDE can be just that they didn't properly address it to the customer. So they did solve the question. But,
for example, didn't send him the mail or didn't get the confirmation from the customer. Whatever
s o, the ticket wasn't close. Although the
issue resolved so and then we have time to resolution in minutes.
And here is an example off people table I created
and we have just
name off our
and their average time to result.
So we collected all their
times, and then we calculated the average for each one of them.
And we're not going to go into details now about how it's done, because I'm going to explain that in next lesson
on. And of course, this papal table could have contained much more information than just average time to resolution.
But the whole point is that using very simple tool that exists in Excel,
you could create this without any need for typing, any formulas, any conditions and the additional columns. Anything you
excel does it for you just have to configure it properly.
So, uh, this is all about,
uh what did, uh,
what people tables are.
And the next lesson you will be able to see how to create your own people table from the
original data table.