The migration was scheduled for Saturday night. Nobody profiled the data first. By Monday: 4,000 duplicate accounts, three date formats fighting over one field, and a free-text “Notes” column that turned out to contain credit card numbers. All of it was findable in advance. In about an hour. That hour is called data profiling. In […]
