| Course | |||||
|---|---|---|---|---|---|
 | Data Technician [Level 3] Understand the requirement and commitment needed for successfully completing this apprenticeship.
Know what is expected in sessions and in the workplace, what are typical data technician duties, and the importance and value of data to an... | ||||
 | Data Technician [Level 3] / 1.Data Foundations Data is a key driver of decision‑making in the modern workplace, helping organisations operate more efficiently and respond quickly to change. As businesses collect more information from their processes, customers, and systems, data roles such... | ||||
 | Data Technician [Level 3] / 1.Data Foundations Understand common Data Types. Identify the difference between Qualitative vs Quantitative Data. | ||||
 | Data Technician [Level 3] / 1.Data Foundations Files, Tables, Databases and Applications | ||||
 | Data Technician [Level 3] / 1.Data Foundations Identify internal/external/open data sources and evaluate fitness for purpose and limitations.
Understand methods of collecting quality data.
Skills; Design a method to collect data based on a set of requirements | ||||
 | Data Technician [Level 3] / 1.Data Foundations Apply cleansing techniques to improve data completeness and consistency. Learn key methods to manipulate data so that complete datasets can be created to perform further analysis on.
Features: Ranges, Validation, Cell referencing
Functions:... | ||||
 | Data Technician [Level 3] / 1.Data Foundations Apply cleansing techniques to improve data completeness and consistency. Learn key methods to manipulate data so that complete datasets can be created to perform further analysis on.
Features: Ranges, Validation, Cell referencing
Functions:... | ||||
 | Data Technician [Level 3] / 1.Data Foundations Conditional Formatting and Charts | ||||
 | Data Technician [Level 3] / 1.Data Foundations Data Governance, Legislation, Cultural Awareness and the need for Anonymising Data. | ||||
 | Data Technician [Level 3] / 1.Data Foundations Evaluate the advantages of relational databases over flat files and apply those principles to design an Entity Relationship Diagram (ERD) featuring entities, attributes, and primary keys.
Tools: Access, Excel |
