Who is ready for an interview?
In this mock interview, Jo (my wife) & I ask each other 10 tricky data analyst interview questions. Watch the full thing to understand how to answer such questions.
The Questions 🎤❓
================
0:00 - INTRO
0:49 - Q1: How do you prioritize tasks when doing multiple projects?
1:57 - Q2: How do you transform raw data to Data Warehouse?
3:14 - Q3: What do you do when you have missing values in the data?
4:10 - Q4: Tell me about a challenging SQL Query you wrote?
5:56 - Q5: How would you design a dashboard or report?
8:39 - Q6: What is the largest dataset you ever worked on?
10:45 - Q7: What software do you use?
11:52 - Q8: Tell me about a time when you handled a difficult situation?
13:32 - Q9: What is your favourite Excel feature and why?
14:57 - Q10: Do you have any questions for me?
15:31 - Bloops
More on Data Analysis Skills:
=======================
If you are looking for videos on Data Analysis Skills, please watch below videos:
◉ 5 Skills you need to become a GREAT Data Analyst (200k+ views, must watch 👌) - https://youtu.be/gVr9f1GJdZc
◉ Database vs. Data Warehouse vs. Data Lake (150k+ views, easy explanation) - https://youtu.be/WgIbvkyY4mI
◉ Top 5 Excel Skills to focus on this year (150k views, Quick Watch) - https://youtu.be/cEuq_9CsHIY
◉ Jo explains her Power BI Job, typical work & challenges (100k views, another interview) - https://youtu.be/tScP7oRZey8
◉ 7 Mistakes you shouldn't make in data analyst interviews - https://youtu.be/f7lBYh1_9BQ
💥 My Data Analyst Skills Playlist - https://www.youtube.com/watch?v=gVr9f1GJdZc&list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
ALL THE BEST for your INTERVIEWS 🌻🌞😀
~
Location: Queens Park Memorial, Whanganui, New Zealand
Camera: Canon M50 - https://amzn.to/3LYesEz
Lens: Canon EF/M 22mm f/2 - https://amzn.to/3P8HG5B
Mic: Rode Video Mic Go - https://amzn.to/3930v9J
Software: Camtasia 2021 Video Editor - https://techsmith.pxf.io/c/3169105/506622/5161
Sound Effects: Epidemic Sound - https://www.epidemicsound.com/referral/gdubva
More on what I use for my videos: https://www.amazon.com/shop/chandoo
Note: I use affiliate links for my gear & software stuff. If you use my link to purchase anything, I will get a small commission from the providers (at no extra cost to you, obviously).
#mockinterview #datascience #dataanalytics