In this mock interview, Jo (my wife) and I ask each other 10 tough interview questions for data analysts. Check out the entire article to understand how to answer such questions.

The questions

0:00 – INTRO
0:49 – Question 1: How do you prioritize tasks when working on multiple projects?
1:57 – Question 2: How do you transform raw data into Data Warehouse?
3:14 – Question 3: What do you do if values are missing in the data?
4:10 – Question 4: Tell me about a challenging SQL query you wrote?
5:56 – Question 5: How would you design a dashboard or report?
8:39 – Question 6: What is the largest dataset you have ever worked on?
10:45 – Question 7: What software do you use?
11:52 – Question 8: Tell me about a time when you dealt with a difficult situation?
13:32 – Question 9: What is your favorite Excel function and why?
14:57 – Q10: Do you have any questions for me?
15:31 – Bloops

More about data analytics skills:

If you are looking for videos on data analytics skills, check out the videos below:

5 Skills You Need to Become a GREAT Data Analyst (200,000 views, must watch) – https://youtu.be/gVr9f1GJdZc
Database vs. Data Warehouse vs. Data Lake (150,000 views, simple explanation) – https://youtu.be/WgIbvkyY4mI
Top 5 Excel Skills to Focus on This Year (150,000 Views, Quick Watch) – https://youtu.be/cEuq_9CsHIY
Jo explains her Power BI job, typical activities and challenges (100,000 views, another interview) – https://youtu.be/tScP7oRZey8
7 mistakes not to make in data analyst interviews – https://youtu.be/f7lBYh1_9BQ

My Data Analyst Skills Playlist – https://www.youtube.com/watch?vgVr9f1GJdZc&listPLmejDGrsgFyDAWOAnEiK0P787q3grsk9R

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
Microphone: 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 about what I use for my videos: https://www.amazon.com/shop/chandoo

Note: I use affiliate links for my gear and software. If you use my link to purchase something, I will receive a small commission from the suppliers (of course at no extra cost to you).

#mockinterview #datascience #dataanalytics

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.