SQL questions and questions to better understand how you manage stakeholders.
Senior Data Analyst Interview Questions
2,912 senior data analyst interview questions shared by candidates
There are always very pointed questions on the exact items that you have worked on. I suggest ensuring you have a good portfolio on how to respond to things like "Speak on one time that you handled a difficult technical situation in a way that most people would consider unusual and effective or 'outside the box'."
Basic questions related to SQL theory and some basic SQL queries. Much priority was given to puzzles in second round .
All the basic questions, walk through resume, greatest accomplishment, and strengths and weaknesses ... they could be a bit more creative with those. Also got asked a brain teaser: walk us through estimating how many pounds of meat McDonals sells a year.
Mostly focused on current tech skills, so describe what technology you're familiar with and how you use it.
Standard types of join with example
Situational questions and Data analytics related questions.
Task: Dataset contains information about sessions and conversions of a dummy website. From the given data: 1. Describe site audience (users who are coming to the website). What are the main markets? Channels? Which of them performs the best and which are the worst? 2. Map users into useful segments that can be used for continuous performance monitoring and optimisation. 3. Compare users from France, Germany and United Kingdom. Which market seems the most promising? Why? 4. Identify at least 3 major opportunities to focus on in order to improve eCommerce performance. Include hypotheses, backing data and suggestions for further actions. You can assume that each user made only one session, so user_id = session_id You can use tools of your choice. Present your homework in any way/format you see fit. Tips: More in-depth analysis (e.g., specific data-driven observations, hypotheses, comparisons, suggestions), as well as data visualisations and summaries are highly appreciated. Some insights (e.g., certain limitations) may also be provided in the conclusions.
Can you tell me about your current role and how your experience aligns with the type of work we do at HelloFresh especially in marketing data and stakeholder communication?
I was asked to solved the questions related to joins in sql
Viewing 431 - 440 interview questions