1. File formats and encodings
Inventory all three supplied sources. Count data records and inspect the first header for a byte-order mark. Explain why products.json and the planning CSV cannot simply be appended to order rows.Write your answer in learner_worksheet.txt and retain the evidence file. Attempt this before opening the solution.
Your method:
Your result and evidence:
Limitations:
Independent extension:


2. Data types and analytical grain
Write dictionary entries for line_id, order_id, quantity, unit_price_eur and order_date. Classify L005 repeated with a changed quantity and O001 repeated across two lines. State which quantity may be summed.Write your answer in learner_worksheet.txt and retain the evidence file. Attempt this before opening the solution.
Your method:
Your result and evidence:
Limitations:
Independent extension:


3. Build a source inventory and dictionary
Complete both templates and write three questions for a real source owner. Add a row-count reconciliation rule, date rule and key rule. Explain whether a zero May sales figure is defensible.Write your answer in learner_worksheet.txt and retain the evidence file. Attempt this before opening the solution.
Your method:
Your result and evidence:
Limitations:
Independent extension: