You probably need this analytics setup

Smaller companies can often get by analysing data directly from an application database. As a company grows, and has data from multiple sources, they tend to need to combine it in a dedicated data warehouse. A guide written by BI platform company Holistics offers a nice starting point on how to do this.

It looks at some of the options for data warehouses (Redshift vs Big Query vs Snowflake), some concepts around the data modelling, and how these end up getting used in practice.

If you are just getting started with your analytics setup, this is a good place to start.