Quick Overview

Calculate a 2023 session signup rate in PostgreSQL with a precise cohort and denominator. Avoid duplicate conversion inflation and handle timestamp boundaries and empty cohorts.

Calculate the 2023 Session Signup Rate

Company: Airwallex

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Overview: Calculate a 2023 session signup rate in PostgreSQL with a precise cohort and denominator. Avoid duplicate conversion inflation and handle timestamp boundaries and empty cohorts.

Read the full Airwallex Data Scientist interview experience this question came from

Loading…