This project provides an end-to-end data engineering and analytics application built on the Harvard Art Museums API. It demonstrates real-world ETL pipelines, SQL database design, analytical queries, and interactive visualization using Streamlit. The architecture follows: API → ETL → SQL → Analytics → Visualization.
What This Project Does
API Integration
Fetches artifact data from Harvard Art Museums API with pagination and rate limiting
ETL Pipeline
Extracts, transforms, and loads nested JSON into relational database tables
SQL Database
Stores structured data across
artifactmetadata
,
artifactmedia
, and
artifactcolors
tables
Analytics
Executes 20+ predefined SQL queries for insights
Visualization
Interactive dashboards using Plotly and Streamlit
Installation
Show more
Installs
566
Repository
aradotso/data-skills
GitHub Stars
1
First Seen
May 25, 2026
Security Audits
Gen Agent Trust Hub
Pass
Socket
Pass
Snyk
Pass