Data Analyst Data Analysis Interview Questions

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

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

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

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

Logan S. - "Clarify the Goal (What Does Success Look Like?) Asked: Why is DoorDash launching bikes for Dashers? Is it to: Expand Dasher availability in dense urban areas? Lower delivery times or costs? Increase access to work for those without cars? Each possible goal shapes the metrics differently. Broke Metrics into Categories: Operational Metrics Measure how well bikes are functioning as a delivery method. Average delivery time (bike vs car/walk) Order completion rate for bike Dashers On-t"See full answer

Kusheta K. - "In one of my projects, l analyzed customer purchase data for a retail company to under why sales were decrease"See full answer

Rajdeep J. - "Let's take Google Fitbit as the product and analyze how to identify its competitors. 1. Identify Direct Competitors (Similar Wearables & Smartwatches) Fitbit is a fitness tracker and smartwatch brand, so direct competitors include: Apple Watch Series (Apple) Samsung Galaxy Watch (Samsung) Garmin Wearables (Garmin) Amazfit & Zepp (Huami) Xiaomi Mi Band (Xiaomi) These brands offer smartwatches or fitness bands with similar health-tracking features. 2. Use Launch Events for Insi"See full answer

Ankit kumar S. - "To analyze a year-over-year (YoY) slowdown in transactions, you should start by understanding the context, segmenting data, identifying potential drivers, and then formulating actionable recommendations. This involves a structured approach that includes a thorough examination of the data, both internally and externally. Understand the Context: Define "transactions": What specific transactions are being analyzed (e.g., website purchases, in-store purchases, total transactions)? Timeframe: Sp"See full answer

Ankit kumar S. - " logo Contact Interview Preparation Application Process Career Advancement Onboarding and Orientation Common Interview Questions Dashboard Creation Interview Questions and Answers Dashboard Creation Interview Questions and Answers What is a dashboard? Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"See full answer

Kusheta K. - "After cleaning and organizing the data the dataset become retable and ready for analysis. This helped the tame make accurate decision based on clean data"See full answer

Madina A. - "I’d assess a new feature launch by first checking if it achieved the goal we set before launch, whether that’s driving engagement, monetization, or retention. I would look at adoption and usage to see if users are discovering and repeatedly using it, the impact on the main KPI we targeted, and guardrail metrics to ensure there’s no negative effect on core product health like retention, crashes, or satisfaction. Ideally I would measure this through an A/B test or phased rollout and complement the"See full answer

Himanshu G. - "To model ROI for a product launch, the first step is to define the timeline you're targeting Example 6 months post-launch, 1 year, or even 5 years. Tip: Start with a 1-year ROI projection to estimate near-term returns, and build a 3-year projection to evaluate growth and scalability. ROI is essentially the net return over that period: Profit=Revenue (within timeline)−Total Cost (from project start) Total Cost includes both fixed and variable costs incurred since t"See full answer

Kusheta K. - "“I once worked with a dataset that had missing and inconsistent tracking. I first evaluated data quality, cleaned what was reliable, and documented assumptions. Then I collaborated with engineers to implement improved event tracking. This ensured more accurate analysis in the future and improved decision-making.”"See full answer

Catherine T. - "We want sales to grow, in order to have a growth in revenue. And customer usage as well as it allows to see if our product lead more engagement from our users. So to be able to see this overall evolution I would make a line chart for both : Sales : with month on x-axis and sales revenue on y-axis Customer Usage : with month on x-axis and a KPI allowing to measure customer usage (nblogins or nbsessions or nbgamesplayed, ... depending on the industry) on y-axis Moreover, after knowing th"See full answer

Kevin T. - "When a stakeholder’s request is ambiguous, I start by clarifying the goal and defining what “success” looks like. I ask targeted questions to understand the business problem, the timeframe, the scope/location, and who the analysis is for. Then I confirm definitions (metrics, segments, filters), agree on the expected output format, and restate the request back to them in one sentence before I begin."See full answer

Gabriel P. - "Hi, my solution gives the exact numerical values as the proposed solution, but it doesn't pass the tests. Am I missing something, or is this a bug? def findrevenueby_city(transactions: pd.DataFrame, users: pd.DataFrame, exchange_rate: pd.DataFrame) -> pd.DataFrame: gets user city for each user id userids = users[['id', 'usercity']] and merge on transactions transactions = transactions.merge(user_ids, how='left"See full answer

Arshad P. - "Schema is wrong - id from product is mapped to id from transactions, id from product should point to product_id in transcations table"See full answer

Katherine B. - "We want to use rigorous framework for evaluating shipping a new feature — ideally an A/B test. If an A/B test is not available, we first evaluate quantitative data; we look at feature adoption metrics, time-to-use, retention and frequency of visitation. What does the business impact of the feature on conversion rates, revenue per users and LTV, and secondarily evaluate any error rates that could be occurring after the launch of the new feature. It’s important for this analysis to perform segmen"See full answer