Skills
.Work. You
Rest

harvard-art-museum-etl-analytics

Official

Create ETL pipelines for Harvard Art Museums data analysis.

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 automates end-to-end data engineering pipelines for analyzing Harvard Art Museums data, streamlining the process of data extraction, transformation, and visualization.

Core Features & Use Cases

  • ETL Pipeline Creation: Build ETL pipelines to extract data from the Harvard Art Museums API, transform it into relational databases, and load it for analysis.
  • Data Analytics: Perform SQL analytics on the extracted data, including queries on culture, century, media, colors, and departments.
  • Visualization: Generate interactive visualizations and dashboards using Streamlit for data exploration.
  • Use Case: For a museum curator, this Skill could be used to analyze the collection's color distribution, media usage, or artifact distribution by culture over time.

Quick Start

To get started, run the ETL pipeline with the provided script and connect your database.

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-museum-etl-analytics
Download link: https://github.com/Aradotso/data-skills/archive/main.zip#harvard-art-museum-etl-analytics

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.