3.2 Methods of Transforming Data

3.2.1 Know and understand methods of transforming data

Manipulating Data
Manipulating data involves changing the structure, format, or layout of data so it can be used more effectively.

Examples:
  • Sorting records into a specific order
  • Filtering data to show only relevant entries
  • Removing duplicate records
Analysing Data
Analysing data involves examining data sets to identify patterns, trends, or relationships that support decision‑making.

Examples:
  • Identifying peak system usage times
  • Detecting unusual activity for security monitoring
  • Comparing performance metrics over time
Processing Data
Processing data involves applying rules, formulas, or instructions to convert raw data into meaningful information.

Examples:
  • Calculating averages or totals from raw figures
  • Converting sensor readings into status alerts
  • Generating reports from operational data