Comment by TheMakeA

It sounds like what you're looking for is Business Intelligence. There are a couple of cloud tools like Chartio, Tableau, Looker, etc that provide similar functionality.