A business process consists of one or more indivisible behavioral events. In business systems of users, sufficient business data is usually obtained through tracking or daily accumulation. To know the logical relationships and flow directions between data, you must be familiar with the business processes of users and relevant data systems.

By using the process analysis method, you can list each phase of a business process, covering technology, data, and system environment. After analyzing the scope of job responsibilities in various departments of an enterprise, you can use tools to extract real models from business systems through reverse engineering. With reference to the business planning and design documents and the documents related to business operation such as development, design, and change, you can comprehensively analyze the source systems and business management systems that a data warehouse involves from the following aspects:
  • The data that is generated by each business unit and the databases that store the data.
  • The data that is generated in each phase of a business process and the content of the data.
  • The circumstances under which data is updated and the logic of data updates.

A business process can be a single business event, such as payment or refund of a transaction. A business process can be the status of an event, such as the current account balance. A business process can also be composed of a series of relevant business events. The definition of a business process depends on the content you want to analyze, such as the past event status, current event status, or event flow efficiency.

When analyzing the events of a business process, you need to predict the degree and scope of each analysis and then select a statistic granularity. After identifying dimensions and selecting a statistic granularity, you need to design dimension tables based on this statistic granularity for grouping and filtering data during analysis. The design of dimension tables involves dimension attributes. Finally, you need to determine the metrics to be measured.

In this tutorial, the business processes of the transaction order feature in the e-commerce marketing business unit are analyzed.

This is a typical business flowchart for e-commerce transactions. The business flowchart consists of four core business processes: order placement, payment by the buyer, shipping by the seller, and receipt confirmation. Receipt confirmation indicates that a transaction is successful. This tutorial focuses on analyzing the business process of receipt confirmation, where a transaction is successful.

After analyzing the business processes of users, you can divide data domains based on business analysis and decision-making requirements.