Harvard Artifacts ETL & Analytics Skill

Skill by ara.so — Data Skills collection.

This skill enables AI agents to build and work with end-to-end data engineering pipelines using the Harvard Art Museums API. It demonstrates ETL workflows, SQL database design, analytics queries, and interactive Streamlit dashboards with Plotly visualizations.

What This Project Does

The Harvard Artifacts Collection Data Engineering & Analytics App provides:

• API Integration: Fetch artifact data from Harvard Art Museums API with pagination and rate limiting
• ETL Pipeline: Extract, transform, and load museum artifact data into relational SQL databases
• SQL Database: Store artifacts metadata, media details, and color information with proper relationships
• Analytics Queries: 20+ predefined SQL queries for insights on culture, century, media, colors, and departments
• Interactive Dashboard: Streamlit-based UI with Plotly visualizations for real-time analytics

Installation