We use BigQuery as the data warehouse - there are airflow jobs to periodically load data into BQ - most of these are simple python scripts.

Metabase for most of our simple BI metrics - Tableau for some advanced users doing more complicated stuff.