three worthwhile reads on that topic: - https://blog.fishtownanalytics.com/what-are-the-steps-tools-in-setting-up-a-modern-saas-based-bi-infrastructure-281e086

three worthwhile reads on that topic: - https://blog.fishtownanalytics.com/what-are-the-steps-tools-in-setting-up-a-modern-saas-based-bi-infrastructure-281e0860f9a9 https://blog.fishtownanalytics.com/what-are-the-steps-tools-... - http://blog.clearbit.com/enterprise-grade-analytics-for-startups-2/ http://blog.clearbit.com/enterprise-grade-analytics-for-star... - https://www.simple.com/engineering/building-analytics-at-simple https://www.simple.com/engineering/building-analytics-at-sim... Three choices for your data warehouse: - Amazon Redshift - Google BigQuery - Snowflake Redshift is by far the dominating product in this market. I'd say they have around 60-70% market share. It also has the richest ecosystem of ETL and BI tools. We saw Google BigQuery coming in aggressively earlier this year, but now I'd say the major competitor that keeps coming up is Snowflake. I hear people are happy with Snwoflake and BigQuery. The major FUD you'll hear Google and Snowflake spread about Redshift is that it's (1) expensive because compute & storage are bundled and (2) that it doesn't scale. Both statements are false. Then you also have a choice of fully managed offerings like: - holistics.io - panoply.io I only learned about holistics.io in this thread. I have to say that I really like their value proposition and features. For your ETL - I have a whole spreadsheet full of tools that I'm happy to share with you. You will have two major use cases, one to get your production data into your dw, another one to unify it with all your SaaS data. with intermix.io we've built a performance analytics service for Amazon Redshift. And so we see all the different ETL tools that companies use. The ones we see used most frequently are: - Fivetran - Stich Data - Segment - Alooma All are very good products and I can only recommend using them. Hope that helps!