Improve consistency and quality of the database
The data volume of the database is impressive! However, when trying to systematically using the data for analysis (e.g. for calculation of diverse footprints like CO2 or global hectar by the ingredients of a product) there are inconsistencies with respect to quantities (units etc.), categories, ingredients etc.
Is there a plan to improve the structure of the data model and is there an awareness that such an improvement would really boost the applicability of the data?
Such an endeavour would be long and painful, but it would definitely pay off. There are also proven methods like systematic database-refactoring to go along.
If there is an awareness for this issue within the project, I would like to share some of my ideas with someone who is involved in the data modeling. I am looking forward for some reaction!