7 Sites to Utilize for PowerBI and SharePoint Aspects

The following are seven sites to utilize for PowerBI and SharePoint based aspects:

PowerBI Documentation:

https://docs.microsoft.com/en-us/power-bi/

 

Embed a report web part in SharePoint Online:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-embed-report-spo

 

Use the PowerBI Web Part:

https://support.microsoft.com/en-us/office/use-the-power-bi-web-part-32d8b85f-094d-4152-8e3b-df641ccf3968

 

Create a report on a SharePoint List in Power BI Desktop:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list

 

Integrate Power BI in Microsoft Teams and SharePoint:

https://docs.microsoft.com/en-us/learn/modules/modern-analytics-teams/

 

Integrate Power Apps, Power Automate, and Power BI with SharePoint Online:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-scenario-intro

 

Create calculated columns in Power BI Desktop:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns

5 Useful Sites for SharePoint Formulas

The following are five useful sites to utilize for SharePoint Formulas:

Introduction to SharePoint Formulas and Functions:

https://support.microsoft.com/en-us/office/introduction-to-sharepoint-formulas-and-functions-94e1b4cc-cd1c-49c2-80ec-90c9b9591f47  

 

Examples of Common Formulas in Lists:

https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3

 

Use Column Formatting to Customize SharePoint:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

 

Calculate Data in Lists or Libraries:

https://support.microsoft.com/en-us/office/calculate-data-in-lists-or-libraries-c5261743-667f-4833-bede-e516cef2a0e1

Understand SharePoint Forms Integration:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-form-integration 

5 Sites for Power Automate and PowerApp Templates

The following are five great sites to utilize to find and use various Power Automate and PowerApp templates:

Power Automate Templates:

https://powerautomate.microsoft.com/en-us/templates/

 

Templates & Downloads:

https://resources.techcommunity.microsoft.com/templates-downloads/

 

Community App Samples:

https://powerusers.microsoft.com/t5/Community-App-Samples/bd-p/AppFeedbackGallery

 

Use Excel and Word templates:

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/templates-overview

 

Create a cloud flow from a template in Power Automate:

https://docs.microsoft.com/en-us/power-automate/get-started-logic-template

 

Use flows in teams created from templates:

https://docs.microsoft.com/en-us/power-automate/teams/introduction-teams-templates

3 Useful SharePoint Site Templates with Site Scripts Websites

The following are three sites to utilize to understand SharePoint site templates with site scripts.

Such aspects are useful when one wants to create a customized site template in the Microsoft 365 SharePoint Online environment to be available when creating new web sites:

SharePoint site template and site script overview:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-overview

 

Get started creating site templates and site scripts:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/get-started-create-site-design

 

Apply and customize SharePoint site templates:

https://support.microsoft.com/en-us/office/apply-and-customize-sharepoint-site-templates-39382463-0e45-4d1b-be27-0e96aeec8398

Visio Templates for SharePoint and Microsoft 365 Projects

The following are three good sites to use for Visio templates that then can be used to diagram out SharePoint and Microsoft 365 projects:

Use Wireframe Templates to design websites and mobile apps:

https://support.microsoft.com/en-us/office/use-wireframe-templates-to-design-websites-and-mobile-apps-2d54dc55-f5c4-49a2-85da-d649eb7fc281

 

Featured Visio templates and diagrams:

https://support.microsoft.com/en-us/office/featured-visio-templates-and-diagrams-27d4274b-5fc2-4f5c-8190-35ff1db34aa5  

 

Office Visio Stencil:

https://www.microsoft.com/en-US/download/details.aspx?id=35772

5 Useful Sites for SharePoint Online Troubleshooting

The following are 5 useful sites for SharePoint Online Troubleshooting:

SharePoint Online troubleshooting:

https://docs.microsoft.com/en-us/sharepoint/troubleshoot/sharepoint-online-welcome 

How to troubleshoot issues in SharePoint Online and OneDrive using diagnostics:

https://docs.microsoft.com/en-us/sharepoint/troubleshoot/diagnostics/sharepoint-and-onedrive-diagnostics 

Office 365 SharePoint Online performance troubleshooter:

https://docs.microsoft.com/en-us/sharepoint/troubleshoot/performance/sharepoint-online-performance-troubleshooter 

Diagnosing performance issues with SharePoint Online:

https://docs.microsoft.com/en-us/microsoft-365/enterprise/diagnosing-performance-issues-with-sharepoint-online?view=o365-worldwide 

Troubleshoot issues with SharePoint:

https://support.microsoft.com/en-us/office/troubleshoot-issues-with-sharepoint-b6c6bab7-55f9-454a-924a-13bea01558ef

SharePoint - Pivot

The following are SharePoint Dictionary words of the Day related to Pivot: 

PivotChart filter pane

User interface element which displays a list of active fields in a pivot view and is utilized to apply filters to those fields.

 

PivotChart report

Chart which uses a pivot for the source data and uses filtering and sorting functionality for the report.

 

PivotTable data field

Pivot field which is in the PivotTable area which is where the data values are displayed.

 

PivotTable field list

A user interface element that displays a list of all pivot fields. A pivot field list can be utilized to populate a pivot report.

 

PivotTable filter parameter

Value which a filter on a pivot report is set to, that indicates matching values which are included in the result set.

 

PivotTable item

Single member of a pivot field.

 

PivotTable member

Individual data item within a certain dimension that is displayed in a pivot report. For example, a sales person maybe in the geography dimension from the Northern United States Region.