The majority of the interview sessions were dedicated to the case studies.
Sr Data Analyst Interview Questions
2,956 sr data analyst interview questions shared by candidates
3 SQL questions about paying accounts and understand signups and paying
Specific is growth related topics
**Business Case & Additional Business Questions:** 1. What additional data features/data columns/data series could have been useful for forecasting and predictive modeling? 2. What are things that can give you a better overall estimate of the order value? 3. How to ensure experimenting with adding more orders per courier (batching) with the intention of reducing costs doesn’t harm customer satisfaction? 4. Regarding the A/B test used to experiment with batching, how would you deal with the following segmentation challenge: I'm dividing users randomly, some of the final users of the same batch might end up in the control and others in the treatment group. So your segmentation between control and treatment wouldn’t be really working. 5. Let’s say to deal with the issue from the last question you segment your users into north and south. But then which other issues do you face? 6. A senior decision maker comes and asks you “Okay, you guys at the data department are quite smart, but how confident are you on your prediction model’s forecast?” I understand you used metrics to evaluate model performance and that the model is usually off by 10%, but how confident are you in your model’s forecast? How would you arrive at this metric. --- **SQL Questions:** 1. How to pivot the structure of a table for better aggregation? 2. What qualities make a good SQL Analyst?
cross join, pricing, forecast, bla bla bla
the home assignment is lengthy technical interview: interviewer didn't ask about home assignment - SQL question: they share screen with a question (how would you write a query for a particular example) and expect you to share the query on the spot with them. Mine could have been solved with window function in sql - business case questions: if your average order value is 5 and the mean order value is 3, which one would you go for? - how would you define pricing in a market where you are the first to enter - we enter a new market, and we forecasted 10k users per day and we only have 2k in the last 2 mths. how would you assess what's wrong?
Case question: From this data, where would you focus product efforts, if the goal was to maximize revenue per client?
Do you have at least 5 years of full-time experience in analytics?
What did you find interesting from the data? What would you do/improve if you could redo the assignment? How did you allocate your time to do the assignment?
Questions related to resume, salary expectations
Viewing 861 - 870 interview questions