-
Challenge 6 - Postcode Formatting
This challenge came from a question that I was asked recently. The user had a column of UK postcodes looking something like this: Input file: The challenge is to reformat these values based on strict requirements, and provide 2 new output fields containing: 8 byte format. All values are 8 characters. Examples of this…
-
New challenge ideas
If you have ideas for future challenges/puzzles/scenarios, please let us know as we're always looking for new ideas!
-
Challenge 5 – Fibonacci Sequence to X
The Fibonacci Sequence is the series of numbers 0, 1, 1, 2, 3, 5, 8, 13, 21, 34,.... The next number is found by adding up the two numbers before it. - the 2 is found by adding the two numbers before it (1+1) - the 3 is found by adding the two numbers before it (1+2) - the 5 is (2+3) - and so on! Despite seemingly…
-
Challenge 4 - Cleaning product (data)
Want to test your Aperture Data Studio skills a little more? This next challenge requires you to analyse the situation, compare the starting point to the destination state and figure out what functionality needs to be applied to navigate the journey. The sample data for this challenge is some messy product data: As you can…
-
Challenge 3 - It's a Date!
This latest challenge is all about dates. The sample dataset highlights a common challenge many of us are familiar with, which is around non-standard date formats (most often seen when working with data exports from mainframe systems or proprietary fixed width file formats). Have you ever tried running analytics on dates…
-
Challenge 2 - Title Casing Surnames
Does it bother you when you get mail through the letter box and your name is not presented with ‘standard’ casing? I did some work with a charity a few years ago and this was something they got a surprisingly high number of calls regarding. Long story short, they had a free-text form that their call center staff used to…
-
✏️ Challenge Index 🔍
Each month we're posting a new challenge for you to have a go at to test your data skills. Challenges will vary in difficulty, data domain and tasks category (e.g. data cleansing, matching, validation, preparation etc). This page has been setup to act as a single location from which you can easily find and search through…
-
Challenge 1 - Gender Title Mismatch Detection
This first challenge is concerned with identifying records that are displaying inconsistent information. The dataset (attached) for this challenge shows title, forename, surname and gender information and your challenge is to identify records where titles and gender fields provide conflicting information (e.g. Title is…
-
🏆 How to respond to challenges 🏆
Guidance When you've successfully completed a challenge. Make sure you post your solution so others can see. Also take a minute to have a look at the sample solution posted each week as well as the different approaches other members of the Community have taken in each challenge. When posting your solution, make sure to…
-
💡 Submit a challenge idea 💡
We love to hear challenge ideas from our Community members, so if you have an idea that you think would make a great challenge, please pop your idea in the comments below. We can work with you to suggest any changes for clarity or formatting. (If you already have a dataset in mind, please ensure that no personal…
