What data warehouse to choose, what are the different visualization tools available, what events to send, how to setup Redshift, how to choose the keys for the tables, and yes, how to recreate popular dashboards with simple SQL queries.
Of course, we also have more complex queries for analysis, that we will share at a future post.
However, I hope that the SQL queries provided would be helpful to anyone who would like to build it on their own.
FD: I am Alooma's CTO