Prepare for and practice interview questions from KPI Partners across topics like Python, Product Metrics, Statistics and more.

KPI Partners Interview Questions

KPI Partners Interview Guides

Data Pipelines

Design a data pipeline for hourly user analytics.

Data Pipelines and Aggregation

Let's say that you're in charge of getting payment data into your internal data warehouse. 

Payment Data Pipeline

Aggregating and collecting unstructured data.

Unstructured Data Pipeline (ETL)

Designing a pipeline for ingesting media to built-in search within LinkedIn

Text Search System

SFTP Pipeline

Data Modeling

Design a data warehouse for a new online retailer

Retailer Data Warehouse

Say you are tasked with designing a data mart or data warehouse for a new online retailer.

How would you design the system?

Note: Sketch a star schema to explain your design.

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Statistics

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Question	Topic	Difficulty	Ask Chance
Retailer Data Warehouse	Data Modeling	Medium	Very High
Boarding Times Bias	Statistics	Medium	Very High
Decreasing Comments	Product Sense & Metrics	Easy	Very High