May 2013
Beginner to intermediate
432 pages
11h 26m
English
Content preview from Excel Dashboards and Reports, 2nd Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 10: Components That Show Performance Against a Target
In This Chapter
• Using variance to compare performance with a target
• Displaying performance against organizational trends
• Creating a thermometer-style chart
• Creating a bullet graph
• Showing performance against a target range
No matter what business or industry you talk about, you can always point to some sort of target to measure data against. That target could be anything from a certain amount of revenue to the number of boxes shipped or phone calls made. The business world is full of targets and goals. Your job is to find effective ways to represent performance against those targets.
What is performance against a target? Imagine that your goal is to break the land speed record (currently 763 miles per hour). Your target speed is 771 miles per hour. After you jump into your car and go as fast as you can, you will have a final speed of some number. That number is considered to be your performance against the target.
In this chapter, we discuss some new and interesting ways to create components that show performance against a target.
Showing Performance with Variances
The standard way of displaying performance against a target is to plot the target and then plot the performance. This is usually done with a line chart or a combination chart, such as the one shown in Figure 10-1.
Figure 10-1: A typical chart showing ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.