Take a look at our challenges.
The Data Quality Community is a great place to collaborate, seek answers, and learn Aperture Data Studio. Register for free to join in with discussions.
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…
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…
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…
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…
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…
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…
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…
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…
