Skip main navigation

New offer! Get 30% off your first 2 months of Unlimited Monthly. Start your subscription for just £35.99 £24.99. New subscribers only T&Cs apply

Find out more

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

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now