My recommendation would be
- an ETL as a service such as fivetran, stitch, etc
- into a data warehouse such as snowflake, big-query, etc
- transform/aggregate/normalize/magic data using some ETL tool such as dbt, matillion, etc
- analytics tool such as Looker, Tableau, etc...