数据与研究

harvard-art-museums-data-engineering

reason-machines/data-skills

Build end-to-end data pipelines with Harvard Art Museums API, ETL workflows, SQL analytics, and Streamlit dashboards

  • 843 次安装
  • 5 星标
  • 收录于

安装命令

npx skills add https://github.com/reason-machines/data-skills --skill harvard-art-museums-data-engineering

SKILL.md

Harvard Art Museums Data Engineering & Analytics

Skill by ara.so — Data Skills collection.

This skill enables you to build production-ready data engineering pipelines using the Harvard Art Museums API. The project demonstrates real-world ETL patterns, relational database design, SQL analytics, and interactive visualization with Streamlit.

What It Does

  • API Integration: Fetches artifact data from Harvard Art Museums API with pagination and rate limiting
  • ETL Pipeline: Transforms nested JSON into normalized relational tables
  • Database Design: Creates properly structured MySQL/TiDB tables with foreign keys
  • SQL Analytics: Executes 20+ analytical queries for insights
  • Visualization: Builds interactive Streamlit dashboards with Plotly charts

Installation

Harvard Art Museums Data Engineering & Analytics

Skill by ara.so — Data Skills collection.

This skill enables you to build production-ready data engineering pipelines using the Harvard Art Museums API. The project demonstrates real-world ETL patterns, relational database design, SQL analytics, and interactive visualization with Streamlit.

What It Does

  • API Integration: Fetches artifact data from Harvard Art Museums API with pagination and rate limiting
  • ETL Pipeline: Transforms nested JSON into normalized relational tables
  • Database Design: Creates properly structured MySQL/TiDB tables with foreign keys
  • SQL Analytics: Executes 20+ analytical queries for insights
  • Visualization: Builds interactive Streamlit dashboards with Plotly charts

Installation