harvard-artifacts-data-engineering-pipeline

Official

Build ETL pipelines and analytics dashboards with Harvard Art Museums API data

AuthorAradotso
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides a comprehensive end-to-end solution for building ETL pipelines and analytics dashboards using the Harvard Art Museums API, empowering users to collect, transform, store, and analyze artifact data efficiently.

Core Features & Use Cases

  • ETL Pipeline: Automates data extraction, transformation, and loading from the Harvard Art Museums API.
  • Database Design: Implements normalized tables for structured data storage.
  • SQL Analytics: Executes predefined analytical queries for in-depth data analysis.
  • Visualization: Generates interactive dashboards with Streamlit and Plotly.
  • Use Case: Ideal for data engineers and analysts looking to create detailed analytics of museum collections and artifacts.

Quick Start

Run the ETL pipeline with the provided script to fetch, transform, and load data from the Harvard Art Museums API into a SQL database.

Dependency Matrix

Required Modules

streamlitpandasrequestsmysql-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-artifacts-data-engineering-pipeline
Download link: https://github.com/Aradotso/data-skills/archive/main.zip#harvard-artifacts-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.