Microsoft Dev Blogs

Transforming Financial Planning with Power Platform: A Journey through Data Modeling on Dataverse

thumbnail

Table of Contents

  1. Background
  2. Moving from a traditional database modeling mindset to data modeling on Dataverse
  3. Modeling for least-code mindset
  4. Adapting data model to functional requirements

Background:

This article discusses the journey of creating a data model on Dataverse for a customer's financial planning processes.

Moving from a traditional database modeling mindset to data modeling on Dataverse:

This section explores the differences between traditional databases and Dataverse in terms of primary keys and designing the primary name column. It also highlights the importance of a normalized data model and the limitations of table row size and lookup columns.

Modeling for least-code mindset:

The article emphasizes the importance of a least-code mindset and how it can be achieved through intelligent use of calculated columns and views.

Adapting data model to functional requirements:

In this section, the authors describe how they adapted the data model to meet the customer's functional requirements, such as accommodating file columns and creating a hierarchy view.