I can see many of the exploratory data analytic can be done without joins. Well, my experience could be too specific though.