Skills
.Work. You
Rest

data-warehouse-setup

Community

Build a scalable data backbone for analytics.

Data & Analytics#analytics#governance#etl#data-modeling#data-warehouse#data-security#bi-integration
Authorhuifer
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Data silos and inconsistent reporting hinder decision-making; this skill provides a blueprint to design and implement a scalable data warehouse with clear data architecture, ETL workflows, data modeling, BI integration, governance, and security.

Core Features & Use Cases

  • Data Architecture Design: define layered storage (ODS, DWD, DWS, ADS) and data services.
  • ETL/ELT workflows: design extraction, transformation, and loading with data quality checks and scheduling.
  • Data Modeling: dimensional and star/snowflake models for business analytics.
  • BI Tools Integration: connect to popular BI tools for dashboards and reports.
  • Data Governance & Security: policy, lineage, access control, and compliance considerations.
  • Use Case: consolidate Shopify data (orders, customers, products) into a single analytics platform for revenue and customer insights.

Quick Start

Define your data sources and kick off the ETL workflow to build ODS, DWD, DWS, and ADS layers.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 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: data-warehouse-setup
Download link: https://github.com/huifer/Shopilot/archive/main.zip#data-warehouse-setup

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 471,000+ vetted skills library on demand.