Ecommerce store on Redshift

A fictional ecommerce store project on a Redshift data warehouse.

Summary

This project transforms four raw data tables (orders from Shopify, charges from Stripe, and customer from a CRM) into three summary reporting tables.

  • order_stats brings all orders information into a single table
  • customer_stats brings all customer information into a single table
  • daily_country_stats provides an overview of stats aggregated by country

Dependency tree of the project

Sample bigquery Dataform project DAG
Dependency tree of the Redshift sample project

View the project

(Viewing the example project on Dataform web requires sign up)

What's next

Stackoverflow data on BigQuery

A simple project turning Stackoverflow public raw data into reporting tables in a BigQuery data warehouse.

Ecommerce store on Snowflake

A fictional ecommerce store project on a Snowflake data warehouse.

Sitemap