Data Career Podcast: Helping You Land a Data Analyst Job FAST

164: I built an entire data pipeline in 30 minutes using only AI (no code required)


Listen Later

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:

โšก๏ธDiscover top data analyst roles from leading companies

FindADataJob.com is a great place to look for data jobs at any point in your data journey, so check it out. โ€ŠI built it so you can skip the spam and see legit, curated data jobs. Updated daily. No login, no paywall. Just real jobs for real job seekers who are trying to get hired.

โšก๏ธDiscover top data analyst roles from leading companies

...more
View all episodesView all episodes
Download on the App Store

Data Career Podcast: Helping You Land a Data Analyst Job FASTBy Avery Smith - Data Career Coach

  • 4.9
  • 4.9
  • 4.9
  • 4.9
  • 4.9

4.9

146 ratings


More shows like Data Career Podcast: Helping You Land a Data Analyst Job FAST

View all
Data Skeptic by Kyle Polich

Data Skeptic

480 Listeners

Talk Python To Me by Michael Kennedy

Talk Python To Me

590 Listeners

Find Your Dream Job: Insider Tips for Finding Work, Advancing your Career, and Loving Your Job by Mac Prichard

Find Your Dream Job: Insider Tips for Finding Work, Advancing your Career, and Loving Your Job

613 Listeners

Super Data Science: ML & AI Podcast with Jon Krohn by Jon Krohn

Super Data Science: ML & AI Podcast with Jon Krohn

298 Listeners

Python Bytes by Michael Kennedy and Brian Okken

Python Bytes

215 Listeners

Masters of Scale by WaitWhat

Masters of Scale

3,995 Listeners

DataFramed by DataCamp

DataFramed

267 Listeners

Practical AI by Practical AI LLC

Practical AI

192 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

62 Listeners

How to Get an Analytics Job by John David Ariansen

How to Get an Analytics Job

31 Listeners

Think Fast Talk Smart: Communication Techniques by Matt Abrahams, Think Fast Talk Smart

Think Fast Talk Smart: Communication Techniques

794 Listeners

The Real Python Podcast by Real Python

The Real Python Podcast

139 Listeners

Everything Data Analytics by Cubeware

Everything Data Analytics

3 Listeners

Huberman Lab by Scicomm Media

Huberman Lab

28,304 Listeners

Get Hired with Andrew Seaman by LinkedIn

Get Hired with Andrew Seaman

142 Listeners