behavior questions and hands-on tests
Sr Data Analyst Interview Questions
2,956 sr data analyst interview questions shared by candidates
Tell me about a project that had a lot of roadblocks, and how you overcame them
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
Viewing 871 - 880 interview questions