Dataverse and model-driven apps

This 3-day deep-dive course is for anyone who wants to learn about Microsoft Dataverse and building model-driven apps. It provides more targeted training than the public courses from Microsoft.

Dataverse evolved from the database platform for Dynamics CRM (back in 2003) and has always been associated with model-driven apps. All versions of Dynamics CRM 1.0 on-premises through to the current offerings of Dynamics 365 Sales and Service have been delivered as model-driven apps.

Different from PL-200

This course differs from Microsoft’s PL-200 course in that it is not aimed at those in a particular job role. This is a deep-dive course covering Dataverse and model-driven apps in detail whereas PL-200 provides more of an overview.  This course does not cover Power Automate or canvas apps.

The course includes presentations, demos and exercises for students to perform.

This page is for the three day in-person instructor-led course.

The course is also available as an online recorded course where you study at your own pace.

After completing this course you will have a thorough understanding of Dataverse and how to build and modify model-driven apps.

After the course

After the course, you will have access to:

  • a forum where you can discuss the course and ask questions of the trainer and other students.
  • the online recorded version of the course

The trainer

The course is delivered by Feridun Kadir a long-standing Microsoft Certified Trainer who has delivered courses in Dynamics CRM, Dynamics 365 engagement apps and the Power Platform since 2004. 

DurationPrice (ex. VAT)
3 days
04 to 06-Sep-24
18 to 20-Nov-24
In-person - Central London

To book and pay online please click the button below. For other ways to pay or to reserve a place, please contact us.

Pre-requisites and target audience

A proficiency in basic computer skills using Microsoft Office 365 products is required. Database skills are useful but not required.

This course is suitable for:

  • Database administrators
  • Dynamics 365 and Power Platform end-users, power users, and administrators
  • IT Professionals
  • Consultants

You will be provided access to an instance of Dataverse for the duration of the class but you must bring your own laptop to perform the exercises.

Course Outline

Module 1: The Power Platform

This module provides a high-level overview of the Power Platform.

  • Power Platform  overview
  • Difference between model-driven apps and canvas apps
  • Brief history of Dataverse
  • Dataverse and environments
  • Managed environments

Module 2: Relational database concepts

This module provides an overview of general relational database concepts.

  • Relational databases
  • Tables
  • Relationships

Module 3: Dataverse tables

This module covers the types of tables implemented in Dataverse.

  • Create tables
  • Table properties
  • Standard, activity, virtual and elastic tables

Module 4: Dataverse columns

This module covers the types of columns used in Dataverse tables.

  • Create columns
  • Column properties
  • Column types
  • Calculated, rollup and formula columns

Module 5: Relationships

This module covers relationships between tables in Dataverse.

  • Relationship types implemented in Dataverse
  • Connections
  • Cascading behaviours
  • Mapping in relationships
  • Hierarchical relationships

Module 6: Security model

This module describes the security model in Dataverse

  • Adding users to Dataverse
  • Business Units
  • Security roles
  • Column-level security
  • Teams
  • Sharing
  • Hierarchy Security

Module 7: Import and export data

This module describes how to import and export data to and from Dataverse.

  • Import wizards
  • Use Power Query
  • Export to Excel
  • Excel and Word templates
  • Azure Synapse Link
  • Pdf option in Dynamics 365 Sales
  • Third-party methods

Module 8: Model-driven apps 

This module covers building model-driven apps.

  • Features of model-driven apps
  • User interface components
  • Site map and navigation
  • Forms - form types and form components
  • Business process flows
  • Configuring views
  • Control access to model-driven apps
  • Editing the command bar
  • Monitoring apps
  • High-level overview of using canvas apps in model-driven apps

Module 9: Logic and validation

This module covers logic and validation methods used in Dataverse and model-driven apps.

  • Business rules
  • JavaScript
  • Power Fx
  • Low-code plugins

Module 10: Automation

This module covers automation capabilities in Dataverse.

  • Classic workflows
  • High-level overview of Power Automate

Module 11: Reporting and visualization

This module covers the visualization options in model-driven apps.

  • Charts
  • Dashboards
  • Interactive dashboards
  • High-level overview of Power BI

Module 12: Dataverse settings

This module covers settings that change the operation of Dataverse.

  • Environment settings overview
  • Search
  • Auditing
  • Duplicate detection
  • Bulk delete
  • Long term data retention
  • Recycle bin 

Module 13: Overview of solutions

This module provides a high level overview of using solutions for customization and app development.

  • Solution overview
  • Solution types - unmanaged and managed