Data Analysis Interview Questions

14 real Data Analysis questions asked in live technical interviews — each with a model answer. Updated weekly.

🎤 Auto-captured by Assisting AI during live interviews

These Data Analysis interview questions were captured from real interviews by candidates using Assisting AI. Each links to a full model answer. For real-time help during your own interview, get Assisting AI from ₹500/day.

Write an SQL query that, given a table with columns id, year, and revenue, returns for each row the previous year's revenue and the revenue difference.🟡 Medium · Coding · Asked 1×What is the count of records in the given tables?🟢 Easy · Conceptual · Asked 1×Why do we need pandas? We have SQL and PySpark. Why use pandas?🟢 Easy · Conceptual · Asked 1×Have you used pandas?🟢 Easy · Behavioral · Asked 1×What specific techniques have you used while optimizing price per person?🟡 Medium · Behavioral · Asked 1×How can I count the number of times each employee ID appears in a dataset?🟡 Medium · Coding · Asked 1×Given a list of customer purchase dates, identify customers who have not made a purchase on three consecutive dates.🟡 Medium · Coding · Asked 1×Find out the time employees spend in the office for a day.🟡 Medium · Coding · Asked 1×Provide the item with the second highest and second lowest sales. Also provide the most viable product, defined as the product with the lowest return rate and highest sales.🟡 Medium · Coding · Asked 1×Can you provide the second highest and second lowest sales items? Also, can you give the most viable product, defined as having the lowest return rate and highest sales?🟡 Medium · Coding · Asked 1×We have a table called score with two columns: ball (ball number) and score (score made on that ball). How would you calculate the average score per over?🟡 Medium · Coding · Asked 1×How would you analyze attendance trends to determine if more people attend the office on weekdays versus holidays, given that attendance counts are greater than 50?🟡 Medium · Coding · Asked 1×If we achieve 300% success records, how do we calculate the success percentage? Is it total successful divided by total?🟢 Easy · Conceptual · Asked 1×Calculate the friend acceptance rate for each date when friend requests were sent. A request is sent if action = 'sent' and accepted if action = 'accepted'. If a request is not accepted, there is no record of it being accepted in the table. The output should only include dates where requests were sent and at least one of them was accepted (acceptance can occur on any date after the request is sent).🟡 Medium · Coding · Asked 1×

🎤 Get Data Analysis questions answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500

Browse Other Topics