Senior Data Analyst Interview Questions

3,099 senior data analyst interview questions shared by candidates

Assume that we have the following tables, with columns as indicated: Rides ride_id start_time end_time passenger_id driver_id ride_region is_completed (Y/N) Drivers driver_id onboarding_time home_region 1) Write a query that we could use to create a plot of the total count of rides completed in our San Francisco region, in each week over the last 12 weeks. 2) For each week over the last 12 weeks, write a query that will return a count of the total drivers who gave at least one ride. And only for driver’s based in San Francisco.
avatar

Senior Data Analyst

Interviewed at Lyft

3.8
Mar 15, 2024

Assume that we have the following tables, with columns as indicated: Rides ride_id start_time end_time passenger_id driver_id ride_region is_completed (Y/N) Drivers driver_id onboarding_time home_region 1) Write a query that we could use to create a plot of the total count of rides completed in our San Francisco region, in each week over the last 12 weeks. 2) For each week over the last 12 weeks, write a query that will return a count of the total drivers who gave at least one ride. And only for driver’s based in San Francisco.

Viewing 1121 - 1130 interview questions

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