I use Tableau because it has a good drag and drop interface for data viz. I usually connect it to databases and warehouses for real-time querying.

I love the dynamic tool tip charting that's pretty easy to create.

However, it's pretty expensive for large organizations, and Tableau server runs pretty slow after awhile. I recommend this for users who don't want to code up data viz.