Global

Data analysis code for analysts: Cleaning, reproducibility and responsible data collection

A ready-made course you customise for your organisation, with a live session deck and two surveys. You only add the 8 details that are specific to your organisation.

See the live deckSee the full outline
Try the coursePreview the survey
Length
45 min
Lessons
6 lessons
Frequency
At onboarding of analysts
Last reviewed
21 Oct 2026
Transforming and summarising
What would you do?

A table of orders is grouped by region and summed; a missing region name hides 200 orders

Try it: this is one of 17 interactive activities in the course.

What's included

Three pieces that work together

Copy once, get everything. Learners prepare on their own, you answer questions live, and the surveys tell you what stuck.

Self-paced course

Short lessons with real workplace scenarios, not walls of text.

  • 6 lessons, about 45 minutes
  • Process, sorting activity, scenario, timeline and quizzes

Live session deck

An AhaSlides presentation to run after the course, in person or online.

  • 10 slides
  • Quiz, poll, ranking, word cloud slides
  • A closing slide for your contacts

Two surveys

Find out what landed, and whether people use it on the job.

  • Post-course feedback, about 2 minutes
  • 30-day check-in
  • Anonymous by default
  • Results feed your next refresher

Learning objectives

At the end of this course, learners can

Each objective and the lesson that covers it.

IDObjectiveSourceWhere it's covered
TO 338.0Achieve ≥ 80% on the final assessment-Whole course
SO 338.1Load a dataset and find missing, duplicate and inconsistent values before analysing itBest practice; DAMA-DMBOK data quality [check before build]Whole course
SO 338.2Transform and summarise data and predict what a short data-frame call returnsBest practiceWhole course
SO 338.3Make an analysis reproducible: fixed inputs, documented steps and a re-run that gives the same resultBest practiceWhole course
SO 338.4Decide whether collecting data from an external source is allowed, and what must be checked first + your infoGDPR (check applicability); EU DSM Directive text-and-data-mining exceptions [check before build]Whole course
SO 338.5Report results with the data caveats the reader needsBest practiceWhole course

Your part: what a template can't do for you

  • Your workplace details: fill in the 8 highlighted fields so the course describes your own policies, contacts and locations.
  • Records: record completion in your own LMS or record system.

Course outline

6 lessons, about 45 minutes

Minutes per lesson are an estimate, shared out by page count.

ContentInteractiveVideoYou customise
1

A dashboard built on dirty data

3 pages

8 min
Before you beginNoteList
The sales dipTextImage
What went wrongTimelineQuiz
2

Loading and cleaning data

3 pages

8 min
Cleaning stepsProcess
What is wrong with this table?Sorting activity
CheckFlashcardsMatching quiz
3

Transforming and summarising

3 pages

8 min
Group and summariseTabs
Predict the resultScenarioQuiz
CheckMulti-select quiz
4

Making analysis reproducible

3 pages

8 min
The checklistChecklist
Spot the problemScenarioQuiz
StyleNoteYour info
5

Collecting external data responsibly

3 pages

8 min
Before you collectAccordion
May we?Sorting activity
Raise it earlyProcessYour infoKey fact
6

Reporting and final assessment

2 pages

5 min
ReportingTableQuiz
PracticeQuizKey factNoteButtonYour info

Live deck and surveys

10 slides to run live, two surveys to close the loop

Pink slides are interactive. Both surveys are anonymous; pink questions are written for this course.

ContentTitle, agenda, "bring a dataset you cleaned by hand
PollHow do you clean data today?
QuizCleaning removes 3,000 of 12,000 rows. First step? (Check why ✔ · Publish · Remove more · Ignore)
Content · customiseCleaning steps and the reproducibility checklist {{ENGINEERING_STANDARDS_LINK}}
RankingOrder a safe analysis: load, inspect, clean, compare counts, summarise, document
QuizA site's terms forbid automated access. Best move? (Stop and ask first ✔)
Word cloudThe dirtiest dataset you have met
ScaleHow confident are you re-running an analysis from scratch?
Q&AAsk the trainer anything
Content · customiseClosing {{HELP_CONTACT}}, {{COURSE_URL}}, {{SURVEY_2_URL}}
Post-course feedback: 11 questions, about 2 min
  1. Overall rating 5 stars
  2. Relevant, realistic, right length, helpful activities agree/disagree grid
  3. What was most useful? multi-select
  4. Confidence before this course, and now 1-5 scale
  5. Confidence in cleaning · transforming · reproducibility · collection rules · reporting caveats grid
  6. Can someone else re-run your last analysis? multiple choice
  7. Which data source do you most want checked before use? short text
  8. I can say ‘I am not sure we may collect this’ without feeling judged. 1-5 scale
  9. One thing we should change or add open text
  10. Would you recommend this course? NPS
30-day check-in
  1. Have you used what you learned since the course? multiple choice
  2. How confident are you today? Compare with day 1 1-5 scale
  3. Do you know where to find the analysis standards and the data collection approval route? yes / no / not sure
  4. A moment where the training helped, or where you weren't sure open text
  5. Which topics should the next refresher focus on? ranking

Results show whether people use the training on the job, not just whether they finished it.

Make it yours

8 fields to fill in, and you're ready

Everything else is done. These are the details only your organisation knows; each one is highlighted inside the course.

  • Link to the engineering standards or style guide{{ENGINEERING_STANDARDS_LINK}}
  • Privacy or data protection contact for collection questions{{PRIVACY_CONTACT}}
  • Where completion is recorded{{LMS_OR_RECORD_SYSTEM}}
  • Link to the post-course and 30-day survey{{SURVEY_2_URL}}
  • Who to ask for help or to report a concern{{HELP_CONTACT}}
  • Link to the self-paced course{{COURSE_URL}}
Show all 8 fields
  • List of approved tools and versions{{APPROVED_TOOLS}}
  • Link to the baseline survey{{SURVEY_1_URL}}

FAQ

Common questions

Can I run data analysis code for analysts: Cleaning, reproducibility and responsible data collection training online?

Yes. The course is self-paced and online, and the live deck lets you add a live session in the room or online.

How often is this training needed?

At onboarding of analysts, and before a team moves analysis from spreadsheets to code.

Who needs this training?

Analysts, BI developers, marketing and research teams and new data-team hires; run by data leads with L&D.

What records should I keep?

Record completion in your own LMS or record system, so you can show who finished the course and when.

Can I edit the content?

Yes, everything. Change the wording, swap scenarios for ones from your workplace, add your logo, or remove parts that don't apply.

Related templates

Often taught together

All Data and automation templates →
Global

Database design, normalisation and data integrity for developers

Developers · Data and automation

40 min
Global

SQL for business analysts: Pulling and checking your own data

Analysts and operations · Data and automation

45 min
Global

Python for business automation and data scripts

Finance · Data and automation

45 min
Global

Scripting and automation for IT and business: Shell, powershell, bash and VBA

Sysadmins · Data and automation

40 min
Last reviewed: 21 October 2026Templates are a starting point, not legal advice.

Ready to run it?

Open the live deck to see how the session runs alongside the course and both surveys.

See the live deck