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