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

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

Aabid S. - "I work at a startup that makes software for Law Enforcement and the FBI. Our product analyzes calls being made by prison inmates and "listens" for predictors of violence and criminal behavior. Our clients are some of the top state prisons in the country. Recently one of the largest states in the country decided to evaluate our product for their prison system. I demo'd the product to the officers and they seemed to like everything. During the presentation they asked us if the product was ADA com"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

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

Saurabh K. - "Clarify the goal of this exercise first. Diagnose the causes driving a 10% drop in facebook post views and recommend solutions to restore or grow post views. Ask clarifying questions and make assumptions where needed Clarifying Questions Is the drop in daily post views global or limited to a particular geographic region? Is the drop across all user segments or limited to certain demographics ? Are all types of posts impacted (text, image, video) ? Was"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

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

Mohammedsiraj A. - " Here is the breakdown of the information in those images: \\1. The Amharic Letter (Financial Request)\** This is a formal letter from the \Dawa Zone Muslim Affairs Council\\ addressed to the \\Commercial Bank of Ethiopia (CBE)\. \Date:\\ 30/6/2018 (Ethiopian Calendar) \\Subject:\\ Opening a savings account. \\Purpose:\\ The letter requests the opening of a savings account for \\Nuur Mosque\**, located in Bale Zone, Dawa City. \Authorized Signatories:\\"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

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

Kavi S. - "SELECT id, first_name, last_name, salary FROM employees ORDER BY salary DESC LIMIT 3 `"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

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