SharePoint has a long history of providing a first-class platform for business intelligence dashboards based on Power BI, Excel Online, Power BI Report server, and related tools. Adding conversations and other collaborative content brings context to the content and helps to foster a data culture. SharePoint pages, as well as lists, can be integrated into Microsoft Teams, bringing all this richness to the Teams collaborative environment. This paper will outline the various approaches to building dashboards in SharePoint, Microsoft Teams and SharePoint Server.
SharePoint is a great organizational data store. SharePoint lists offer a quick and easy way for users to store and share millions of items, while document libraries have become the industry standard for document management, supplying secure, reliable storage. SharePoint libraries supply the backbone for document storage in all of Office 365. There are several different platforms and technologies for working with SharePoint data, such as Power Query, Excel, Power BI, SQL Server Reporting Services and SQL Server Integration Services. This white paper examines the different platforms and approaches that can be used to report on SharePoint data and explains the procedures.
SharePoint lists supply a quick and easy way for users to store and share millions of list-based items. Text and number fields are straightforward, but complex field types in SharePoint present several challenges. Power BI provides tools to aid with these challenges, and these tools are the focus of this white paper.