Hi, I would like to design a data model for time series data but I'm not sure what is the most optimal schema for such data.
This is customer volume data that contains fields such as store_id, date and time of customer visit, length of stay etc. The dates are daily data that range from 2016-2019 and we have 20 stores worldwide. How should I model this to build a dashboard that shows trends for each store/% changes/average length of stay?
Any suggestion is highly appreciated.
Thank you