What each row means
One row per product SKU. Compare a movement-based expected closing quantity with an independent count.
Fields, units and validation
Read data-dictionary.txt before calculations. Keep integer money in cents; quantities/counts are whole nonnegative values. Treat identifiers as labels. Preserve the original input and log transformations.
Known controls
Expected closing by SKU14,15,13,2,11,40; counted 14,14,13,2,11,40. P02 difference-1; all other differences 0. Total expected 95, counted 94.
Reuse and attribution
Created by DataCareerHub; permission is granted to use and adapt these fictional fixtures for learning and portfolios with acknowledgement. They are not real clients, employers or commercial results. Do not replace them with confidential records.
Suggested independent extension
Create a second synthetic period with documented assumptions, predict the control totals and challenge your implementation. Clearly distinguish your invented extension from the original fixture.
Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.