Startup Idea: SharePoint Dashboard Enhancement Tool

Startup idea to develop a tool facilitating visual representation of data on SharePoint lists. The tool should generate pivot chart views from the list data, auto-refresh based on updates made on the list and integrate with SharePoint seamlessly, eliminating the need to export data to excel.

We currently use a SharePoint list as a dashboard of active strategic and tactical projects. It can have multiple views in list style, but we are unable to get a robust visual of the complete list in chart form. We have resorted to exporting the list to excel, maintains the connection to the list, generating a pivot table in Excel and then adding a view of the excel chart to the SharePoint site. It constantly needs refreshed as changes are made and there is no easy way to do this either. A robust, automatically updated SharePoint dashboard charting tool or alternative to SharePoint is what is required for this gap in our capabilities. There are plenty of analytics tools but none that integrate seamlessly with SharePoint that I am aware of.