Joshua Lopez

JOSHUA LOPEZ

Welcome to my portfolio site, where you can explore my data-related projects.

NOAA Fishing Survey Data Project

This project demonstrates an ETL pipeline that processes NOAA's fishing survey data, then makes it available for analysis through an interactive dashboard.

Links:

Web App GitHub Repo

Tools:

Python SQL dbt DuckDB Prefect Streamlit Docker Git Bash

Concepts:

ETL Pipeline Orchestration Data Warehouse Data Visualization Web Application Version Control Data Analysis

YouTube Fishing Videos Data Analysis

This project ingests YouTube video data related to fishing, stores it in MongoDB, and provides visualizations through Metabase for analysis.

Links:

Dashboard GitHub Repo

Tools:

Python YouTube Data API MongoDB Metabase Docker Git

Concepts:

Data Ingestion API NoSQL JSON Business Intelligence Reporting Dashboarding Data Visualization Data Analytics Version Control Containerization

NJ Beach Cam Object Detection Notifier

This project performs object detection using YOLOv8 model on a live stream of a NJ beach. Notifications via Twilio are sent when there are increased levels of fishing activity.

Links:

Web App GitHub Repo

Tools:

Python OpenCV YOLOv8 Twilio API Docker Git Bash

Concepts:

Data Processing Computer Vision Object Detection Deep Learning Convolutional Neural Networks (CNN) Web Application Version Control Containerization