logo
episode-header-image
Jan 2024
32m 27s

93: I want to be a Data Analyst, but don...

Avery Smith - Data Career Coach
About this episode

In this episode of the Data Career Podcast, we include a variety of listener questions, shedding light on topics like the future of data engineering, requirements for becoming a data analyst, showcasing data cleaning proficiency in Excel, and securing data analyst internships.

Also discusses the significance of storytelling and views on Power BI versus Tableau & the impact of AI on data analysis roles.

Tune in now!


👍 Leave your review and download the bonus!


🤝 Ace your data analyst interview with the interview simulator

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp


Timestamps:

(02:10) - What’s the future of data engineering in 2024? (03:06) - Do you need a degree to become a data analyst? (04:57) - How to showcase Excel skills? (07:22) - How to land data analyst internships? (10:10) - What are the main technical skills required to land your first data job? (14:40) - Have you worked with many teachers looking to make a career transition? (16:24) - How to get a data analyst job for people with no work experience? (25:13) - Can you suggest SQL and Excel videos for data analysis? (28:46) - Do you think the data analysis industry is saturated? (28:21) - Do you find data analysts transferring to becoming a data scientist or a data engineer?


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Up next
Nov 18
186: I analyzed 6,512 data analytics jobs – here’s where you’re most likely to get hired
<p>Help us become the #1 Data Podcast by leaving a rating &amp; review! We are 67 reviews away! </p><p>I wouldn't try to become a data analyst next here. Here's 4 reasons why and what I'd do instead. </p><p>💌 Join 30k+ aspiring data analysts &amp; get my tips in your inbox weekl ... Show More
12m 15s
Nov 11
185: How I Would Become a Data Analyst in 2026 (if I had to start over again)
<p>🏆 Follow this roadmap w/ The Data Analytics Accelerator (My Bootcamp): <a href="https://www.youtube.com/redirect?event=video_description&amp;redir_token=QUFFLUhqa2Y3RlBlajFSUy1mcmVYQmpvZUFaeVphWnRtd3xBQ3Jtc0tuRk1wVy1rY25wMWNPWl9CaDJiT05EUWlyNnpydC1vbG00cEktZUdndmlqLVJQSWhIX0R ... Show More
25m 34s
Nov 4
184: What I’d Learn Instead of Data Science in 2026
<p>Help us become the #1 Data Podcast by leaving a rating &amp; review! We are 67 reviews away! </p><p>I wouldn't try to become a data analyst next here. Here's 4 reasons why and what I'd do instead. </p><p>👩‍💻 Want to land a data job in less than 90 days? 👉 <a href="https://w ... Show More
15m 27s
Recommended Episodes
May 2022
Episode 121 - The Role of a Legal Data Analyst
Data, data, data – it’s everywhere! It helps us run our legal practices and it’s an integral part of every one of our legal matters too but, do we understand how, why, when, where and what data to use? Legal data analysts do!  In this podcast, Terri Mottershead, Executive Directo ... Show More
59m 58s
Jun 2023
Welcome to the Data Driven Podcast -- Benjamin Shapiro // I Hear Everything
Welcome to the Data Driven Podcast, where we dive deep into the art and science of data storytelling. Our mission is to help professionals from all backgrounds develop the skills needed to transform complex data into compelling narratives that drive clear business direction and r ... Show More
15m 9s
Apr 2022
Models & Data To Grow Your Consulting Business With Stéphane Hamel: Pocast #233
<p class="ql-align-justify">Data analysis and models are very important to understand your business better. When you have a clear mastery and vision of it, you will be better in marketing, resulting in more customers and bigger revenue. In today’s episode, <a href="https://www.st ... Show More
37m 28s
Mar 2023
Marijn Markus - Managing Data Scientist at Capgemini #29
Our guest today is Marijn Markus, Managing Data Scientist at Capgemini. In our conversation, we first talk about data analysis to model and visualise the spread of Ebola. We then dig into crime analysis back to when Marijn worked with the police in the Netherlands. Marijn also sh ... Show More
1h 1m
Mar 2023
Auren Hoffman - A Deep Dive on Data - [Invest Like the Best, EP.320]
My guest this week is Auren Hoffman. Auren is the CEO of Safegraph, which curates data on physical locations. He also founded LiveRamp, a public data connectivity business. Auren knows more about data businesses than almost anyone I know and that is the topic of today’s discussio ... Show More
1h 10m
Jul 2020
Chris Fernandez, EnsoData - There Was One Particular Area That Felt Like It Was At Least 5 Years Behind…And That Was The Application Of AI To Waveform Data | #239
In episode 239 we welcome our guest, Chris Fernandez, co-founder and CEO of EnsoData. In today’s episode, we’re talking all things sleep. We walk through the origin story of EnsoData, from the founders’ initial idea followed by 12 pivots to arrive at their flagship product, EnsoS ... Show More
53m 11s
Mar 2023
S9E23: How a Biology Major Landed an EY-Parthenon Summer Internship
<p><a target="_blank" href="https://www.buzzsprout.com/twilio/text_messages/1002655/open_sms">Send us a text</a></p><p>We&apos;re excited to bring you today&apos;s episode where Eric Lu shares insights from his journey into consulting. <br/><br/>A Duke University Biology major, E ... Show More
25m 50s
Mar 2023
S9E25: 4 Ideas to Fill Career Gaps In Your Resume
<p><a target="_blank" href="https://www.buzzsprout.com/twilio/text_messages/1002655/open_sms">Send us a text</a></p><p>Struggling to gain traction in your consulting job hunt due to career gaps on your resume? Listen in.<br/><br/>Today, we&apos;re sharing 4 ideas to help you fill ... Show More
14m 41s