Harvard Art Museum ETL Analytics

Skill by ara.so — Data Skills collection.

Overview

This project is an end-to-end data engineering and analytics application that demonstrates how to:

• Extract artifact data from the Harvard Art Museums API
• Transform nested JSON into relational database structures
• Load data into MySQL/TiDB Cloud databases
• Run analytical SQL queries on art collection data
• Visualize insights using Streamlit and Plotly

The architecture follows: API → ETL → SQL → Analytics → Visualization

Installation