Step 1 of 4

Act 1: Spot the Mess

Find data quality issues

โœ“ No SQL required
โœ“ No data engineering skills
โœ“ No waiting on your tech team

You're a RevOps Manager at a 200-person SaaS company. Your CRM has 8,400 contacts. Something's wrong with this data. Can you find the issues?

0 of 9 issues found

Click cells you think have problems

#contact idfull nameemailphonecompanytitle
11Alice Johnsonalice.j@stripeio.com+1-415-555-0101StripeVP Sales
22BOB WILLIAMSbob.w@hubspot.com 650-555-0200 emptyAccount Exec
33carol parkcarol@salesforce.com+1-212-555-0303Salesforceempty
44David Chend.chen@intercom.io+1-650-555-0404IntercomSDR
55Alice Johnsonalice.j@stripeio.com+1-415-555-0101StripeVP Sales
66Eva RodriguezEVA.R@ZENDESK.COM+1-415-555-0606emptyCS Manager
77Frank Lifrank@segment.io+1-510-555-0707SegmentAE
88Grace Kimempty+1-408-555-0808MarketoOps Manager

All 9 issues in this dataset:

Missed: Name is ALL CAPS โ€” should be Title Case
+4 XP
Missed: Phone has extra whitespace padding (' 650-555-0200 ')
+3 XP
Missed: Missing company name โ€” can't route to the right account
+6 XP
Missed: Name is all lowercase โ€” should be Title Case
+4 XP
Missed: Missing job title โ€” needed for segmentation
+3 XP
Missed: Entire row is a DUPLICATE of row 1 (Alice Johnson)
+9 XP
Missed: Email is ALL CAPS โ€” will fail case-sensitive lookups
+4 XP
Missed: Missing company name
+6 XP
Missed: Missing email address โ€” this contact can't be reached!
+7 XP