Why Should A Data Modeler Care About Business Processes?

Data Modelers are responsible for creating and maintaining conceptual, logical and physical data models.  These data models are used to define the data requirements that support the business goals. Data modelers work closely with business stakeholders and users of the information systems.

Business stakeholders want to see how the data is used in their business processes at a high level. They frequently get lost in the highly technical details of a traditional data model.  Business Process Models allow data modelers to outline data interactions in terms that business stakeholders can more easily understand. 

Data Modelers can use Business Processes to define how data is used in an organization via:

  • Tasks or activities that use data tables, views, entities, data stores or data feeds
  • Triggers that signal that something in the data is created, read, updated and deleted (CRUD)
  • The business decisions (or business rules) that have an impact on the data
  • Who can access data at what points in the process and which level of access they are granted (very useful for data governance and data quality)
  • The business units that interact with a particular data definition (i.e. Marketing may define a Customer differently than the Product Management Team)
  • The data's story through the business process journey (useful in understanding the data lineage)


Here's a quick 2-minute video that showcases how data modelers can leverage business processes to help to communicate within the business organization: