🐦 Bird Observation Data Project

This project explores bird observation data collected from eBird for a local hotspots, around Philadelphia. Using Python, PostgreSQL, and data visualization tools like Tableau, the project performs ETL (Extract, Transform, Load) operations on CSV files containing bird sighting records.

📌 Objectives

• 🧹 Data Ingestion: Automate the loading of raw .csv files into a PostgreSQL database using pandas and psycopg2.
• 📊 Exploratory Analysis: Investigate trends in species presence, seasonal patterns, and bird counts.
• 📍 Location-Based Insights: Focus on a specific hotspots to observe local biodiversity over time.
• 📈 Visualization: Present key trends and metrics in a public Tableau dashboard.

🛠️ Tools & Technologies

• Python
• Pandas
• psycopg2
• PostgreSQL
• Tableau Public

🔗 Live Dashboard

View Tableau Dashboard

💡 Motivation

As a birding enthusiast and aspiring data engineer, I created this project to combine my interests in nature and data. The goal was to build a small, functional pipeline that brings raw observational data to life through meaningful visuals.

---

Made with 🐦 and 📊 by Raul Bazan