In 6 steps to a company-wide usable database

Effective master data maintenance is a challenge, especially in the B2B segment. Incorrect, outdated and not cleanly structured data slows down many companies. We show you in 6 simple steps how to build a company-wide usable database. This will offer your company considerable advantages in the future.

 

Merge existing records

Data silos are a problem for many companies. Each department has its own data sets, which are often guarded like little treasures. This means that data is often recorded twice, is not available to all employees from other departments and is not kept up to date.

If a company wants an effective Master data maintenance it is important that these data silos are broken up. As a first step, we therefore recommend that you centralize and structure your data. When cleaning up duplicates, you should take into account that there may be hidden duplicates in addition to intraduplicates (duplicate data records that may have marginal differences).

This type of duplicate is created, for example, by name changes. If the name change is not known, a duplicate is created, i.e. a data record with the changed name is entered although the data record with the old company name already exists. The identification of hidden duplicates is only possible through a reference database with historical data records.

 

Definition of the important and relevant core data

In order to enable effective master data maintenance that is supported by all departments, the data records must first be defined. For this purpose, key users in the individual departments are advantageous, as they usually know the needs of their own department and can define them.

In this way, it can be avoided that unimportant data records that are not relevant for the company are included in the database that can be used throughout the company. In addition, it is ensured that the important data records for all departments are included in any case.

 

Checking the data sets - External solutions offer themselves

Once all specifications have been defined, the existing data records must be checked. Here, it is not only necessary to discover possible errors, but also to update and update data. In many companies, there are a number of dead ends, which make the work in this area much more time-consuming.

For this reason, many companies rely on external solutions in this step. Comprehensive Reference databases of these solutions make database cleansing much more efficient. This also includes a high availability of required information, such as industry codes, sales data and interconnection information. If these are missing, they can be added to the individual data record at the push of a button.

In addition, companies also benefit from external solutions in that the manpower of their own employees is not tied up by these tasks. The data records are checked automatically and updated data is thus available more quickly and in high quality. If enrichment is desired, this can be done automatically.

 

Data security through controlled data access

Once the existing data records have been checked, updated and optionally enriched, they can now be transferred to a central database that is accessible throughout the company. Access to the database can be easily defined via different user rights. In addition, individual data areas within the records can also be restricted for specific user groups. This allows the entire company to access the database. At the same time, data security is guaranteed.

 

Creation of new leads directly in the database according to clear specifications

Typing errors and duplicates are the most frequent sources of error in the manual creation of new addresses. Both of these can be eliminated by an automated and system-supported New creation can be prevented. Instead of entering all address components manually, as was previously the case, the user searches for the correct company address from a suggestion list via a name component and transfers this to the database. The system immediately sounds an alarm if this address is already contained in the database. Typing errors and duplicates are therefore no longer possible.

Automated address regeneration
System-integrated address regeneration for optimized address management

 

 

Overlap-free new potentials

In addition to expanding existing customers based on your own data, acquiring new clientele based on new customer data is just as important. The analysis of your existing customers plays an important role here. A customer structure analysis shows in which customer groups your most profitable customers are located and which customer groups cost too much effort and sales time with too little turnover.

Via a reference database, you can buy promising new customer potential without overlap with your existing data. In this way, you receive new leads that are of interest to your company.

 

Table of contents

Author André Schmidt

head of direct sales

In in his 16 years at beDirect, he has developed today's beDirect-CRM solutions significantly.

He and his team advise you around the issue Data Management. This ranges from optimal configured Standard via customised until complete newly developed Solutions.