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.

SharePoint - Permission

The following are SharePoint Dictionary Words of the Day Related to Permission:

Permission

A rule which is associated with an object to regulate who can gain certain access to that said object and what aspects they can perform based on that access.

 

Permission level

Set of permissions which can be granted to certain SharePoint groups on a site, list, folder, item, or document.

SharePoint Top 3 End User Sites

 

SharePoint Top 3 End User Sites

 

The following are 3 key links for end users on SharePoint:

Get started with SharePoint

https://support.microsoft.com/en-us/office/get-started-with-sharepoint-909ec2f0-05c8-4e92-8ad3-3f8b0b6cf261

 

SharePoint Video Training

https://support.microsoft.com/en-us/office/sharepoint-video-training-cb8ef501-84db-4427-ac77-ec2009fb8e23

 

SharePoint Help & Learning

https://support.microsoft.com/en-us/sharepoint

MS Teams 5 Key Links for End Users

 MS Teams 5 Key Links for End Users

 

The following are 5 key links for end users on Microsoft Teams aspects:

 

Welcome to Microsoft Teams

https://support.microsoft.com/en-us/office/welcome-to-microsoft-teams-b98d533f-118e-4bae-bf44-3df2470c2b12

 

Microsoft Teams Training

https://docs.microsoft.com/en-us/microsoftteams/training-microsoft-teams-landing-page

 

Microsoft Teams Video Training

https://support.microsoft.com/en-us/office/microsoft-teams-video-training-4f108e54-240b-4351-8084-b1089f0d21d7

 

Microsoft Teams Help & Learning

https://support.microsoft.com/en-us/teams

 

Get help in Microsoft Teams

https://docs.microsoft.com/en-us/MicrosoftTeams/get-help-in-microsoft-teams

SharePoint - Parameterized Query

The following is a SharePoint Dictionary Word of the Day:

Parameterized Query

Query which contains parameters such as those applied to Open Database Connectivity (ODBC) and web-based queries. An example of such an item would be parameters added to a query for a product lookup.

SharePoint - Parameter

The following is a SharePoint Dictionary Word of the Day:

Parameter

Metadata item that represents formal parameters for business logic in a line-of-business (LOB) system. Parameters have a single root item that defines the structure of the parameter.

SharePoint - Paged View

The following is a SharePoint Dictionary Word of the Day: 

Paged view

View which supports one or more visual pages. Such a view is utilized to break up larger sets of data into smaller sets in order to increase performance and manageability.