Harvard Artifacts Collection Data Engineering Analytics App

Skill by

ara.so

— Data Skills collection.

An end-to-end data engineering and analytics application that demonstrates real-world ETL pipelines using the Harvard Art Museums API. This project extracts artifact data, transforms it into relational structures, loads it into MySQL/TiDB, and provides interactive SQL-based analytics dashboards through Streamlit.

What This Project Does

API Integration

Fetches artifact data from Harvard Art Museums API with pagination and rate limiting

ETL Pipeline

Transforms nested JSON into normalized relational tables (metadata, media, colors)

Database Management

Stores structured data in MySQL with proper foreign key relationships

SQL Analytics

Provides 20+ predefined analytical queries for insights

Visualization

Interactive Plotly charts rendered in Streamlit dashboards Installation Show more Installs 561 Repository aradotso/data-skills GitHub Stars 1 First Seen May 23, 2026 Security Audits Gen Agent Trust Hub Pass Socket Pass Snyk Pass