We have a quarterly meeding that is just a slide show of various “measurements” that each department is responsible for. A “slide” is displayed on an internal webpage, it has certain form fields it displays… and a graph or chart that accompanies the “measurement”.
This info is entered in via web form, but there is very little end user freedom. If they want to add an additional field, they have to go through someone in our IT dept, and he adds it. I dont know the details of how these pages are being served up, but its all .asp and either he doesnt have time to make it look slick, or there is some other limitation.
To me it looks like a perfect opportunity to use Sharepoint. I think Excel Services are included in SPO Enterprise, but things like PowerPivot and Power View might be another per user monthly subscription. Im still researching it.
Ive made a Business Intelligence Center to host these things, but it may not even need to be that complicated if all we can get by with, is building a dashboard off of a spreadsheet. Just wondered what other might think of this business need, and if Excel Services could fit the bill.
Im adding a slide from our current in house hosted solution. (that i have no part of btw so i dont know any of its details)
I was just approached by our CEO, and asked if Sharepoint can do that out of the box. Which im pretty sure it can. In addition, it may even be easier for the end user to create their own dashboards, and let the best ideas rise to the top so-to-speak.
Looks like im mixing on prem and O365 products again (story of my O365 career so far).
Upon further research, looks like Excel Online is the O365 counterpart to Excel Services (on prem).
Power BI is an add-on, ~$17.00 per user license for non-profits. So it sounds like power BI is a more robust way to display data, over Excel online (excel web part view ect..). Still researching, not sure we can add 2 dozen Power Bi licences for something we only need one day per quarter.
