harvard-artifacts-collection-data-engineering-analytics
Turn museum collection records into interactive analytics.
What it does
Builds a museum-data ETL and analytics application that collects Harvard Art Museums records, stores them in relational tables, and presents interactive dashboards.
When to use it
Use when building museum-data ETL pipelines, collecting Harvard Art Museums API data, or creating SQL analytics and Streamlit visualizations.
How to use it
Ask for a museum-data analytics application; it provides project code for API extraction, relational storage, SQL analysis, and interactive dashboards.
Uses
Good to know
- cannot be undone: MySQL
What you need · 11
Requires Python to run the ETL and application code; no runtime version is specified.
Requires an accessible MySQL database server configured through DB_HOST, DB_PORT, DB_USER, and DB_PASSWORD.
Access · 4
This skill
MySQL
Loads records into MySQL (irreversible)
Harvard Art Museums API
Fetches museum collection records