Data Analyst Interview Questions

Sreenisha S. - "Let me tell you about a time where a website I managed suddenly showed slow performance and the mistake on our side was it was unnoticed until a user reported the issue to management. As a PM for that project, I took full responsibility of the situation and worked with the engineering team to quickly resolve it. This mistake taught me the importance of focusing and monitoring non functional requirements as well in addition to new feature development /adoption where I was mostly spending my time"See full answer

Ravi K. - "select e.firstname as firstname, m.salary as manager_salary from employees e join employees m on e.manager_id = m.id where e.salary > m.salary; `"See full answer

Dhruv M. - "I was assigned to a project where the executive team said they wanted to "improve customer satisfaction" but provided no specific metrics, target outcomes, or scope. The initial brief was vague; they mentioned customer complaints were increasing, but hadn't quantified the problem or identified which customer segments or processes were involved. My responsibility was to lead the analysis and develop a solution; however, first, I needed to transform this ambiguous directive into a clearly defined"See full answer

KAI - "Answer: select fromcaller, count(DISTINCT tocallee) as num_calls from calls group by fromcaller having count(DISTINCT tocallee) >= 3 Setup: CREATE TABLE calls ( from_caller VARCHAR(20), to_callee VARCHAR(20) ); INSERT INTO calls (fromcaller, tocallee) VALUES ('Alice', 'Bob'), ('Charlie', 'Dave'), ('Alice', 'Frank'), ('Charlie', 'Heidi'), ('Charlie', 'Judy'); "See full answer

Bipin R. - "As you know, this is the most important question for any interview. Here is a structure I like to follow, Start with 'I'm currently a SDE/PM/TPM etc with XYZ company.... ' Mention how you got into PM/TPM/SDE field (explaining your journey) Mention 1 or 2 accomplishments Mention what you do outside work (blogging, volunteer etc) Share why are you looking for a new role Ask the interviewer if they have any questions or will like to dive deep into any of your experience"See full answer

Malay K. - "For any project based questions, it is important to structure your response clearly, showcasing your thought process, technical skills, problem-solving abilities, and how your work added value. Besides the STAR method, you can also use this kind of framework: 1. Start by selecting a relevant project (related to the role) Give the project background and what specific problem it solved. 2. Align the project's objective and your role Be specific about your role: were you the le"See full answer

Ashley C. - "I follow a variation of the RICE framework when prioritizing how I ship product features. I start by looking at: Reach: Because the customer segmentation across our product portfolio is so similar, I tend to hold a lot of weight on product features that will maximize our customer reach with a minimal LOE. Impact: After establishing which customer segments will benefit from the product feature, I determine the urgency and estimated impact on each customer segment based on customer i"See full answer

Aishwarya J. - "Looking into licensing data for users to match with the validity of their plans , to set up reporting okr's and metrics from the ground up and future problem sculpting for future feature additions I developed the metrics from the existing data tables , with uniform interpretation for datasets used across teams, keeping the modifications done in alignment with the requirements of the stakeholders. Hypotheses for licensing metrics was laid out in a defined manner where it was feasible to cherry"See full answer

Yuexiang Y. - "clarification: does the 10% drop is happening in all the platform, or it just happened in mobile app/ website? or in certain geographical region? does the drop has seasonality effect like it also happened in the LY? is there any regulation changes affect the customer views, like more censor on the inapoprate content? are all type of posts impacted? like image, video, text? Is it a sudden drop or gradually drop overtime? Segment and localize the drop Break down by dimension: geography"See full answer

Shashank K. - "Situation: Our company was going through tech stack updated and our team tasked to migrate existing code into Typescript(TS) and all future development to be written with TS within our codebase. TASK: Migrate existing codebase to TS and future integration to be TS compatible. ACTION: The team deep dived into picking up TS skill and learnt some basics and focused on delivering the migration in phases. I prioritised the files to migrate based on levels of complexity. I created a Fil"See full answer

Mark - "Questions: Should we consider US or Global? Is there any existing market insights/research around driverless cars adoption? Can we assume that driverless car technology is production / public ready by 2025? Is this focus on commercial or consumer use? Assumption: Let's look at US to start for our estimation since Driverless car regulation and adoption trend will probably differ per country Let's also assume we want to estimate market size for driverless cars in 2025 for consume"See full answer

David I. - "WITH filtered_posts AS ( SELECT p.user_id, p.issuccessfulpost FROM post p WHERE p.postdate >= '2023-11-01' AND p.postdate < '2023-12-01' ), post_summary AS ( SELECT pu.user_type, COUNT(*) AS post_attempt, SUM(CASE WHEN fp.issuccessfulpost = 1 THEN 1 ELSE 0 END) AS post_success FROM filtered_posts fp JOIN postuser pu ON fp.userid = pu.user_id GROUP BY pu.user_type ) SELECT user_type, post_success, post_attempt, CAST(postsuccess AS FLOAT) / postattempt AS postsuccessrate FROM po"See full answer

Amney M. - "it is really good explanation thanks it is really good explanation thanks"See full answer

Bradley E. - "Here's a simpler solution: select u.username , count(p.postid) as countposts from posts as p join users as u on p.userid = u.userid where p.likes >= 100 group by 1 order by 2 desc, 1 asc limit 3 `"See full answer

Kavi S. - "SELECT id, first_name, last_name, salary FROM employees ORDER BY salary DESC LIMIT 3 `"See full answer

Ravindra R. - "First, I want to understand why Airbnb is considering expanding into the restaurant space. Is the goal more user engagement, or unlock new monetization paths, or make the travel journey more memorable by connecting people with food? Next, I want to define what success would look like for this expansion. That could mean high guest engagement or a boost in revenue. Third, I will look at things like the volume of Airbnb travelers to the region, how big the dining market is, who the local competitor"See full answer

Niranjan M. - "Interesting question. Let's take a step back and focus on the WHAT and WHY of Google Flights. The narrative for Google Flights as a product or platform imo is: As a platform, I wish to make flight information available, so that users can make knowledgable decisions based on their travel needs. So essentially, it helps users by providing information, so that they can make optimized decisions. In order to determine if Google should introduce ads, we should consider the impact on both val"See full answer

Kofi N. - "const mergeIntervals = (intervals) => { const compare = (a, b) => { if(a[0] b[0]) return 1 else if(a[0] === b[0]) { return a[1] - b[1] } } let current = [] const result = [] const sorted = intervals.sort(compare) for(let i = 0; i = b[0]) current[1] = b[1] els"See full answer