Some background: -I have little understanding of SharePoint as a tool -I work in a large organization that has a collection of sharepoint sites, but where administration of IT resources is highly centralized (and very difficult to influence) -I manage a number of Excel databases, some of them with PowerPivot data models behind and I want to start giving interactive access to other users (in remote locations, but who are part of the organization) to simple pivot tables fed by those data models. -The data models currently reside in my own computer, and are relatively large (>50MB) -When I tried to use Excel services as part of standard sharepoint, I quickly faced performance problems: i) size of files is too large (which may have a simple solution), and ii) users in remote locations would still need to open the data model in their computer if they were to access the file through regular Excel services, and given the type of hardware they have, that does not seem feasible (which does not have an easy solution, from what I understand) -Based on preliminary research, it was my understanding that using Powerpivot for Sharepoint would be the best solution, as it would allow the data model(s) to reside on the server, and users would not need to load them on their computer as such.
When I presented my thinking to IT in my organization, the answer I received was:
Are we talking about PowerPivot or Power BI? There might be some confusion in terms of what the different SharePoint BI capabilities are and how they can be leveraged. The combination of Excel, the PowerPivot add-in and a SharePoint BI center might be enough for what you are looking for, rather than opting for other functionalities that would require new licenses<
I am not an IT person, but I need to make sure I present the case clearly from a technical point of view, so that I don’t get caught up in an unnecessary back & forth with IT colleagues in HQ.
My need is simple: ability to interactively share pivot tables fed by large data models (managed by myself) with users in remote locations. I have powerpivot as it comes already as an add-in in 2013, so the add-in is not the problem.
So the question is: what is the optimal and most simple approach (which does not require additional “products” or licenses) that would achieve that, and how do I correctly describe it to a technical colleague?