Artwork for podcast 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)
Episode 164 β€’ 12th June 2025 β€’ Data Career Podcast: Helping You Land a Data Analyst Job FAST β€’ Avery Smith - Data Career Coach
00:00:00 00:32:27

Share Episode

Shownotes

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:

Join the last cohort of 2025!

The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open! To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: βœ… A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong. πŸ‘‰ Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa

https://www.datacareerjumpstart.com/daa

Follow

Links

Chapters

Video

More from YouTube