This page explains how you can graph large amount of data quickly from SharePoint, and general tips to improve visualization performances.
What makes up the loading time?
The visualizer need to do two things in order to graph a visualization.
- Load data from SharePoint list/document library
- Render the loaded data on the selected graph
So, to speed up performance, let look at each step in turn
Improving data load time – use SharePoint list view
Manage large lists (more than 5000 items) in SharePoint is a complex topic, you can have a look at the Microsoft page. However, for visualization purposes, consider creating a dedicated SharePoint list view. A SharePoint list view can:
- Only show columns that’s necessary for visualization
- Apply filters to reduce the number of rows needed for visualization
To create a SharePoint list view that will help performance, follow these step:
Improve render time – use data grouping and use the right graphs
Once the data has been loaded by the visualizer, the rendering speed comes down to how many shapes (data points) must be rendered on the graph. To improve the rendering speed, consider
- Choose the right graph for your purpose
- Apply data grouping
Choose the right graph
Each graph has a different purpose, and with different rendering characteristics. For example, the line graph generally can handle a lot more data points than the pie graph. This is because the line is actually one shape (called “path”), so as the result, the line graph can handle a few thousands data points without any issues. However, if you try to render a few thousands pie slices on the one pie graph, it is not going to render well.
So choose the right graph is important, get familiar with the purpose and limitation of each graph and use the most appropriate one for your purpose.
Apply data grouping
Many graphs has the ability to group data and reduce the number of data points to render. Consider the following example.