I often do a fair amount of exploratory data analysis in Excel, and then take it to a BI tool or some other process to actually formalize it.

In excel the ability to be sloppy is actually really nice to just sling together a few random models and call it good when I don't need to be precise.