Depending on the technical abilities of the person using the solution, I would recommend one of the below two systems:

- Chartio: A good tool for someone who isn't very technical to discover insights. Drag-and-drop interface.

- Periscope: A good tool for someone who is able to write SQL to build visualizations from their queries.