Senior Data Analyst Interview Questions

2,910 senior 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 1901 - 1910 interview questions

Glassdoor has 2,910 interview questions and reports from Senior data analyst interviews. Prepare for your interview. Get hired. Love your job.