How do you deliver analytics to your users?

Hey everyone, I am currently working through how to deliver analytics on a users site (each site is hosted on a subdomain @ urspace.io) to our users. My idea was to have segment hit redshift, then my backend could query redshift to get the data? Although, I believe this data would only refresh twice a day (or whatever segments push schedule is).

I am currently using segment, and can push data anywhere segment allows. Would love to know what solutions you have worked on in the past!