Transforming Financial Planning with Power Platform: A Journey through Data Modeling on Dataverse
Table of Contents
- Background
- Moving from a traditional database modeling mindset to data modeling on Dataverse
- Modeling for least-code mindset
- 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.