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 tablecustomer_stats
brings all customer information into a single tabledaily_country_stats
provides an overview of stats aggregated by country