I've tried a few ways to visualise data and Power BI is the one that I keep coming back to and recommend to others. It has a free tier, thriving plugin marketplace and an astonishing rate of development. But I like it principally because it connects to everything and making pretty and informative pictures is easy. It's like next level Excel, if you can do pivot tables you can do live dashboards and multi-page reports.