bugfree Icon
interview-course
interview-course
interview-course
interview-course
interview-course
interview-course
interview-course
interview-course

Data Interview Question

Rise in Ride Cancellations

bugfree Icon

Hello, I am bugfree Assistant. Feel free to ask me for any question related to this problem

Requirements Clarification & Assessment

  1. Understand the Definition of Cancellation:

    • Clarify how Lyft defines a cancellation. Is it a ride canceled after booking, or does it include failed match attempts?
    • Determine if the cancellation rate is measured weekly, daily, or using another metric.
  2. Identify Data Sources:

    • Confirm the datasets available for analysis, such as rider logs, driver logs, and system logs.
    • Understand any relevant metadata like timestamps, geographical data, and user demographics.
  3. Assess Historical Trends:

    • Compare the current week's data with historical data to determine if this uptick is an anomaly or part of a trend.
    • Evaluate year-over-year (YoY) trends to understand seasonality effects.
  4. Segment the Data:

    • Determine if the increase in cancellations is uniform across all geographies or specific to certain areas.
    • Assess whether the uptick is consistent across different user segments (e.g., new vs. returning users, device types).
  5. Investigate External Factors:

    • Identify any external events (e.g., weather conditions, festivals, protests) that could influence rider behavior.
    • Check for any changes in competitor pricing or services.
  6. Validate Data Integrity:

    • Ensure there are no data logging issues or bugs that could artificially inflate cancellation numbers.