Types of Enterprise Data (Transactional, Analytical, Master)

All business enterprises have three varieties of physical data located within their numerous information systems.  These varieties of data are characterized by their data types and their purpose within the organization.
• Transactional Data
• Analytical Data
• Master Data

Data Element Types

Transactional data supports the daily operations of an organization (i.e. describes business events). Analytical data supports decision-making, reporting, query, and analysis (i.e. describes business performance). While master data represents the key business entities upon which transactions are executed and the dimensions around which analysis is conducted (i.e. describes key business entities).

Transactional Data

Transactional data are the elements that support the on-going operations of an organization and are included in the application systems that automate key business processes. This can include areas such as sales, service, order management, manufacturing, purchasing, billing, accounts receivable and accounts payable. Commonly, transactional data refers to the data that is created and updated within the operational systems.  Examples of  transactional data included the time, place, price,discount, payment methods, etc. used at the point of sale. Transactional data is normally stored within normalized tables within Online Transaction Processing (OLTP) systems and are designed for integrity.  Rather than being the objects of a transaction such as customer or product, transactional data is the describing data including time and numeric values.

Analytical Data

Analytical data are the numerical values, metrics, and measurements that provide business intelligence and support organizational decision making. Typically analytical data is stored in Online Analytical Processing (OLAP) repositories optimized for decision support, such as enterprise data warehouses and department data marts. Analytical data is characterized as being the facts and numerical values in a dimensional model. Normally, the data resides in fact tables surrounded by key dimensions such as customer, product, account, location, and date/time. However, analytical data are defined as the numerical measurements rather than being the describing data.

Master Data

Master data is usually considered to play a key role in the core operation of a business. Moreover, master data refers to the key organizational entities that are used by several functional groups and are typically stored in different data systems across an organization.  Additionally, master data represents the business entities around which the organization’s business transactions are executed and the primary elements around which analytics are conducted. Master data is typically persistent, non-transactional data utilized by multiple systems that defines the primary business entities. Master data may include data about customers, products, employees, inventory, suppliers, and sites.

Share
12 replies
    • Adam Getz
      Adam Getz says:

      This is an excellent question. A soon as I am going to post the the explanation of analytical data.

      Thank you for your feedback.

      – Adam Getz
      Author, BI-INSIDER.COM

      Reply
    • Adam Getz
      Adam Getz says:

      An explanation of analytical data has just been added to this post. Thank you for your feedback.

      – Adam Getz
      Author, BI-INSIDER.COM

      Reply
  1. Samuel Akoto
    Samuel Akoto says:

    What is the difference between operational and transactional data? Your post does not consider operational data as type of enterprise data.

    Thank you,

    Samuel Akoto

    Reply
  2. Anny
    Anny says:

    Hi – I am curious to know how does Data governance relate to those group of data? Do you have to defined a governance framework around each of the enterprise data group when governing those data or just to the master data? Thank you!

    Reply

Trackbacks & Pingbacks

  1. […] are many types of data out there. Transactional (or dynamic) data is generated or modified by the systems that are used for transactional or operational purposes, […]

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *