I can't believe I'm going to say this, but tableau can easily be the right solution. So, if you're dealing with large datasets stored in multiple systems (like

I can't believe I'm going to say this, but tableau can easily be the right solution. So, if you're dealing with large datasets stored in multiple systems (like Excel + MySQL + others) Tableau can be a boon. The ability to use many different sources of data, create calculated fields that merge/modify other fields, and then operate against them? Quite nice. I especially am happy with how I can create larger visualizations that work across different disparate datasets from many sources. However, it does have quite a few issues in terms of UX, usability, etc. but so far I've liked it. Your mileage may vary :)