I want to filter records based on a value of another table. Metabase allows us to have first level join, but is there any way to take this level to more stages?
Sadly not. I’ve not checked if it’s in the futures or not, worth checking.
I tend to use a lot of views to simplify the data. Metabase’s ideal is a simple star schema.
Not really. If you have a complex data structure, tidy it up using views to make it simpler to explore the data. If you can give your users 10 view to work with instead of 500 table, they’ll get much more done.