Katkat

practice a little every day, paws crossed ♡

Data Analyst Interview Questions

Practice 9403 coding, system design and machine learning questions from 546 companies, sorted by role, topic and interview round. Every question has step-by-step hints, a code runner that supports 8 languages and an AI mentor; members also get the full solution walkthrough.

9403
Questions
546
Companies
11
Topics
8
Languages

Showing 1–8 of 8 results

  • Capital OneEasyData Analyst
    Analyze Mission Outcomes and Allocate Response Units

    Analyze incident response records to calculate unit win rates, evaluate the impact of rest periods on success, and rank response units using tie-breakers.

    Data Manipulation (SQL/Python)Online AssessmentPythonData ManipulationAnalytics
  • Home DepotMediumData Analyst
    Debug row loss after SQL joins

    This question evaluates SQL data manipulation and JOIN logic skills, including temporal and timezone-aware date handling and aggregation, within the Data Manipulation (SQL/Python) domain and primarily tests practical application-level competency.

    Data Manipulation (SQL/Python)Onsite
  • PinterestEasyData Analyst
    Compute percent of first-cancel users who never return

    This question evaluates a candidate's competency in data manipulation and temporal analysis using SQL/Python, focusing on computing user-level metrics and correctly ordering time-based events.

    Data Manipulation (SQL/Python)Technical Screen
  • PinterestMediumData Analyst
    Compute percent of first-cancelled users who never rebook

    This question evaluates proficiency in SQL data manipulation—specifically use of window functions, CTEs, deduplication by earliest timestamp, temporal comparisons, and cohort-level aggregation—within the Data Manipulation (SQL/Python) domain for a Data Analyst role in health‑tech product analytics.

    Data Manipulation (SQL/Python)Technical Screen
  • RipplingMediumData Analyst
    Find Payroll Bookings in the Latest Active Month by Country

    Tests PostgreSQL date manipulation, filtering, and aggregation by determining the most recent month with active payroll bookings and summarizing totals by country.

    Data Manipulation (SQL/Python)Technical Screensqlpostgresqldate-manipulation
  • The New York TimesEasyData Analyst
    Write SQL for content-view analytics

    This question evaluates proficiency in SQL-based data manipulation and analytics, including aggregation, distinct counting, NULL handling, timestamp/hour extraction, device grouping, and row-level ordering, and is situated in the Data Manipulation (SQL/Python) domain.

    Data Manipulation (SQL/Python)Technical Screen
  • WaymoMediumData Analyst
    Top 5 Most Efficient Vehicle Models

    This problem tests your ability to aggregate data from multiple tables, calculate performance metrics, and handle common SQL pitfalls like division by zero and NULLs.

    Data Manipulation (SQL/Python)Technical ScreenSQLAggregationJoins
  • eBayMediumData Analyst
    Explain Joins and Write Coupon SQL

    This problem tests your ability to perform multi-table joins, handle temporal data, and apply conditional aggregation to compute business KPIs like conversion rates and total transaction value.

    Data Manipulation (SQL/Python)HR ScreenSQLJoinsAggregation