Competency information
Details
Import data into software which allows further data analysis, e.g. R, SQL.
Considerations
- How Open Database Connectivity (ODBC) connections can be used to transfer data between applications.
- Importing data:
- Import and Export Wizard
- SQL insert, update, delete.
- Parsing data (e.g. XML and JSON formats).
- Principles of and drivers for the automation of routine tasks.
Relevant learning outcomes
| # | Outcome |
|---|---|
| # 2 | Outcome Extract, import and manipulate data within a data set. |