Data Cleaning Exercises

Pro exercise

Snapshots are not deltas

The warehouse sends a full stock snapshot every day. Yesterday's and today's files both list every SKU, so stacking them doubles the stock. Stock as of 30 June comes from the 30 June snapshot alone.

  • combining files
  • snapshots
  • grain

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.