Harvard Art Museums ETL Analytics Skill

Skill by ara.so — Data Skills collection.

This skill provides expertise in building end-to-end data engineering and analytics applications using the Harvard Art Museums API. The project demonstrates real-world ETL pipelines, SQL database design, analytical queries, and interactive visualization using Streamlit.

What This Project Does

The Harvard-Artifacts-Collection-Data-Engineering-Analytics-App enables:

• API Integration: Collect artifact data from Harvard Art Museums API with pagination and rate limiting
• ETL Pipeline: Extract, transform, and load nested JSON into relational SQL tables
• Database Design: Store artifacts, media, and color data in normalized SQL schema
• SQL Analytics: Run 20+ predefined analytical queries for insights
• Interactive Visualization: Build Streamlit dashboards with Plotly charts

Architecture Flow: API → ETL → SQL (MySQL/TiDB) → Analytics → Streamlit Visualization

Installation