Am a keen follower of Microsoft's SharePoint Blog and proud to provide this direct from the Microsoft Tech Community:
NEW! Check out our latest white papers to help you learn how to use Microsoft 365 and SharePoint to transform your organizational data, analytics and reporting.
Using SharePoint and Teams as a Modern Dashboarding Platform (https://aka.ms/sharepoint/dashboard-wp )
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.
Using SharePoint as a data source for Modern Reporting (https://aka.ms/sharepoint/reporting-wp)
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.
Using Power BI with Complex SharePoint Field Types (https://aka.ms/sharepoint/datatypes-wp)
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.
The above is kindly provided by the Microsoft Tech Community!