Business Process Mapping


Understand the company’s flow of and use of information according to current and future business needs.  This understanding will then help support management in making a more informative and strategic decision as it will allow management to evaluate impacts to time and resources (both people and financial) prior to going ahead with implementing any business change.


To understand where and how the business captures information.

PROCESS goran-ivos-246271-unsplash.jpg


- Each department or function has their own business process which captures and uses their information according to their needs.   

-Every application stores information or data.  We need to identify where, what and how the data is stored and used.


Step 1:  Identify how your data is stored.

Information provided by:  IT Analyst/Tech Support

Request:  Identify what type of program each department or employee uses

                Example:  Department A:  stores information in excel for mailing lists

Result:  Complete listing of all applications used for your business processes (include both front-end and back-end). 

Step 2:  Identify what type of data is stored (the data elements)

Information provided by:  IT Analyst/Tech Support

Request:  List of all data elements captured by the users in all applications

                Example:              Department A

                                                Uses: Excel for mailing lists

                                                Data Captured: Name, Address, Phone #, etc.

This should also include identifying information sharing or data transferring

Result:  Depending on what type of database structures you have this can come in many forms. Examples may include:

                - Entity-Relationship (ER) diagrams

                - Data Dictionaries

- Column headings (with sample data)


Step 3: Identify each department’s business processes (how and why that information is captured and used) and map data to data warehouse.

Information provided by:  Business Analyst

Request:  Users to provide their current business process to a business analyst

                Example:              Department A

Application: Excel

Business:             Input:  How is data captured (Example:  Manually entered)

Procedure:  How is the data manipulated (Example: calculates an invoice)

Output: What is the data’s end result (Example:  creates a printed invoice)

Result:  A complete Business Process Model that maps the business process to a data warehouse highlighting any efficiencies and inefficiencies in either data capture or data processing.  This information can then be used by management to analyze any impacts to their business in light of any future business changes.

Robyn Hounjet