As a data scientist, when you’re not investigating spikes or dips in your data, you might be building dashboards of KPIs, or key performance indicators for a company.

KPIs are often displayed on TVs on the walls of the office, and serve as high level health metrics for the business. While every company’s metrics are defined slightly differently, the basics are usually very similar.

In this lesson we’ll take a look at basic KPIs like Daily Revenue, Daily Active Users, ARPU, and Retention for a video game, Mineblocks.



This company has two tables, gameplays and purchases. The purchases table lists all purchases made by players while they’re playing Mineblocks.

Complete the query to select from purchases.

select * from /**/ order by id limit 10;

The gameplays table lists the date and platform for each session a user plays.

Select from gameplays.

select * from /**/ order by id limit 10;

Sign up to start coding

By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Already have an account?