harvard-artifacts-collection-analytics-etl
Explore Harvard's art collection in a dashboard.
What it does
Creates a museum-data pipeline and interactive dashboard that turn Harvard Art Museums records into SQL-backed collection analytics.
When to use it
Use when building a Harvard Art Museums data pipeline, SQL analytics, or an interactive collection dashboard.
How to use it
Give it a request for museum collection analytics; it builds an extraction, transformation, SQL storage, and dashboard project.
Uses
Good to know
- cannot be undone: MySQL
What you need · 5
Requires Python to run the pipeline and dashboard; no runtime version is specified.
Requires an accessible SQL database for the MySQL connector, with database credentials and an existing database.
Access · 4
This skill
MySQL
Loads museum records into MySQL (irreversible)
Harvard Art Museums API
Fetches Harvard museum collection records