In SharePoint, you have two functionalities from my perspective. One is from a newsletter perspective and the other is from a team perspective For example; you have the SharePoint Teams and then you have the SharePoint Newsletter.
SharePoint Teams allows you to create a concept as a team, whereas SharePoint you create a workspace in Power BI and also you create a channel in Microsoft Teams. That's the beauty of the full component of Office 365. When you create things, you also can expand the same functionality for the additional applications that are out of there. The SharePoint News is used when you want to create newsletter updates on SharePoint.
On the point of the design is a design capability. They're there for you to put hyperlinks to other pages if it was your HyperText Markup Language or web page, so the idea or the service is to do a little bit in that direction. A good advantage is that you can create lists in SharePoint.
Basically, you have a full list and the beauty of that is that you can have a Power app that works with it. For example; you could develop a Power app that could be connected to that same SharePoint list. Your Power app will be your front end, where you input your data. Then your SharePoint will get that data into that SharePoint list. It means that you could use the Power BI connected to that SharePoint list to develop your front end, including the visualization of your reports.
Then, you could embed that Power BI report inside of the SharePoint for the end-users to consume. Inside of that SharePoint, they could see the report and they could see the information. Essentially, it is the full suite of Office 365 with the advantage of using the SharePoint database as your list. This is an example of one way that you could use it.