Discuss the process of designing and building composite models that include aggregations. Explain how you would manage the trade-offs between query performance and data granularity in such models.