Harvard Art Museums Data Engineering & Analytics

Skill by ara.so — Data Skills collection.

This skill enables you to build production-ready data engineering pipelines using the Harvard Art Museums API. The project demonstrates real-world ETL patterns, relational database design, SQL analytics, and interactive visualization with Streamlit.

What It Does

• API Integration: Fetches artifact data from Harvard Art Museums API with pagination and rate limiting
• ETL Pipeline: Transforms nested JSON into normalized relational tables
• Database Design: Creates properly structured MySQL/TiDB tables with foreign keys
• SQL Analytics: Executes 20+ analytical queries for insights
• Visualization: Builds interactive Streamlit dashboards with Plotly charts

Installation