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 👌) - ◉ Database vs. Data Warehouse vs. Data Lake (150k+ views, easy explanation) - ◉ Top 5 Excel Skills to focus on this year (150k views, Quick Watch) - ◉ Jo explains her Power BI Job, typical work & challenges (100k views, another interview) - ◉ 7 Mistakes you shouldn't make in data analyst interviews - 💥 My Data Analyst Skills Playlist - ALL THE BEST for your INTERVIEWS 🌻🌞😀 ~ Location: Queens Park Memorial, Whanganui, New Zealand Camera: Canon M50 - Lens: Canon EF/M 22mm f/2 - Mic: Rode Video Mic Go - Software: Camtasia 2021 Video Editor - Sound Effects: Epidemic Sound - More on what I use for my videos: 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