Cleansing data coming from a human resource management system
The HRMS Export dataset corresponds to an Excel file that
has been exported from an American human resource management system (or
HRMS).
It contains the full list of employees since the creation of the company with their name, job title, hiring date, departure date if any and bank information for their salary. In this dataset, the dates are in the American date format and you want to transform them to the French date format so that they can be used with French software solutions. Also, you want to extract the account number from the IBAN number for the French accounts.
Download the file: HRMS_export.xlsx.