Tell me about a project that had a lot of roadblocks, and how you overcame them
Senior Data Analyst Interview Questions
3,097 senior data analyst interview questions shared by candidates
Interview was behavorial questions around the position and technical questions based on the past experience. After 2-3 weeks of silence, I get the message from HM that position has been closed due to internal changes. I am super disappointed for giving those hours of interview and getting such unprofessional response. STOP WASTING CANDIDATE's TIME
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?
Technical Round: Power BI theoretical and practical questions like PBI components, power query, power pivot, how to create calculate column and measure, explain about sumx, rolling avg, variables and their syntax, etc. SQL: theoretical and practical questions on window functions, joins, aggregates, etc.
Case question: From this data, where would you focus product efforts, if the goal was to maximize revenue per client?
Asked for my introduction at the start
1) Provide data analysis/ML ideas for a very messy dataset. 2) Provide business research for business unit economics in the city of your choice.
What do you know about Blue optima
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?
Viewing 911 - 920 interview questions