As businesses look to modernize their line of business applications Microsoft Power Platform is the tool of choice to accelerate and implement digital transformation. Microsoft Power Platform is made up of Power Apps, Power Automate, Power BI and Power Virtual Agents. Microsoft Dataverse formerly known as Common Data Service (CDS) is a key component of the Power Platform and provides for data storage and related business logic execution. Microsoft Dataverse implements Microsoft’s Common Data Model (CDM) allowing it to be part of the data fabric in an organization with a common way of describing core business data. In this course, we are focused on using the Microsoft Dataverse to build business applications. Specifically, we will look at the capabilities required to build data models for real world business applications. These applications can be built by power users (e.g. Joe or Sue from accounting) or by professional app makers whose job is focused on building Power Platform solutions.
The target audience for this book is solution architects and app makers that are building applications inside their companies. It is also for those packaging up to resell as part of an ISV solution deployed on the Power Platform. Finally, it is for the consultant who is the road warrior helping companies customize the platform for their business needs. In fact, anyone building solutions that will help automate and manage internal business processes can benefit from its insight.
What is Microsoft Dataverse and when to use it as part of your data and business logic strategy. This includes understanding the core capabilities, architecture and high level licensing.
Microsoft Dataverse is a cloud service that provides data storage, security and data layer business logic execution for line of business apps. Dataverse is designed to make it easy to build business applications as part of the Power Platform. Power Apps, Power Automate, Power BI, Power Virtual Agents and Power Pages are the key components of the Power Platform and all have first class support for working with data stored in Dataverse. We will explore that throughout the rest of the content.
Understand how the Microsoft Common Data Model is used by Microsoft Dataverse and how you should leverage it when building your Microsoft Dataverse data model.
Tables are the key building blocks for storing data in Microsoft Dataverse. Learn about the different types of tables, ownership and how to decide between custom and CDM entity definitions.
Each Microsoft Dataverse table is a collection of columns that store the individual data elements. Each column has a data type. Learn about all the different Microsoft Dataverse data types and how to choose the best one for your data.
Relationships bring real world data models to life by describing the connections between business data (tables). This chapter explores how to use relationships and to select the right relationship behaviors based on your data and business requirements.
In this hands on lab you will create a data model using what you have learned on creating entities, fields and relationships.
At the heart of any good line of business application is the data model. Microsoft Dataverse allows app builders to declaratively build the data model and work with it using all the power of the platform. This chapter is a must-read for a good understanding of the decisions made in the remaining chapters.
There is no one size fits all for data modeling so one of the best ways to learn about it is via scenarios and challenges. In this collection each contains a scenario to convey approaches for data modeling of a specific problem or technique.