Flashcards · 9626 · A Level Topic 17

Data analysis and visualisation (A Level) flashcards

7 cards on A Level Topic 17. Pick a subtopic or study them all.

Study mode needs JavaScript. Every card is listed below, so you can still cover the answers and test yourself.

All 7 cards

For a quick read-through or printing. Cover the right-hand side to test yourself.

Cleaning vs transforming data: Cleaning fixes errors in the data. Transforming reshapes data that is already correct.
Splitting vs merging fields: Splitting turns one field into many, e.g. a full name into first name and surname. Merging joins many fields into one.
Comparing vs consolidating data: Comparing finds the differences between sources. Consolidating produces one combined data set from them.
Pivot table vs pivot chart: A pivot table holds the summary numbers. A pivot chart is a linked chart of them.
Pivot table vs SUMIF formulas: A pivot table is quick to rearrange and picks up new categories on refresh. SUMIF needs one formula per total but recalculates automatically.
Row or column field vs filter field in a pivot table: A row or column field groups the records. A filter field includes only some of the records.
Why must dates be stored as true dates, not date-like text?: Only a true date sorts in date order, groups by month and works in date calculations.