Skip main navigation

KPI Exercises

In this lesson, we’re going to go hands on. You’re going to get to try your hand at calculating KPIs via series of labs now in many different areas. We’ve picked 4 four this lesson. So you’re going to get to do some basic business analytics, some financial analytics, some sales and marketing analytics, and some IT analytics. This is just a selection of the kinds of areas in which you could be doing analytics, but it’ll give you a chance to get your feet wet practicing with some of these things.
Most of the KPIs you could calculate are relatively simple so go ahead and now work your way through these labs and you’ll get to go hands on with analytics in a number of different areas.

Lesson 2: Business KPIs

In this lesson, we’ll roll up our sleeves and calculate a few different types of KPIs used often in the business world, with a special focus on Time to Market, Incident Resolution Index, Average Revenue, and Revenue Growth Rate.

Lab: Time to Market

In this lab, we’ll calculate the average time to market for a line of products.

The lab instructions can be downloaded as a PDF file here.

The data set for this lab can be viewed here. From the link, copy and paste all the data into a new worksheet in Excel Online.

This article is from the free online

Essential Mathematics for Data Analysis in Microsoft Excel

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education