Microsoft Dataverse (formerly Common Data Service)

Microsoft Dataverse (formerly Common Data Service) cover image

ABOUT THE COURSE

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.

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

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
    7 Minutes 
  • Overview Details
    35 Minutes 

    The Common Data Service (CDS) is a cloud service that provides data storage, security and data layer business logic execution for line of business apps. CDS is designed to make it easy to build business applications as part of the Power Platform. PowerApps, Microsoft Flow, Power BI are the key components of the Power Platform and all have first class support for working with data stored in CDS. We will explore that throughout the rest of the content.

  • MVP Blog Links
    1 Minutes 
  • Test your knowledge
    10 Minutes 
Common Data Model Overview

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
    5 Minutes 
  • CDM Details
    35 Minutes 
  • Test your knowledge
    10 Minutes 
Working with tables

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
    35 Minutes 
  • Walkthrough - Creating Tables
    5 Minutes 
  • Test your knowledge
    10 Minutes 
Working with columns

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
    35 Minutes 
  • Walkthrough
    9 Minutes 
  • Test your knowledge
    10 Minutes 
Relationships

Relationships bring real world data models to life by describing the connections between business data (entities). This chapter explores how to use relationships and to select the right relationship behaviors based on your data and business requirements.

  • Relationship Details
    35 Minutes 
  • Walkthrough
    6 Minutes 
  • Hands On Lab
    30 Minutes 

    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
    10 Minutes 
Data Modeling

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
    30 Minutes 
Data Modeling Scenarios

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
    30 Minutes 
  • Challenge #1
    30 Minutes 
Security Modeling
  • Security Modeling Details
    20 Minutes 
Working with data
  • Using SQL with Microsoft Dataverse
    16 Minutes