How would you approach a data Model below?


How would you approach a dataset in the format below:

  • Aggregate by different categories.
  • Revenue in multiple time-frames (montly, ytd, ytd last 3 months)

What is the best approach to have a final model as the imagem below? is there any library or functionality you would use to facilitate the summarization for multiple time period (instead of writing SQL statements) ?