Sr Data Analyst Interview Questions

3,097 sr data analyst interview questions shared by candidates

Student retention over consecutive months. The idea was to compute each student's longest uninterrupted streak of monthly activity (i.e., attending at least one class per month), and then group the student count by length of these streaks. It clearly required advanced use of window functions like row_number, lead/lag, and cumulative logic.
avatar

Senior Data Analyst

Interviewed at Lingoda

3.6
Apr 9, 2025

Student retention over consecutive months. The idea was to compute each student's longest uninterrupted streak of monthly activity (i.e., attending at least one class per month), and then group the student count by length of these streaks. It clearly required advanced use of window functions like row_number, lead/lag, and cumulative logic.

Viewing 2011 - 2020 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 3,097 interview questions and reports from Sr data analyst interviews. Prepare for your interview. Get hired. Love your job.