Check all fields/tables are there (data spec attached detailing what we requested). Check that we have date & time for transactional data and what is the unique combination.
Check and the fields link together i.e. transaction ids from baskets tables links to the sales tables and to shops table. Are there any missing tables.
check the proportion of barcodes we have coded in barcode master and whether the descriptions from the data aligns with barcode master.
Look at any barcodes which don't match and get an idea of the value of these barcodes.
As we can't do a validation based on dump codes. Rank the value of the barcodes within this store. and output a spreadsheet of
store|barcode|number of transactions|description|sum of value|sum of units|Rank within store.
I can give you a better picture when i have access to the data spec file. Currently i was not able to see the files attached. So please share me the file and I can let you know how this can be done. I have done many automated reports in Knime using data filtration and analysis. Looking forward to your response. Once I get your full requirement, I can deliver the required output in 2 days as well. Looking forward for my first project!