Data Shape

Propose a schema (tables, keys, relationships) that will give the dataset a logical home in SQL (or another structured system).

When to invoke

• Data is still in flat files / API dumps / spreadsheets and hasn't been loaded to a database.
• The current shape is denormalised, wide, or contains repeating/semi-structured content.
• User says "how should I structure this before loading?", "is this normalised?", "what tables should I have?".

Procedure