{"repo":"JensBender/youtube-channel-analytics","free":true,"listed":false,"github":"https://github.com/JensBender/youtube-channel-analytics","clone":"git clone https://github.com/JensBender/youtube-channel-analytics.git","description":"📊 ETL pipeline for YouTube competitor analytics. Orchestrated with Airflow, Docker, and AWS. Features sentiment analysis and a Power BI dashboard.","language":"Jupyter Notebook","stars":16,"topics":["aws","data-engineering","data-visualization","docker","etl-pipeline","power-bi","python","youtube-api","huggingface","mysql"],"license":"MIT","category":"data-pipelines","readme_excerpt":"Implemented an ETL pipeline for YouTube channel analytics using the YouTube API, enriched with sentiment analysis via Hugging Face. Orchestrated workflows with Airflow and Docker on AWS, storing data in MySQL. Visualized key metrics and comparative insights in an interactive Power BI dashboard. --- 📋 Table of Contents Summary Built With Motivation ETL Pipeline Data Visualization Getting Started Prerequisites Set Up AWS Connect to EC2 and Set Up SSH Tunnel Set Up YouTube API Set Up Hugging Face Manage Environment Variables Set Up Docker and Apache Airflow on EC2 Set Up Power BI Additional Tips License Credits 🎯 Summary To empower YouTube content creators and marketers with actionable insights into their channel's performance, especially in comparison to related channels, I developed a comprehensive ETL pipeline and designed an interactive Power BI report . This project involved: - Data Extraction : Utilized the YouTube API to gather extensive data from three selected channels, including videos and comments. - Data Transformation : Performed sentiment analysis on video comments via API requests to a RoBERTa sentiment analysis model, which I deployed using Gradio on a private Hugging Face Space. - Data Loading : Stored the transformed data in a MySQL database hosted on AWS. - Automation : Managed the ETL workflow using Apache Airflow, Docker, and AWS. - Data Visualization : Designed an interactive Power BI report to deliver insights into channel performance, featuring key metr","default_branch":null,"files":null,"tree":[],"storefront":"/r/JensBender","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/JensBender/youtube-channel-analytics/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}