Competency information
Details
Run queries to identify quality issues, including coding anomalies, incomplete data and general data inaccuracies.
Considerations
- Querying language.
- Manipulate, manage and quality assure data within a data set:
- variables – types, numeric formats, decimals, date and time, string
- data structure – selecting observations and variables, renaming and reordering, sorting, collapsing data, combining files.
- Data quality:
- principles: completeness, accuracy, validity, accuracy, timeliness, consistency
- standards
- Data validation.
- Data dictionaries, standards and coding.
Relevant learning outcomes
| # | Outcome |
|---|---|
| # 2 | Outcome Extract, import and manipulate data within a data set. |