This project transforms four raw datasets (
ORDERS ) into three summary reporting tables.
CUSTOMER_STATSprovides a single view of all customers: how many orders they’ve made, how much they’ve spent, where they’re from.
ORDER_STATSprovides a single view of every order, adding the number of line-items it included.
DAILY_COUNTRY_STATSprovides an aggregate view of total daily order volumes by country.