Question

Question 9
The owner of a local landscaping business just acquired the customers from another landscaping business where the owner retired. Both owners had created their own databases containing customer information, including names, phone numbers, and services requested. The new owner wants to combine this customer data into a single, unified database so that they have everything in one place. However, there might be duplicates like customers who used both services and inconsistencies like differences in how names or phone numbers are entered in the data. What is the most important step to take before the new owner starts analyzing customer data for marketing campaigns?


Design attractive visualizations for presenting the combined data.



Develop targeted marketing campaigns for the new customer base.



Use VLOOKUP to merge the customer email addresses.



Data mapping to standardize, merge, and clean the data from both databases.


1 point
1

Answer 1

Data mapping to standardize, merge, and clean the data from both databases.

You must clean and standardize (resolve duplicates, normalize formats, map fields) before analyzing so marketing decisions are based on accurate, unified customer records.