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

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:

May Cohort of the Data Analytics Accelerator — Now Open

🔗 datacareerjumpstart.com/daa The May cohort of the Data Analytics Accelerator is officially open for enrollment. This is my comprehensive data analytics bootcamp that takes you from wherever you are to landing your first data job. Doesn't matter your background, your degree, or your experience level — we're going to help you get there. What you get: 📊 Full curriculum covering Excel, SQL, Tableau, Python, and R 🛠️ 9 real-world projects across different industries to build your portfolio 💼 LinkedIn, resume, and interview prep so you actually stand out to recruiters 🤝 Weekly office hours, coaching, and a community of 900+ aspiring analysts who are in it with you 🎓 Lifetime access — go at your pace, come back anytime May enrollment deal: 🔥 20% off when you enroll now 🎁 6 free months of my unreleased Data Portfolio Builder tool — this isn't publicly available yet, and every May cohort member gets early access The live kickoff call is with yours truly on Monday, May 11th at 7:00 PM Eastern. Make sure you're enrolled before then so you don't miss it. 👉 datacareerjumpstart.com/daa Or just click the link in the show notes down below. See you on May 11th.

https://datacareerjumpstart.com/daa