Book Image

Microsoft 365 and SharePoint Online Cookbook

By : Gaurav Mahajan, Sudeep Ghatak
Book Image

Microsoft 365 and SharePoint Online Cookbook

By: Gaurav Mahajan, Sudeep Ghatak

Overview of this book

Microsoft Office 365 provides tools for managing organizational tasks like content management, communication, report creation, and business automation processes. With this book, you'll get to grips with popular apps from Microsoft, enabling workspace collaboration and productivity using Microsoft SharePoint Online, Teams, and the Power Platform. In addition to guiding you through the implementation of Microsoft 365 apps, this practical guide helps you to learn from a Microsoft consultant's extensive experience of working with the Microsoft business suite. This cookbook covers recipes for implementing SharePoint Online for various content management tasks. You'll learn how to create sites for your organization and enhance collaboration across the business and then see how you can boost productivity with apps such as Microsoft Teams, Power Platform, Planner, Delve, and M365 Groups. You'll find out how to use the Power Platform to make the most of Power Apps, Power Automate, Power BI, and Power Virtual Agents. Finally, the book focuses on the SharePoint framework, which helps you to build custom Teams and SharePoint solutions. By the end of the book, you will be ready to use Microsoft 365 and SharePoint Online to enhance business productivity using a broad set of tools.
Table of Contents (22 chapters)

Modeling data

Modeling is a process of combining multiple data sources and setting relationships between the datasets.

To understand modeling, you need to first grasp some key database terms.

Primary key: The primary key of a relational table uniquely identifies each record in the table (refer to Customers.csv). A table can have only one primary key. Since a primary key is unique, it cannot be repeated in the same table. Take this, for example:

Customer info

In the preceding example, by specifying the customer ID, I can uniquely identify a person. There can be two customers with the same name, but they will each have a unique customer ID.

Foreign key: A database foreign key is a field in a relational table that matches the primary key column of another table (refer to Product_Sales.csv). See this, for example:

Sales info

The Customer ID column (used in the earlier...