Search a title or topic

Over 20 million podcasts, powered by 

Player FM logo
Artwork

Content provided by Avery Smith - Data Career Coach. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Avery Smith - Data Career Coach or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://podcastplayer.com/legal.
Player FM - Podcast App
Go offline with the Player FM app!

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

33:43
 
Share
 

Manage episode 491904787 series 3674951
Content provided by Avery Smith - Data Career Coach. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Avery Smith - Data Career Coach or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://podcastplayer.com/legal.

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:

July Cohort of DAA

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

https://www.datacareerjumpstart.com/daa

๐Ÿ’™ Thank you for subscribing

YouTube Channel

  continue reading

168 episodes

Artwork
iconShare
 
Manage episode 491904787 series 3674951
Content provided by Avery Smith - Data Career Coach. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Avery Smith - Data Career Coach or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://podcastplayer.com/legal.

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:

July Cohort of DAA

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

https://www.datacareerjumpstart.com/daa

๐Ÿ’™ Thank you for subscribing

YouTube Channel

  continue reading

168 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Copyright 2025 | Privacy Policy | Terms of Service | | Copyright
Listen to this show while you explore
Play