Create a plugin that can display a pivot table and charts that users can customise at runtime.
The data source would be an entity on which the plugin lives. It should be able to create the view based on all the columns available in the data source.
The configured charts/table layouts might be saveable, similarly to the grid configuration.