logo
episode-header-image
Jan 2024
33m 3s

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

Mentioned in this episode:

💙 Thank you for subscribing & leaving a review

Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

Join The Next Cohort of The Accelerator

Want to land your first data job? Join my data bootcamp to get EVERYTHING you need to land your first data job! Excel, SQL, Tableau, Power BI, Python, R? Yup. Projects? Lots of them. LinkedIn help? Of course. Resume optimization? You betcha. Job hunting strategy? Duh. Click to learn more!

https://www.datacareerjumpstart.com/daa

Up next
Yesterday
173: 13 Signs You’re on the Right Track to Landing Your First Data Job
Feeling behind on your data journey? Don't worry. Today, I'll list down the 13 signs that prove you're actually ahead (even if you're actually doing just some of these).✨ Try Julius today at https://landadatajob.com/Julius-YT💌 Join 10k+ aspiring data analysts & get my tips in yo ... Show More
15m 33s
Aug 12
172: Tesla Data Analyst: This is how to land a data job (Lily BL)
What does it take to land a data analyst job at Tesla, and what challenges await you once you're there? Join me as I interview Lily BL, a former Tesla data analyst, who reveals her exhilarating journey in the world of data at one of the world's most innovative companies.💌 Join 1 ... Show More
34m 15s
Aug 5
171: 7 Habits That (Quietly) Helped Me Break Into Data (with no experience)
7 essential habits helped me transition into data analytics (even without prior experience), and I'm sharing them in today's episode.If you're transitioning into data analytics, I've also created a free tool to help you monitor and track your progress. FREE 7 Habits Tracker here: ... Show More
14m 38s
Recommended Episodes
Aug 2022
Switching Your Career into Business Analysis
Have you thought about moving into a business analysis career but are concerned you might not have the right skills? Many business analysis professionals started their careers in a different field altogether. (Hint: you don't need a computer science background to get into busines ... Show More
37m 25s
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
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, Stephane Hamel discusses how you can leverage data ... Show More
38m 8s
May 2024
How To Do Business Analysis
Is there just one way to do business analysis? Is there a right way? How do we bring together all these techniques and tasks to achieve the right outcomes? Susan and Scott chat with Howard Podeswa about how to do business analysis work. Howard is an author of three books for busi ... Show More
55m 3s
Nov 2022
Top 7 Soft Skills for Business Analysts
In IIBA's most recent Global State of Business Analysis survey, the business analysis community told us that there are 7 soft skills critical to the work of BA professionals. Some say "soft skills," well, we say "essential skills!" These skills not only make your work stand out a ... Show More
37m 20s
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