Be prepared to be comfortable using Excel (e.g. Pivot Table, IF/AND/OR formulas, VLOOKUPs if need be, etc.). With regards to SQL, be able to talk about different joins, database relationships, primary vs. foreign key, as well as using different syntaxes (e.g. SELECT, FROM, WHEN, GROUP BY, ORDER BY, CASE WHEN, etc.).
Senior Data Analyst Interview Questions
2,958 senior data analyst interview questions shared by candidates
What metrics would you track? Tell me about a project you completed end to end.
Initial stage: majorly about your work experience
'How would you improve customer satisfaction?'
You're about to get on a plane to Seattle. You want to know if you should bring an umbrella. You call 3 random friends of yours who live there and ask each independently if it's raining. Each of your friends has a 2/3 chance of telling you the truth and a 1/3 chance of messing with you by lying. All 3 friends tell you that "Yes" it is raining. What is the probability that it's actually raining in Seattle?
If a dashboard / report was running slowly, what things would you look at?
1. Introduction 2. All companies info with completed and ongoing projects 3. Roles and responsibilities, 4. Stakeholder and product owners deliverables 5. General questions on coding part to understand the knowledge 6. Relocation status (which needs to be asked at the end when an interviewer is happy) 7. Healthy 2 ways talks on projects of SLK and etc
Around Data completeness and governance.
Quali sono le mie aspettative nei prossimi 3 anni
What do you know about Payscale?
Viewing 1151 - 1160 interview questions