skills.rest
tomtoto757
tomtoto757COMMUNITY
Explore all skills by this author →
GitHub

ecommerce-data-warehouse

Builds ecommerce data warehouses with star schemas, ETL pipelines, and dbt models for BigQuery.

3|1|Updated Mar 21, 2026
Search Tags:#analytics#ETL#dbt#data warehouse#Shopify#BigQuery#star schema
One-click install
npx skills add https://github.com/tomtoto757/ecomm-ai-team --skill ecommerce-data-warehouse-tomtoto757
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ecommerce-data-warehouse
Source: https://github.com/tomtoto757/ecomm-ai-team/tree/main/skills/analytics-reporting/finsilabs/data-analytics/ecommerce-data-warehouse
Command: npx skills add https://github.com/tomtoto757/ecomm-ai-team --skill ecommerce-data-warehouse-tomtoto757

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Ecommerce merchants outgrow their platform's built-in analytics and cannot combine order, ad spend, shipping, and customer data into a single source of truth for custom reporting, cohort analysis, and attribution. ## Core Features & Use Cases - Warehouse Setup & Data Extraction: Guides BigQuery, Snowflake, or Redshift setup and connects Shopify, WooCommerce, or BigCommerce via Fivetran, Stitch, or Airbyte. - dbt Transformation Layer: Builds staging, intermediate, and mart models with SCD Type 2 dimensions, incremental fact tables, and data quality tests. - BI Integration: Connects Looker Studio, Metabase, or Tableau to the transformed analytics layer. - Use Case: A Shopify brand at $1M+ ARR syncs orders via Fivetran into BigQuery, runs the dbt Shopify package, and builds a Looker Studio dashboard combining ad spend with true ROAS. ## Quick Start Ask the AI to design a star schema and dbt project for your Shopify store's data in BigQuery, including staging models, an incremental order fact table, and schema tests.

Frequently Asked Questions about ecommerce-data-warehouse

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

FAQPage Schema
How do I build an ecommerce data warehouse for Shopify?▼

Connect Shopify to BigQuery using a managed connector like Fivetran or Stitch, then transform the raw data with dbt using staging and mart models. The pre-built fivetran/shopify dbt package provides production-quality models out of the box.

BigQuery vs Snowflake vs Redshift for ecommerce analytics?▼

BigQuery is recommended for most merchants due to its free tier, serverless operation, and strong Looker Studio integration. Snowflake suits teams needing time-travel and data sharing, while Redshift fits teams already invested in AWS.

How do I get WooCommerce data into BigQuery?▼

WooCommerce stores data in MySQL, so use Airbyte's WooCommerce connector, Stitch's MySQL connector, or direct MySQL CDC replication with Debezium. Metorik CSV exports loaded via Cloud Functions are a simpler alternative.

Why does warehouse revenue not match Shopify analytics?▼

Mismatches usually come from currency handling (cents vs. dollars), discount application order, or tax inclusion differences. Build a daily reconciliation check comparing warehouse totals to platform API totals.

How do I track historical product price changes in a warehouse?▼

Implement Slowly Changing Dimensions (SCD Type 2) on the product dimension with effective_from, effective_to, and is_current fields. Join fact tables to the product row that was current at the time of each order.

When should I not build a custom data warehouse?▼

If your platform's built-in analytics or an all-in-one tool like Polar Analytics answers your questions, skip the warehouse. Custom pipelines make sense around $1M+ ARR, multi-channel selling, or when analysts need SQL access to raw data.

Related Skills

Explore More Data & Analytics Skills→
nrakownrakow
1

ingestion-strategy

Select and configure data ingestion strategies for Fivetran, Airbyte, or custom pipelines.

Community
Intermediate
tomtoto757tomtoto757
3

ecommerce-data-warehouse

Builds ecommerce data warehouses with star schemas, ETL pipelines, and dbt models for BigQuery.

Community
Advanced
clawdataclawdata
24

data-quality

Generate schema YAML tests and custom checks for dbt models.

Official
Intermediate
finsilabsfinsilabs
44

product-analytics

Analyze product performance metrics like sell-through rates and dead stock.

Official
Intermediate