{"id":20377,"date":"2022-09-06T08:00:00","date_gmt":"2022-09-06T15:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/3-primary-reasons-to-learn-dataverse\/"},"modified":"2022-09-06T08:00:00","modified_gmt":"2022-09-06T15:00:00","slug":"3-primary-reasons-to-learn-dataverse","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/3-primary-reasons-to-learn-dataverse\/","title":{"rendered":"3 Primary Reasons to Learn Dataverse"},"content":{"rendered":"

If you’ve been on the fence about learning Microsoft Dataverse for your Power Platform solutions, then this blog post is for you. We will explore the most proven motivators for learning, as well as using, Dataverse. We’ll cover three topics: Data Stewardship, Security and Integration.<\/p>\n

Data Stewardship to Scale <\/em><\/h1>\n

The most inspiring reason for learning Dataverse is the breadth of capabilities you can use to set strong standards for data stewardship. As per Wikipedia: “Data Stewardship means the formalization of accountability over the management of data, and the data-related resources. So, while data governance programs set the rules, data stewardship oversees the smooth implementation of those rules.” Therefore, data stewards seek a comprehensive approach to data management to ensure the quality, integrity, accessibility and security of the data.<\/p>\n

How does Dataverse help? Dataverse is designed to be more than just a database. It can also include data from other data sources, for example through virtual tables. Everyone can take advantage of the built-in Common Data Model (CDM)<\/a> tables designed to support strong communications between you and the businesses you partner with. Of course, you can also easily create custom tables, views, and forms. But don’t stop there! Take the data model to the next level by layering business logic, rules, and process flows to maintain data integrity and guide participants through important process steps or milestones. This end-to-end approach of optimizing enterprise data models enables both solution makers and business analysts to use, and to share data, with confidence.<\/p>\n

Get started right away extending the value of tables and leveraging business rules with the new “Formula Fx Column<\/a>“. The Formula Fx Column enables us to use Excel-like expressions within table columns (aka Power Fx<\/a>). In the solution below, I’ve added a column to check when the current contract value exceeds 30% of the original bid value. Now Dataverse will trigger process alerts through Power Automate when this occurs. Since the logic is built into the data, all the Makers (new and old) will automatically gain this logic when they build apps using this table; no matter what type of app they build!<\/p>\n

TIP<\/strong>: Leverage Formula Fx columns to drive consistency in process and notifications<\/em>
\n\"Image<\/p>\n

Granular <\/em>Security<\/h1>\n

Microsoft consistently prioritizes security and customer trust. Anyone can learn more about Microsoft’s Security and Trust commitment<\/a>, or specifically about security and compliance for the Power Platform<\/a>. So, why do I call this out as one of the three reasons for learning Dataverse? Because Dataverse brings security to the next level with its scenario-focused approach that facilitates a wealth of data visibility, security, compliance and auditing. Dataverse manages these through several layers of controls<\/a> making it a platform with security on steroids. Some of the most commonly used layers of security include, but are not limited to:<\/p>\n