LAVastro
Excel

Data Cleaning Project

Damir B.
#excel#data#salesforce#sap

Client: US Telco
Year: 2022-2023

We were tasked to do a project related to cleaning the data from Salesforce and aligning it with the financial data. The project had to be approached carefully due to this data being used as a basis for paying out commissions to partners. The project covered:

  1. Exporting data from Salesforce and aligning it with financial data
  2. Using fuzzy logic for connecting part of the records
  3. Assigning unique keys across all the systems
  4. Validating the data with partner data
  5. Team coordination

[Top]

← Back to Projects