Let me ask you a question about importing data into the BI database for Tableau

A customer of a beverage manufacturer sells beverages through retail outlets

Pull data from sales support tools, etc.

I want to see daily results, weekly results, monthly results, etc.

In the current sales support tool, product keys are implemented using JAN codes.

Since JAN code is reused, it is an issue

-In some cases, the JAN code for the same product is changed or the linked statistical product code is changed.

In some cases, it becomes impossible to link with past figures.

- Products that are originally separated, such as roses and 6-packs, are also aggregated

Therefore, for product identification, it is assumed that crediting processing that unifies with a different product code instead of the JAN code will be required.

However, although we have product codes other than JAN codes, the product codes other than JAN codes are not unified in the system,

is an issue

By clarifying how much the numerical value will be affected if the results are linked with the JAN code,

I think we can narrow down the range of which system product codes should be unified.

Could you give me some advice on this matter?