Simple analysis usually answer recurrent questions, for this there is reporting and Tableau is not a good tool for reporting (too slow).
For ad hoc analysis instead, there is really nothing more powerful than R or python and it's plenty of tools & libraries that give you the speed you need.
For ad hoc analysis instead, there is really nothing more powerful than R or python and it's plenty of tools & libraries that give you the speed you need.