Skip to main content
Data Career Podcast

Data Career Podcast

By Avery Smith - Data Career Coach

The Data Career Podcast: helping you break into data analytics, build your data career, and develop a personal brand
Available on
Apple Podcasts Logo
Castbox Logo
Google Podcasts Logo
iHeartRadio Logo
Pocket Casts Logo
RadioPublic Logo
Spotify Logo
Currently playing episode

23: What is Data Engineering with Andreas Kretz

Data Career PodcastJul 12, 2021

00:00
01:03:18
106: Want to Stand Out as a Data Analyst? Master Data Storytelling w/ Brent Dykes
Apr 16, 202436:41
105: Do You Have to Be Good at Statistics to Be a Data Analyst w/ StatQuest Josh Starmer PhD
Apr 10, 202436:18
104: Breaking into Sports Analytics w/ Ken Jee
Apr 03, 202448:10
103: Conquering Your Fear of Becoming a Data Analyst w/ Erick Cuentas
Mar 27, 202445:45
102: Exposing How Alex The Analyst Became a Data Analyst (And The Most Popular Data YouTuber)
Mar 21, 202431:36
101: Expert Data Analytics Panel Tells All (100th Episode Celebration)

101: Expert Data Analytics Panel Tells All (100th Episode Celebration)

The 100th celebration episode of the Data Career Podcast features a special panel interview conducted by Avery Smith with prominent data content creators, including Ken Jee, Monica Kay Royal, Richad Nieves-Becker, and Elijah Butler.

Recorded in Charleston, South Carolina, this milestone episode dives into personal experiences in the data field, the relationship with AI, favorite data learning resources, and interview tips.

The discussion provides a unique mix of backgrounds, offering perspectives on succeeding in data careers, the impact of AI, and the importance of continuous learning.


Connect with the panels on LinkedIn:

🤝 Connect with Ken Jee

🤝 Connect with Monica Kay Royal

🤝 Connect with Richad Nieves-Becker

🤝 Connect with Elijah Butler


✉️ Discover what we wish we knew about landing the dream job

🤖 Data Analytics Answers At Your Finger Tips

🤝 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:

(06:05) - Diving into the Panel: Introductions and Insights (09:33) - Exploring Favorite Data Tools and Facing AI Threats (16:58) - Learning Resources and Books for Aspiring Data Professionals (23:26) - Interview Tips: From Connection to Confidence


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mar 13, 202427:36
100: Job Hunt OS Launch w/ Asa Howard

100: Job Hunt OS Launch w/ Asa Howard

Unlock the secret to job hunting success with JobHuntShortcut.com – land interviews without drowning in resumes, learn effective networking, and get $70 off today!


Connect with Asa Howard on LinkedIn.

Mar 06, 202422:35
99: Is a Data Analyst Bootcamp REALLY worth it? w/ Melissa Kings
Feb 28, 202437:47
98: Day in the Life of a Data Analyst With Non-Technical Background w/ Paul Ahlstrom

98: Day in the Life of a Data Analyst With Non-Technical Background w/ Paul Ahlstrom

Feb 21, 202445:45
97: Winning with Data Science; A Handbook for Business Leaders w/ Akshay Swaminathan

97: Winning with Data Science; A Handbook for Business Leaders w/ Akshay Swaminathan

In this podcast episode, Avery talks with Akshay Swaminathan, co-author of the book 'Winning with Data Science: A Handbook for Business Leaders.

They discuss the vague terms often thrown around in the data science industry and underline the importance of understanding these terms in order to make effective business decisions.

Swaminathan highlights the need to leverage data science in healthcare and real estate.

The episode covers various aspects of data analysis, including prediction, association, and description.


Connect with Akshay Swaminathan :

🤝 Connect on Linkedin

📘 Learn About Winning with Data Science


✉️ Discover what we wish we knew about landing the dream job

🤖 Data Analytics Answers At Your Finger Tips


🤝 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:

(12:14) - The Value of Data Science in Business (14:57) - The Role of Data Science in Problem Solving (20:36) - Understanding the Difference Between Data Science and Data Analytics (25:39) - The Importance of Framing Business Questions for Data Science (30:48) - The Power of Meeting Business Needs with Data Science: A Real-Life Example (38:26 ) - The Limitations of Data Science


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Feb 14, 202445:32
96: What is Python & Why Should I Care? w/ Python Expert Michael Kennedy
Feb 07, 202449:37
95: Nick Desbarats: How to Create Effective Data Visualization
Jan 31, 202441:08
94: Positive Affirmations for Aspiring Data Analysts [Listen Daily]
Jan 24, 202408:27
93: I want to be a Data Analyst, but don’t have experience

93: I want to be a Data Analyst, but don’t have experience

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

Jan 17, 202430:35
92: What is Linear Programming? (A Glimpse to What I Did as a Data Scientist at ExxonMobil)
Jan 10, 202436:09
91: If I Wanted to Become a Data Analyst In 2024, This is What I'd Do [FULL BLUEPRINT]
Jan 04, 202422:39
90: 2024 New Year Resolutions: 3 Things You Need to Become a Data Analyst
Dec 27, 202319:51
89 The Fastest Way to ACTUALLY Get Hired as a Data Analyst with NO Work Experience
Dec 20, 202347:57
88: How to Work with Recruiters as a Data Analyst ft. Hire-Fit
Dec 13, 202347:07
87: Becoming a Data Analyst with Elijah Butler
Dec 06, 202351:01
86: SQL Simplified: For Data Beginners
Nov 29, 202322:57
85: Landing a Job as an Immigrant w/ Daniel Botero
Nov 22, 202342:43
84: Presenting for Data Analysts w/ Hana M.K.
Nov 15, 202334:33
83: Building Data Analytics Projects w/ Matt Mike
Nov 08, 202343:06
82: Mastering Data Analytics with Excel w/ Matt Brattin
Nov 01, 202341:48
81: Zero to Data Analyst: Tim Beecher’s Journey from Locksmith to Data
Oct 25, 202339:22
80: Become a Data Analyst in 90 Days
Oct 18, 202318:04
79: From Construction to Data Analytics (Jordan Temple's Story)
Oct 11, 202331:09
78: Data Consulting w/ Leon Gordon
Oct 04, 202336:21
77: Data Visualization Tips w/ Tableau Expert Andy Kriebel

77: Data Visualization Tips w/ Tableau Expert Andy Kriebel

Join me with Tableau expert Andy Kriebel about data visualization tips! 📊

Andy shares his expertise to help you level up your data skills, from creating purposeful dashboards to the power of dot maps.

Tune in now and take your data visualizations to the next level! 🎧


Connect with Andy Kriebel:

🤝 Connect on Linkedin

▶️ Subscribe to Youtube Channel

📔 Buy #MakeoverMonday Book

🎒 Learn About The Data School


🤝 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:

(11:15) - When dealing with time series, your best friend is the versatile line chart 📈

(13:34) - Dive into dot maps for super-detailed visualizations 🌍

(17:30) Want to compare rankings over time? Bump chart!📊📈

(21:10) Keep your graphs simple and spiced up with context📉

(26:45) Dashboards should tell a story; ensure they have a purpose and context to keep folks engaged. 📋💡

(34:27) Prepping for an interview? Be chatty, be prepared with your interviewers. 🗣️🤝

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Sep 27, 202338:33
76: How We Use AI as Data Analysts w/ Luke Barousse
Sep 20, 202318:42
75: Want to be a Data Analyst? Learn These Skills w/ Luke Barousse
Sep 13, 202331:39
74: How to Ace The Data Science & Analytics Interview w/ Nick Singh
Sep 06, 202351:49
73: I Have Good News for Aspiring Data Analysts
Aug 30, 202319:14
72: What Is People Analytics? w/ Serena Huang
Aug 23, 202337:58
71: Get Hired as a Data Analyst w/ Hiring Manager Andrew Madson
Aug 16, 202330:47
70: He’s Hired 30 Data Analysts; Here’s What You Should Know
Aug 09, 202341:32
69: Skills, Networking, Portfolio: How Brad Yarbro Landed a Data Job
Aug 02, 202331:23
68: Difference between Data Science and Data Analytics

68: Difference between Data Science and Data Analytics

In this episode of Data Career Podcast, I explore Data Analytics vs Data Science, highlighting key differences and stress the fluidity between data science and analytics.
Don't miss it!

📩 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:
(00:56) - Predictive Analytics: Foreseeing the Future 🔮📈
(01:43) - Diagnostic Analytics: Unraveling "Why" 🕵️‍♂️🔍
(02:10) - Analytics in Book Sales 📚📊
(03:09) - Data Scientists: Masters of Prediction 🧠🎯
(03:56) - Decoding Data Analytics vs. Data Science 🗝️💻
(05:26) - Gateway to Success: Landing a Data Job 🚪💼

Connect with Avery:
📺 Subscribe on YouTube
🎙Listen to My Podcast
👔 Connect with me on LinkedIn
📸 Instagram
🎵 TikTok
Jul 26, 202306:01
67: Hiring Manager’s Secrets to Getting The Job as a Data Analyst w Megan McGuire

67: Hiring Manager’s Secrets to Getting The Job as a Data Analyst w Megan McGuire

🕵️‍♂️ Curious about the mysterious hiring process of a data career? Find out how Megan McGuire narrows down candidates and assesses skills in the podcast. Get insider knowledge on code assessments, interviews, and what it takes to land the dream data role! 💪📈


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

🏫 Check out my 10-week data analytics bootcamp


Timestamps:

(02:14) - The Value of Junior Analysts

(12:12) - Curiosity and Problem Solving in Data Analytics

(21:46) - Be the perfect candidate for specific company rather than a pretty good candidate

(24:15) - How drive, experience and upskilling set up interviewee success

(28:59) - Show off your skills with your Tableau Public or GitHub Profile

(36:53) - Rejections aren't necessarily your fault


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Jul 19, 202339:47
66: The Naked Truth about Data Careers w/ Data Manager Marijn Markus

66: The Naked Truth about Data Careers w/ Data Manager Marijn Markus

In this episode, Marijn Markus & I talked about what it is ACTUALLY like being in the data field, how he transitioned from social science to data science, & discuss some real-world data use cases.

Marijn also shared his experience managing data teams, what makes a good junior hire, why you might not need machine learning, & much, much more.

You don’t want to miss this episode!


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

🏫 Check out my 10-week data analytics bootcamp


Connect with Marijn: https://www.linkedin.com/in/marijnmarkus/


Timestamps:

(4:40) - Diverse backgrounds matter for programming and stats! (17:42) - Model explanations matter for business (21:00)- The real reason why generative AI became big in December (25:24) - Focus on what you know, not what you don't know (30:14) - You can't control the interview session? Think again!

Jul 12, 202347:13
65: From Music Sheet to Spreadsheets: Erin Shina’s 90-Day Transformation from Music to Financial Data Analyst

65: From Music Sheet to Spreadsheets: Erin Shina’s 90-Day Transformation from Music to Financial Data Analyst

Join us as we interview my bootcamp student Erin Shina who recently pivoted her career from music therapy to a financial analyst role at Fortune 50 company Humana.

🏫 Check out my 10-week data analytics bootcamp

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


Timestamps:

(2:49) - Hybrid work is the new norm, combining office and remote setups. 💼🏠

(6:00) - A supportive boss is crucial in advancing your data career. 👩‍💼🚀

(9:00) - Music therapy offers a fulfilling career path in healthcare. 🎵⚕️

(10:11) - Discover how the Data Analytics Accelerator helped Erin secure a data job. 📊🔍

(14:16) - Showcase your project effectively to increase your interview chances. 📂🎯

(17:25) - Put extra effort into crafting an impactful resume. 📄💪

(21:41) - Your current network could become a valuable referral for your next job opportunity. 🌐🔗


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Jul 05, 202332:04
64: Data Portfolios, Data Analyst Interviews, and Data Storytelling: Ask Me Anything
Jun 28, 202328:13
63: I’ve Taught 1,028 People Data Analytics (here’s what I’ve Learned)

63: I’ve Taught 1,028 People Data Analytics (here’s what I’ve Learned)

Over the past 5 years, I’ve taught 1000’s about data analytics.

What have I learned as a teacher?

Where have I seen the most success?

What’s the biggest secret to people who succeed?

In this episode, I’ll share it all :)


🏫 Check out my 10-week data analytics bootcamp

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


Timestamps:

(3:30) Journey: Teaching data analytics full-time for the past year and a half. 📊

(8:58) Lesson: Skills alone aren't enough to land data jobs. 🎓

(13:06) Focus: Guiding students to low-barrier, rewarding data positions. 🔍

(18:25) Success: Marketing, portfolio, and networking are crucial for data job seekers. 🌟


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Jun 20, 202322:01
62: Unleash Your Data Superpowers with Dummy Projects

62: Unleash Your Data Superpowers with Dummy Projects

Unravel the secret sauce behind starting with dummy projects and paving your way to extraordinary success.

Come and join Avery answered Muhammad’s question on how to get create good data portfolio, and how dummy projects are helpful for upskilling.


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

🏫 Check out my 10-week data analytics bootcamp


Timestamps:

(5:06) - Stepping stone: Dummy projects lead to advancement. 💡

(6:20) - Explore: Find intriguing online project ideas. 🌐

(6:45) - Learn: Embrace initial challenges for growth. ⚽

(7:20) - Mindset: Start, improve, conquer data projects. 🚀

(8:00) - Resources: YouTube, webinars, podcast - career boost.


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Jun 14, 202308:57
61: Inside My Data Bootcamp: A Sneak-Peak of the Data Analytics Accelerator [Members Only]

61: Inside My Data Bootcamp: A Sneak-Peak of the Data Analytics Accelerator [Members Only]

🎙️ Get ready for an exclusive, behind-the-scenes episode! 🚀


Dive into our members-only content, where you'll learn and gain invaluable insights on the expectations, workings, and fantastic resources of our data career bootcamp.


Take advantage of this incredible opportunity!


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

🏫 Check out my 10-week data analytics bootcamp


Timestamps:

(3:28) - 🏗️ Laying the Foundation: Build your data career from scratch!

(4:54) - 🤝 Community Support: Join a like-minded community to land data jobs!

(7:10) - 🎯 Learn and Upskill: Master data at your own pace!

(9:20) - 🙌 Stay Accountable: Achieve your data goals with our support!

(10:57) - ❤️ Love Data Work: Experience the thrill of working with data!

(11:52) - 🌍 Make an Impact: Change the world with the power of data!

(12:33) - 💰 Lucrative Careers: Earn big with your data skills!

(12:46) - ⏰ Flexible Work: Work on your terms!

(16:28) - 🎮 Project Power: Boost your skills with hands-on projects!

(21:57) - 🤝 Network for Success: Unlock data job opportunities through networking!


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Jun 10, 202329:13
60: Underrated or Overrated with Shashank Kalanithi - AI, Power BI, Cold Messaging & More!
May 31, 202305:56
59: Will AI Replace Data Analysts?

59: Will AI Replace Data Analysts?

Will AI replace data analyst? Is it going to happen? Has it already happened?

In this episode, I wanted to dig into if I actually think that's going to be the case.


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

🏫 Check out my 10-week data analytics bootcamp


Timestamps:

(01:00) - Brace yourself: AI has ARRIVED! 🤖

(01:44) - Is your data analyst job in jeopardy? AI vs. Human Skills 💼

(02:54) - The art of data analysis using AI 🚀

(03:29) - AI is just a tool 🧮

(04:01) - AI is just like Google 🔓

(05:55) - Job Security? Get good at AI 🌟

(07:18) - Humans make decisions ✨

(08:00) - Join the Ultimate Data Bootcamp! 📚💪


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

May 24, 202308:23
58: The Easiest Place To Land Your First Data Job

58: The Easiest Place To Land Your First Data Job

Your dream data job might be closer than you realize.
Don't overlook the hidden gem right in front of you: internal positions.
Landing an internal job is easier than going through the external route.

🌟 Join the data project club!
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp

Timestamps:
(0:00) - The Best Place to Land Your First Job
(2:58) - How I Landed My First Data Job
(7:11) - Your Company Has a Data Team?
(10:22) - Network Inside Your Company
(12:54) - Use data at your current position
(14:01) - Attend Data Events

Connect with Avery:
📺 Subscribe on YouTube
🎙Listen to My Podcast
👔 Connect with me on LinkedIn
📸 Instagram
🎵 TikTok
May 17, 202317:12
57: Want to Become a Data Analyst? Start here.

57: Want to Become a Data Analyst? Start here.

Wanna become a data analyst? Start here.
This is the most upvoted post in the r/datanalysis history, full of advice and a roadmap to becoming a data analyst.
Join me as I'm going to be diving into what their advice was and if I agree or disagree with it.

🌟 Join the data project club!
“25OFF” to get 25% off (first 50 members).

📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp

Timestamps:
(0:52) - Do I need a degree?
(1:34) - Is Google Data Analytics Cert enough?
(3:39) - Will my degree help me?
(5:54) - What do I need to learn?
(8:07) - Do certifications matter?
(9:01) - Can I get a job right away?
(10:36) - Is having a degree is enough?
(11:41) - Build a strong foundation
(11:58) - Get hands-on experience
(12:21) - Build your network
(12:40) - Should You Get a CS Degree?
(13:09) - Should I learn Machine Learning
(13:54) - Build a portfolio
(14:31) - Create a personalized resume
(14:51) - Practice every day
(14:59) - Have the right attitude
(15:20) - Applying for the jobs
(16:13) - Be very patient

Connect with Avery:
📺 Subscribe on YouTube
🎙Listen to My Podcast
👔 Connect with me on LinkedIn
📸 Instagram
🎵 TikTok
May 10, 202318:29