Skills
.Work. You
Rest

harvard-art-museums-data-engineering-pipeline

Official

Create end-to-end data engineering pipelines for Harvard Art Museums data

Data & Analytics#ETL#Streamlit#data engineering#SQL analytics#Harvard Art Museums
AuthorAradotso
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill streamlines the process of building comprehensive data engineering pipelines for the Harvard Art Museums API, from data extraction to visualization.

Core Features & Use Cases

  • API Integration: Fetches and processes data from the Harvard Art Museums API.
  • ETL Pipeline: Extracts, transforms, and loads nested JSON into normalized SQL tables.
  • Database Design: Implements a multi-table relational schema with proper foreign keys.
  • SQL Analytics: Offers 20+ predefined analytical queries for insights.
  • Interactive Visualization: Provides Streamlit dashboards with Plotly charts.
  • Use Case: Develop a robust data engineering pipeline to analyze the art collection data from the Harvard Art Museums.

Quick Start

Run the ETL pipeline and start the Streamlit dashboard to explore Harvard Art Museums data.

Dependency Matrix

Required Modules

pandasrequestsmysql-connector-pythonplotlypython-dotenv

Components

scriptsreferencesassets

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: harvard-art-museums-data-engineering-pipeline
Download link: https://github.com/Aradotso/data-skills/archive/main.zip#harvard-art-museums-data-engineering-pipeline

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.