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.