FinderKGet started

Cleaning a data set

Fixing errors, gaps and inconsistent formats in a data set so it is ready for analysis.

Good work shows: Standardises formats for dates and names; removes or flags duplicates; keeps a log of every change made.

Cleaning a data set is one of the data skills on FinderK.

The job simulations and Skill Paths below include work that is checked for this skill. You do the work in an original fictional company and get feedback on it.

Job simulations

The repeat rate that fell by half

Data analyst at Kibble and Co

About 70 minutes. Included in Plus.

The dashboard says repeat purchases have halved since June and marketing wants 50,000 pounds to win customers back. Check what the number measures, find out what changed in June and what is incomplete, and tell the board what the data really says before it spends the money.

Skills: Check what a measure means before trusting its trend; Separate a mix effect and incomplete periods from real change; Combine rates correctly from counts; Write a board note that leads with the answer; Disagree with a colleague's figures constructively

Skill Paths

Related careers

All skills

Create your free FinderK account