Data Analytics Internship

Data Analytics Internship · Module 2 of 4 · 2 weeks

Cleaning and Structuring Data

Build a clean, repeatable dataset.

Workplace scenario

Facility names and dates are entered inconsistently across files.

Weekly activities

  1. Week 3

    Cleaning

    • Standardise names, dates and codes
    • Remove duplicates with a cleaning log
  2. Week 4

    Structure

    • Combine files into one table
    • Add validation to the data-entry template

Practical assignments

  • Produce a clean master dataset and cleaning log

Supervisor-guided tasks

  • Spot-check cleaned records against sources

Supervised internship work. Choose this specialization when you register.