SharePoint Business Intelligence

As more customer and staff interactions take place online, more data is captured and stored by organisations and demand for data and analytics increases daily. At the same time, however, the complexity of creating insights from multiple data sources makes it more difficult to provide usable information for decision making.

With comprehensive Microsoft Office integration including Access Services, SQL Server connectivity, and the ability to define connections to other external data sources, SharePoint can become a hub for quick and effective business analysis.

1.PowerBI can be used with cloud, on-premise or hybrid architecture and accessed on desktop or mobile to intuitively present data from multiple sources, including SharePoint. Microsoft describes it thus: “Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.”

2.Power Pivot is an Excel add-in you can use to perform data analysis and create sophisticated data models – a turbo Pivot table. Power Pivot allows you to combine data from multiple sources, perform information analysis and share insights through the Business Intelligence Center – a SharePoint site specifically designed for reporting.

3.Google Chart Web Part is a free API that provides a quick way to build graphs and charts from SharePoint list data. You can select from a range of charts, from simple scatter plots to hierarchical tree maps and customise them to your brand guidelines. It does require some technical knowledge, so if you think JQuery is a new band, stick to the WYSIWYG offerings. Also note that Office 2013 SharePoint does not offer the Chart Web Part.

4.Visio Services is a service application that allows users to view Visio diagrams. It is useful for BI because the service also enables data-connected Visio 2016 diagrams to be refreshed and updated from a variety of data sources.


For information on who is using your SharePoint online intranet, you can utilise Google Analytics but SharePoint also has its own usage trends reports such as Popularity Trends reports for a site or site collection. These show historical usage information eg views & unique users for a defined period. Most Popular Items in a library shows which items have the most views, either for a certain date range or since the dawn of time.