Royal Caribbean International is known for driving innovation at sea and has continuously redefined cruise vacationing since its launch in 1969.
The end client, through its Data agency, wanted to enhance its customer datasets in Mexico and Chile containing more than 115,000 records in total in order to develop a more tailored member experiences.
We start running our Data Hygiene and Standardization service to all datasets with the following results:
For names, in this phase we had to split the input field “Name” into 4 new fields: Name1, Name2, Father “Apellido” and Mother “Apellido” according to the LATAM naming system.
We used 3 flags for the results:
For addresses we did the following process:
The last data process was enhancing the datasets with the following fields: