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 with Plotly visualizations.
What This Project Does
The Harvard Artifacts Collection application provides:
API Integration
Fetch artifact data from Harvard Art Museums API with pagination and rate limiting
ETL Pipeline
Extract, transform, and load nested JSON data into relational SQL tables
Database Design
Structured storage with
artifactmetadata
,
artifactmedia
, and
artifactcolors
tables
SQL Analytics
20+ predefined analytical queries for insights
Interactive Dashboards
Streamlit-based visualization with Plotly charts
Architecture flow:
API → ETL → SQL → Analytics → Visualization
Installation
Show more
Installs
565
Repository
aradotso/data-skills
GitHub Stars
1
First Seen
May 25, 2026
Security Audits
Gen Agent Trust Hub
Pass
Socket
Pass
Snyk
Pass