Common Data Service

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. The Common Data Service (CDS) is a key component of the Power Platform and provides for data storage and related business logic execution. CDS 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 Common Data Service 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

Common Data Service Overview

What is the Common Data Service (CDS) 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
    7 Minutes 
  • Overview Details
    35 Minutes 
  • MVP Blog Links
    1 Minutes 
  • Test your knowledge
    10 Minutes 
Common Data Model Overview

Understand how the Microsoft Common Data Model is used by CDS and how you should leverage it when building your CDS data model.

  • Overview
    5 Minutes 
  • CDM Details
    35 Minutes 
  • Test your knowledge
    10 Minutes 
Working with entities

Entities are the key building blocks for storing data in CDS. Learn about the different types of entities, ownership and how to decide between custom and CDM entity definitions.

  • Entity Details
    35 Minutes 
  • Walkthrough - Creating Entities
    5 Minutes 
  • Test your knowledge
    10 Minutes 
Working with fields

Each CDS entity is a collection of fields that store the individual data elements. Each field has a data type. Learn about all the different CDS data types and how to choose the best one for your data.

  • Field 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 
  • Test your knowledge
    10 Minutes 
Data Modeling

At the heart of any good line of business application is the data model. CDS 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 
Working with data
  • Using SQL with CDS
    16 Minutes