Try Keboola 👉 https://www.keboola.com/mcp?utm_campaign=FY25_Q2_RoW_Marketing_Events_Webinar_Keboola_MCP_Server_Launch_June&utm_source=Youtube&utm_medium=Avery

Today, we'll create an entire data pipeline from scratch without writing a single line of code! Using Keboola MCP server and ClaudeAI, we’ll extract data from my FindADataJob.com RSS feed, transform it, load it into Google BigQuery, and visualize it with Streamlit. This is the future of data engineering!

Keboola MCP Integration:

https://mcp.connection.us-east4.gcp.keboola.com/sse

I Analyzed Data Analyst Jobs to Find Out What Skills You ACTUALLY Need

https://www.youtube.com/watch?v=lo3VU1srV1E&t=212s

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator

⌚ TIMESTAMPS

00:00 - Introduction

00:54 - Definition of Basic Data Engineering Terms

02:26 - Keboola MCP and Its Capabilities

07:48 - Extracting Data from RSS Feed

12:43 - Transforming and Cleaning the Data

19:19 - Aggregating and Analyzing Data

23:19 - Scheduling and Automating the Pipeline

25:04 - Visualizing Data with Streamlit

🔗 CONNECT WITH AVERY

🎥 YouTube Channel: https://www.youtube.com/@averysmith

🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://instagram.com/datacareerjumpstart

🎵 TikTok: https://www.tiktok.com/@verydata

💻 Website: https://www.datacareerjumpstart.com/

Mentioned in this episode:

🌞 Summer Cohort of DAA

Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class!

https://www.datacareerjumpstart.com/daa

💙 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.

Try Julius.ai 👉 https://bit.ly/4jn4cFF

Coupon code: AVERY25

AI is transforming how we work, how we make decisions, and how we understand the world through data. In this episode, I explore how Julius AI can simplify your data tasks, automate repetitive work, and offer valuable insights in MINUTES. Dive into the future of data analysis and get ready to 10x your productivity!

Get my weekly newsletters (free): https://www.datacareerjumpstart.com/newsletter

Learn more about my CRM Course Creator 360:

https://coursecreatorpro.com/registeremailaffiliate?am_id=avery8756

How This Delivery Driver Became a FAANG Data Analyst (Jen Hawkins)

https://youtu.be/f-BWp_IJZ-I?si=2_tKqHEng_EYNRCB

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator

⌚ TIMESTAMPS

00:00 - Introduction

01:55 - My CRM Data Analysis

02:23 Exploring and Cleaning Data with Julius AI

06:15 Email Analysis and Insights

13:39 Sales Cycle Length Analysis

15:27 The Power of AI in Data Analysis

🔗 CONNECT WITH MY TOP NEWSLETTER ENGAGERS!

Isaac Oresanya: https://www.linkedin.com/in/isaac-oresanya/

Jen Hawkins: https://www.linkedin.com/in/jeandriska/

David Mills: https://www.linkedin.com/in/david-mills/

Mukta Pandey: https://www.linkedin.com/in/mukta-pandey-30a89b243/

🔗 CONNECT WITH AVERY

🎥 YouTube Channel: https://www.youtube.com/@averysmith

🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://instagram.com/datacareerjumpstart

🎵 TikTok: https://www.tiktok.com/@verydata

💻 Website: https://www.datacareerjumpstart.com/

Mentioned in this episode:

🌞 Summer Cohort of DAA

Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class!

https://www.datacareerjumpstart.com/daa

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

Break into data analytics EVEN without a degree, just like our guest for today's episode! He's Ryan Ponder, a Data Analytics Accelerator program student who transitioned from Loan Officer to Data Analyst within his company-- without a degree. He shares how he leveraged internal opportunities and attained his new role. Tune in and learn actionable steps for making an internal pivot and overcoming career challenges!

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator

⌚ TIMESTAMPS

00:00 - Introduction

05:49 - The Internal Pivot: A Unique Pathway to Data Analytics

09:57 - Networking and Overcoming Challenges

15:47 - Imposter Syndrome

23:02 - Final Thoughts and Advice

🔗 CONNECT WITH RYAN

🤝 LinkedIn: https://www.linkedin.com/in/rtponder/

🔗 CONNECT WITH AVERY

🎥 YouTube Channel: https://www.youtube.com/@averysmith

🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://instagram.com/datacareerjumpstart

🎵 TikTok: https://www.tiktok.com/@verydata

💻 Website: https://www.datacareerjumpstart.com/

Mentioned in this episode:

🌞 Summer Cohort of DAA

Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class!

https://www.datacareerjumpstart.com/daa

💙 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.

Struggling to break into data analyst roles because you have no experience? In this episode, I reveal 6 overlooked, easier-to-land entry-level data jobs that can kickstart your data career. I also provide 7 reasons why these roles are worth considering!

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator

⌚ TIMESTAMPS

00:00 - Introduction

01:43 - Six overlooked data jobs

02:09 - Reason 1: Domain-focused

03:18 - Reason 2: Easier to qualify for

04:26 - Reason 3: Less competition

05:34 - Reason 4: Still provide real data experience

06:42 - Reason 5: Often remote or hybrid

07:49 - Reason 6: Internal pivot

09:03 - Reason 7: Decent pay

🔗 CONNECT WITH AVERY

🎥 YouTube Channel: https://www.youtube.com/@averysmith

🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://instagram.com/datacareerjumpstart

🎵 TikTok: https://www.tiktok.com/@verydata

💻 Website: https://www.datacareerjumpstart.com/

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.

🌞 Summer Cohort of DAA

Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class!

https://www.datacareerjumpstart.com/daa

Melody Santos has successfully transitioned from a physical therapist to a revenue analyst in a few months! In this episode, she shares three main steps that expedited her journey, her struggles with imposter syndrome, and offers valuable advice for anyone looking to pivot into a data career.

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator

⌚ TIMESTAMPS

00:00 - Introduction

04:16 - Melody's Google Data Analytics Certificate Experience

06:41 - Job Application Challenges

15:43 - Landing the Charge Integrity Analyst Job

23:16 - Advice for Career Changers

🔗 CONNECT WITH MELODY

🤝 LinkedIn: https://www.linkedin.com/in/melodyusantos/

🔗 CONNECT WITH AVERY

🎥 YouTube Channel: https://www.youtube.com/@averysmith

🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://instagram.com/datacareerjumpstart

🎵 TikTok: https://www.tiktok.com/@verydata

💻 Website: https://www.datacareerjumpstart.com/

Mentioned in this episode:

🌞 Summer Cohort of DAA

Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class!

https://www.datacareerjumpstart.com/daa

💙 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.

If you're thinking about doing the Google Data Analytics Certificate, you need to hear this: DON'T. In this episode, I list five reasons why it is a waste of time.

The ONLY Framework to Become a Data Analyst in 2025 (SPN Method): https://youtu.be/XUxWQgh3soo?si=v3SQV3zJ4h0jH1uQ

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator

⌚ TIMESTAMPS

00:00 - Introduction

00:11 - Reason 1: Certificates Don't Matter in the Data Industry

02:45 - Reason 2: The Course Teaches the Wrong Skills

06:32 - Reason 3: The Course is Slow and Theoretical

09:21 - Reason 4: Lack of Projects and Portfolios

14:15 - Reason 5: No Career or Networking Support

🔗 CONNECT WITH AVERY

🎥 YouTube Channel: https://www.youtube.com/@averysmith

🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://instagram.com/datacareerjumpstart

🎵 TikTok: https://www.tiktok.com/@verydata

💻 Website: https://www.datacareerjumpstart.com/

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.

🌞 Summer Cohort of DAA

Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class!

https://www.datacareerjumpstart.com/daa

🎯 I analyzed 2,893 data analyst job postings so you don’t have to, and here’s what I found: **You might be wasting your time learning the wrong skills.** Find out how to pivot your career the data-driven way and stay ahead of the game.

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator

⌚ TIMESTAMPS

02:28 - FindADataJob.com.

04:04 - Most In-demand skills in 2025.

06:22 - Live Data at DataAnalystSkills.com

🔗 CONNECT WITH AVERY

🎥 YouTube Channel: https://www.youtube.com/@averysmith

🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://instagram.com/datacareerjumpstart

🎵 TikTok: https://www.tiktok.com/@verydata

💻 Website: https://www.datacareerjumpstart.com/

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.

🌞 Summer Cohort of DAA

Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class!

https://www.datacareerjumpstart.com/daa

Megan Bowers took an unconventional path to break into the data world. Starting from a self-guided Data Science Bootcamp, she shared her journey through blogging and gained millions of views, and then BOOM! Job offers and monetization opportunities flooded. This is her story.

📌 Interested in blogging for my publication? Get on this interest list: https://tally.so/r/3l4xQW

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator

⌚ TIMESTAMPS

00:00 - Introduction

03:28 - Gaining traction and recognition through blogging.

07:08 - Career Growth and transition to Alteryx.

14:18 -  Leveraging and advertising your domain expertise.

19:25 - What is a Data Journalist?

22:21 - Writing content.

24:29 - What is Alteryx?

🔗 CONNECT WITH MEGAN

🎥 YouTube Podcast Channel: https://www.youtube.com/playlist?list=PLfSLx4WE4q501UZjL3Hx-DiS4zyeePEN2

🤝 LinkedIn: https://www.linkedin.com/in/megandibble1/

📸 Instagram: https://www.instagram.com/alteryx/

💻 Alteryx Website: https://www.alteryx.com/

🔗 CONNECT WITH AVERY

🎥 YouTube Channel: https://www.youtube.com/@averysmith

🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://instagram.com/datacareerjumpstart

🎵 TikTok: https://www.tiktok.com/@verydata

💻 Website: https://www.datacareerjumpstart.com/

Mentioned in this episode:

🌞 Summer Cohort of DAA

Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class!

https://www.datacareerjumpstart.com/daa

💙 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.