skills.rest
muzhicaomingwang
muzhicaomingwangCOMMUNITY
Explore all skills by this author →
GitHub

data-warehouse

Consolidate data sources into a single source of truth for analytics.

3|2|Updated Dec 26, 2025
Search Tags:#governance#cloud#etl#data-modeling#data-quality#data-warehouse#star-schema
One-click install
npx skills add https://github.com/muzhicaomingwang/ai-ideas --skill data-warehouse
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-warehouse
Source: https://github.com/muzhicaomingwang/ai-ideas/tree/main/.project/ai/ops/skills/data-warehouse
Command: npx skills add https://github.com/muzhicaomingwang/ai-ideas --skill data-warehouse

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Data warehouse teams struggle to define a single source of truth, design scalable ingestion-to-transformation pipelines, and deliver reliable analytics across BI, product analytics, and ML features.

Core Features & Use Cases

  • End-to-end warehouse design: sources → staging → warehouse → marts with clear data lineage.
  • Modeling, quality, and governance: star schemas, data quality checks, partitioning, cost/performance optimization, and access controls.
  • Use cases: BI dashboards, operational analytics, and ML feature pipelines requiring trusted, timely data.

Quick Start

Instantiate a basic data-warehouse blueprint by outlining sources, staging, warehouse, and marts with a simple star-schema model and a minimal governance plan.

Frequently Asked Questions about data-warehouse

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a scalable data warehouse with a single source of truth for analytics?▼

Design a scalable data warehouse by mapping sources to staging, warehouse, and marts layers with clear data lineage. This establishes a single source of truth for BI dashboards, product analytics, and ML feature stores.

What is the best way to plan ETL/ELT pipelines for a cloud data warehouse?▼

Plan ETL/ELT pipelines using DAG-based architectures to move data from sources through staging to marts. This ensures reliable data transformation and timely delivery for operational analytics and ML feature pipelines.

How does star schema data modeling work for BI dashboards?▼

Star schema data modeling structures warehouse data into fact and dimension tables to optimize BI dashboard queries. It simplifies data structures for faster aggregation and clearer analytics reporting across data marts.

Can I implement data quality checks and governance across my ETL pipelines?▼

Yes, you can implement data quality checks and governance across ETL pipelines. This includes partitioning, cost and performance tuning, access controls, and lineage tracking to satisfy data SLAs.

Does data warehouse design support partitioning and cost performance tuning?▼

Data warehouse design supports partitioning and cost performance tuning to optimize query speeds and resource usage. These techniques manage large datasets efficiently while maintaining strict data quality and SLAs.

Related Skills

Explore More Data & Analytics Skills→
starlake-aistarlake-ai
209

ingest

Ingest data from diverse sources into a data lake or warehouse.

Official
Basic
rafaelminatto1rafaelminatto1

fisioflow-analytics-dashboard

Build analytics dashboards for FisioFlow using existing BI infrastructure.

Community
Advanced
dtsongdtsong
1

Pipeline Design

Designs data pipelines covering ETL vs ELT patterns and orchestration tools like Airflow or Dagster.

Community
Advanced
francanetefrancanete
1

postgres-schema-design

Design PostgreSQL schemas with data types, constraints, indexes, and partitioning.

Community
Advanced