harvard-art-museums-data-engineering-analytics
Explore Harvard Art Museums data in a dashboard.
What it does
Guides creation of a museum-data pipeline that loads collection records into SQL tables and presents them in an interactive dashboard.
When to use it
Use when building a pipeline, querying collection records, or creating an analytics dashboard for Harvard Art Museums data.
How to use it
Ask for a museum-data pipeline and dashboard; it provides project code for extraction, transformation, SQL loading, and interactive analytics.
Uses
What you need · 5
Uses Python for the pipeline and dashboard; no runtime version is specified.
Requires a database endpoint configured through DB_HOST and DB_NAME, with credentials for a MySQL connection.
Access · 2
This skill
MySQL
Loads museum records into MySQL
Harvard Art Museums API
Fetches Harvard museum collection records