Cleaning Data

In the process of Data Cleaning we make sure that the identity of the client i.e. product numbers, area codes, country codes etc. are identical. Also, we secure the correct currency and interpolation of e.g. monthly or weekly reports. Back in the days, the distributor had to match the format of either client “X or “Y”. With our solution, the distributor is able to centralize this process in ParsePort, where its only necessary to match each format once.

http://parseport.com/wp-content/uploads/2018/11/POS-cleaning-1280x1392.png

Cleaning Data
How does it work?

Cleaning Data
How does it work?

What usually happens when collecting data from resellers, is the Vendor handing out a genera
So, what happens if several distributors sell to the same clients, but these clients or not registered under the same title in every distributors system? Or, what if a reseller doesn’t use the correct product codes, only inhouse product codes?

In our Data Cleaning service, we make sure that the identity of the company, the customers, the products and all other data is correct and in line with each other. This saves time for all parts of the business, centralizes the process and prevents many possible validation errors. Contact us for more details, and take a look at our Complete Data Process solution, where we collect, cleans and visualize your POS data – faster, cheaper and easier than performing the task inhouse.

So, what happens if several distributors sell to the same clients, but these clients or not registered under the same title in every distributors system? Or, what if a reseller doesn’t use the correct product codes, only inhouse product codes?

In our Data Cleaning service, we make sure that the identity of the company, the customers, the products and all other data is correct and in line with each other. This saves time for all parts of the business, centralizes the process and prevents many possible validation errors. Contact us for more details, and take a look at our Complete Data Process solution, where we collect, cleans and visualize your POS data – faster, cheaper and easier than performing the task inhouse.

Free Preview

So, you wanna see if we can walk the talk? We offer a free preview of our products, without obligations.

Possible
Reporting scenarios

Underneath, you’ll see how our POS Data Management service can solve various reporting scenarios, which are normally faced on vendor level.
SCENARIO 1: Stock and inventory figures are flowing heavily between all parties.

OUR SOLUTION: To avoid a lot of data conversion, column moving and VLOOKUP’s, Vendor 1 usually utilizes its market position to enforce fixed reporting templates. The problem with this is, that the reporting template for Vendor 1 is not the same as for Vendor 2. We solve this by offering resellers and distributors one simple point of reporting for some or all sales and inventory data. The data can be delivered in virtually any format (.csv, .txt, EDI, Excel etc.), and the data supplier instructs ParsePort on who should receive what data once for all. The reseller/distributor can now route requests from vendors directly to ParsePort.

SCENARIO 2: No common format is used.

SOLUTION: If we assume that all the sales and inventory figures is delivered to the Vendor in a fixed format, the Vendor now faces the next problem: If it utilizes multiple distributors and these offer the products to the same resellers, there is a chance that Distributor 1 will report selling 1 pc. “XX-YYYY” to “Reseller 1” at a price of 100 EUR and Distributor 2 will report selling 1 pc. “XXYYYY” to “Reseller_1” at a price of 745 DKK. It is the same product and price – with small variances in how it is being reported. WE can easily pass your data on as e.g. Excel – just as we can change columns and headlines to match the vendor preference. Should the vendor at some point want to change their reporting template, ParsePort will just change the export filter and no distributors/resellers will be troubled or affected in any way.

SCENARIO 3: Even with fixed reporting templates, the vendor still does a huge load of data cleaning.

SOLUTION: Even with fixed reporting templates, the vendor still maintains a HUGE workload in doing data cleaning. And as this process is done on vendor level, Vendor 2 will not benefit from any work done by Vendor 1. Now, as we already do conversions and mappings on products, customers, barcodes, currencies, postcodes and much more for a widespread customer base, we can do this centralized before the data reaches vendor level – effectively enabling all vendors to benefit from work done only once.

http://parseport.com/wp-content/uploads/2018/11/PARSEPORT-DIAGRAM-grey.png
http://parseport.com/wp-content/uploads/2018/11/LOGO-SMALL.png
Subscribe

It’s very simple. Join our small “nerdy“ community and become king of the office, with all our great info on XBRL, BI and much more.

ParsePort ApS

We know it sounds a bit geeky – but we are actually one of the leading suppliers of XBRL and BI solutions in the Nordics. We cover everything, whether it´s processing BI data or converting to XBRL, we can do it!

ParsePort

We know it sounds a bit geeky – but we are actually one of the leading suppliers of XBRL and POS solutions in the Nordics. We cover everything, whether it´s converting POS reports or XBRL accounting, we can do it!

Subscribe

It’s very simple. Join our small “nerdy“ community and become king of the office, with all our great info on XBRL, POS and offers.

Copyright by PARSEPORT APS. All rights reserved.