Harvard Art Museum ETL Analytics Skill

Skill by ara.so — Data Skills collection.

This skill enables you to build 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 Streamlit dashboards for artifact collections.

What This Project Does

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

• API Integration: Fetch artifact data from Harvard Art Museums API with pagination and rate limiting
• ETL Pipeline: Extract, transform, and load artifact metadata, media, and color data into relational databases
• SQL Analytics: Pre-built analytical queries for insights on culture, century, media, colors, and departments
• Visualization: Interactive Plotly charts and Streamlit dashboards for data exploration
• Database Design: Properly structured relational schema with foreign key relationships

Architecture flow: API → ETL → SQL → Analytics → Visualization

Installation