How would you design schemas that support efficient querying and scalable reporting for Amplifi clients?