In this video, Maven Analytics Founder Chris Dutton and Lead SQL Instructor John Pauler will field audience questions, all around data analyst and data scientist interviews.

Chris and John have combined experience of over 30 years in the analytics field and have hired dozens of analysts and participated in hundreds (if not thousands) of interviews as hiring managers.

You can check out similar sessions from the past few weeks on Resumes, Data Analyst Portfolios, and LinkedIn Profiles here on YouTube.

RESUMES:
   • How To Create The Perfect Data Analys...  

PROJECT PORTFOLIOS:
   • How To Create The Perfect Data Analys...  

LINKEDIN PROFILES
   • LinkedIn Profile Optimization Tips - ...  

For those of you looking for a great, purpose-built analyst project portfolio platform to host your projects (for free), check out the Project Showcase: https://mavenanalytics.io/showcase

And if you want more content on Interviewing specifically, check out this article from our Python instructor Chris Bruehl:
https://mavenanalytics.io/blog/analys...

⏱️Timestamps⏱️
00:00 - Intro
01:41 - How do you sound confident when talking about and describing projects?
03:35 - How would you best approach being stumped due to a gap in knowledge?
6:13 - What are the best projects to showcase in interviews for data analyst jobs?
8:01 - How would you prepare for a case study estimating marketing campaign performance?
11:00 - What should you do if a job requires a certain tool or skill you haven’t used before?
13:08 - How long should a case study be?
16:03 - How to sound confident and passionate for a job without experience.
18:57 - Should I have projects strictly focused on data cleaning for each tool?
21:30 - How to prepare for an analyst interview in a specialty field.
23:12 - What interview questions do people often perform poorly on and how would you recommend approaching them?
27:22 - Does a large career gap prevent recruiters from considering my resume?
30:29 - What are questions I should ask an employer in an interview?
32:27 - What to do if you can come up with a framework to solve a problem in a case study but don’t know the right numbers to put in?
33:58 - Is it okay to add volunteer jobs as experience?
35:02 - Example interview question: Given the data we currently have, what additional types of data should we consider collecting?
36:40 - Are you a bad analyst if you struggle at making visually appealing charts?
40:00 - What should you do if an interviewer uses abbreviations that you have never heard before?
41:21 - What is the smart answer to the question about reasons to transition to a data career?
42:33 - What are the differences between back-end and front-end bi analysts?
45:10 - How to talk about being laid off but still coming across as a great candidate
47:32 - How can you ask for feedback after an interview? Is it a good idea?
50:12 - What are the skills I need to develop apart from Excel and Power BI and showcase it in my resume?
52:38 - How can you determien what the main responsibilities of a job are when a job description is very vague and wide ranging?
54:05 - How do you reply to the question, “Tell me about yourself?”
56:54 - How do you reply to the question, “Why should we hire you?”
58:38 - What optimization do I need to do on my LinkedIn profile?
59:07 - How to effectively demonstate your motivation in an interview
1:01:11 - Should we send a cover letter to explain a job gap?
1:02:26 - Outro

🎉 Ready to build practical, job-ready data skills of your own? 🎉

Spring Savings: Up to 40% off at Maven Analytics!

Create your custom learning plan today, and save up to 40% on all-access memberships when you upgrade to a paid account.

All Maven memberships include:

✓ Unlimited access to ALL courses & paths
✓ Customized learning plans
✓ Skills assessments
✓ Free practice data sets
✓ Guided projects
✓ Portfolio builder & Showcase
✓ Private student dashboard
✓ Live instructor chat support

Join today and see why we've earned 50,000+ perfect 5-star reviews from students around the world. 👉 https://bit.ly/3VTsmj0

This is a limited-time deal; take advantage of the savings today!