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. When you add documents to Microsoft Teams, or Yammer, they’re stored in a document library.
In addition to lists, documents can also contain valuable data. For example, where one user may create a list to store data in rows and columns, another user may choose to do so in Excel, and then save the Excel file to a document library. Both containers hold valuable data, and as with most data, there will be a need to report on it.
Once the reporting needs go beyond the features available in a SharePoint view, a different reporting platform is necessary.
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.
Your choice of reporting platform depends on the report type, data, storage, and your skill level. With a wide variety of choices available, it is important to understand the strengths and weaknesses of different approaches to choose the right tool for the job.
This white paper examines the different platforms and approaches that can be used to report on SharePoint data and explains the procedures.
- WHITEPAPER: Using SharePoint as a data source for Modern Reporting (19pgs, PDF)
https://resources.techcommunity.microsoft.com/wp-content/uploads/2019/06/White-Paper-Using-SharePoint-as-a-data-source-for-Modern-Reporting.pdf
kurtsh
Kurt Shintaku's Blog 