Microsoft Dataverse cover image

Microsoft Dataverse

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.

Advanced Features

This course includes 365Ai that allows you to interactively learn.

Who is this course for?

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.

COURSE INSTRUCTOR

David Yack

David Yack

David is the CTO of Colorado Technology Consultants based in Colorado and is recognized as a Microsoft MVP


Course Module Details

Microsoft Dataverse Overview (1 Hours)

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.

  • Overview Preview
  • Overview Details

    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.

  • MVP Blog Links
  • Dataverse 365Ai

    365Ai is your training copilot and allows you to ask questions in context of your learning.

  • Test your knowledge
Common Data Model Overview (1 Hours)

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.

  • Overview
  • CDM Details
  • Test your knowledge
Working with tables (1 Hours)

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.

  • Table Details
  • Walkthrough - Creating Tables
  • Test your knowledge
Working with columns (1 Hours)

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.

  • Column Details
  • Walkthrough
  • Test your knowledge
Relationships (1.5 Hours)

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.

  • Relationship Details
  • Walkthrough
  • Hands On Lab

    In this hands on lab you will create a data model using what you have learned on creating entities, fields and relationships.

  • Test your knowledge
Data Modeling (30 Minutes)

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.

  • Data Modeling Details
Data Modeling Scenarios (1 Hours)

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.

  • Scenario - Photo Leasing
  • Challenge #1
Security Modeling (20 Minutes)
  • Security Modeling Details
Working with data (16 Minutes)
  • Using SQL with Microsoft Dataverse
Course complete (2 Minutes)
  • Certificate of completion available