Does anyone have any examples of backend workflows that aggregate data on a periodic basis?
I have e-commerce data like order value, units, items, discounts, etc. that I want to aggregate to at least a day so that I can produce a dashboard faster than having to sum all offers in a period, count all offers in the same period, divide offer amount by the offer count and then divide by 100 (ecomm platforms keep data in cents).
Thinking about aggregating each day at the end of the day then each week at the end of the week to make dashboarding faster.
Thoughts?