(high pitch tech noises) - So I hope you enjoyed the exercise of going through the challenge. As you remember the goal was to take every single thing that we've talked about in this course and apply it all, you know, no big deal. But no, mostly this was supposed to be just a quick thinking exercise. And we of course had four primary objectives. Understand, maybe you need to reorganize the data, think about a visual approach, sketch it in a form to present to a client, and make sure its defensible.
So if you remember, this was the report that we were given. This was the quote unquote perfect report. Sales performance ranking report, I can see people, I can see different categories, how much different people sold, how well they did compared to each other, but it's really just a big giant pile of numbers. So, in my mind, this is no perfect. Of course, my goal is to make it more perfect and here's how I did it. One thing I like to mention is that, I can give you 20 minutes to do a quick sketch and as you can see here this is far more than the quick sketch, this is an intermediate version of the sketch, done in illustrator in order to show my clients a fully color and a little bit more polished version.
So the first thing you'll notice about what I've done here is as I looted to in the objectives, I thought a lot about reorganizing my data. One of the big changes I made was I took the four things that my client told me were the most important aspects of this data, and I moved them up to the top. So, product index, combined index, PRU, and overall rank. Rather than burying those at the bottom of the report, or in some cases, right in the middle of the report, they're right up there on top. And I also added ranking to the indexes as well as the PRU.
So right out the gecko, you can see how these varies sales people are comparing to each other across these important categories. One other thing you'll notice is that for the PRU and the indexes, really the most important thing is who's doing the best and who's doing the worst. And that is carried through most of this report. There's red and then there's green. But you also see that for the overall rank, my client did want to see how everyone's performing not just the best and the worst. So that the only place in this entire report where you'll see the different variations of color.
The very best are number two, three, four, and five. The rest of this report is showing the different product categories, so once again, rather than have the report broken into categories like, total units, penetration rate and then income, rather than that it's more about show me what's-its at once, show me do-hickies at once, et cetera. Now, before you get too confused by this, remember that this is a sketch, and you'll notice that the data values are the same for what's-its as well as do-hickies, that's not reality, it was just my way of quickly sketching something together in illustrator without having to create a whole bunch or bars and size them and use real data.
So focusing in on what's important here, in the what's-its category, you'll notice that I've flipped it on it's head a little bit, while I'm looking at one person at a time, as I mentioned before, I am not showing you units and then penetration rate, et cetera, it's all in one. And so here I have the total units sold were 60, out of those 47 of them were what's-its and here I have my penetration rate, which of course matches that math, and the total income value to the right of that. You'll also note that I am using the good ol' fashion, boring ol' wonderful bar chart because, in this case, I thought it was a great way to show the data, very understandable, as I've been arguing throughout this course.
And as I mentioned earlier, throughout this report you can see the best, you can see the worst, both in total units, as well as in the particular category, units sold, as well as in percentage, penetration rate, and income rate. So all that data in a very dense way, but easily understood by the audience. I really hope you enjoyed this challenge, I know I had a lot of fun doing it, and I hope also that what you came up with in the end, was an improvement over what you might have come up with before you took this course.
- Describe the process by which individuals’ interests are incorporated into data visualizations.
- Differentiate the use of the Ws in data visualization.
- Explain techniques involved in defining your narrative when visualizing data.
- Identify the factors that make data visualizations relatable to an audience’s interests and needs.
- Review the appropriate use of charts in data visualizations.
- Define the process involved in applying interactivity to data visualizations.