as mentionned above I would like to have a pivot chart, or a pivot table, on Sharepoint accessing ~1M rows, with up to 100 variables. I'm a beginner with Sharepoint and I'm not aware if it would perform correctly. Presently, we host excel files that users download and run the pivot tables on their own computer instead.
Also, will multiple users be able to access the pivot chart/table separately at the same time? Does the data need to be stored as a list on sharepoint, or is there a better approach?