Product standards: how to reconcile them?
Simplify repository management with data reconciliation.
Obstacles to product standards
Our customer, a major player in the consumer credit market, wanted to offer a one-click online financing plan to all buyers of used vehicles.
Most used-vehicle sales partner sites use the Argus (and sometimes JATO) as their automotive reference frame, but the algorithms used to create our customer's financing plan were based on another reference frame: EUROTAX.
In order to enable private customers to receive their financing plan in a matter of seconds, it was necessary to establish a unique correspondence between entries in repositories that did not have a common key, and whose differences in vehicle descriptions made this correspondence non-trivial.
Reconcile product repositories with Tale of Data
Use of special special joins (designed by Tale of Data (approx. 100,000 entries per repository):
- Creation of a composite key for each repository by concatenating several fields (e.g. model, long version label, number of doors, year of commissioning, etc.).
- The composite key is matched with composite keys from other repositories that have the most "words" in common. In addition, words are weighted according to their rarity in the corpus of composite keys (principle: the rarer a word is in the corpus, the more credible the match).
- Elimination of multiple matches using so-called arbitration numerical fields (such as price incl. VAT or CO2 emission level): these fields are not standardized enough to be included in the composite key, but they are very effective for making a choice when a vehicle from one repository is matched with several vehicles from another repository. We'll take the one with the closest price and CO2 emission rate.
The benefits of reconciling product repositories
Thanks to the involvement of business experts (who have in-depth knowledge of automotive reference systems), the fields involved in the composite key, as well as the arbitration fields, have been optimally determined.
The rate of unique matches rose to :
- By 55% in the first approach, which consisted of asking the customer's Data Scientists to code string matching algorithms in Python, algorithms regularly rejected by the business for several months.
- At 95% in the composite key approach and business involvement proposed by Tale of Data
With the remaining 5% of multiple matches showing no significant difference in the financing plan generated, the Tale of Data approach was validated after one week by the customer's business teams.
Stay up to date with our latest exciting articles!
Explore our solutions tailored to your specific needs
-
What is an FAQ section?An FAQ section can be used to quickly answer frequently asked questions about your business. For example, "Do you offer delivery?", "What are your opening hours?", "How can I book a service?".
-
Why are FAQs important?FAQs are a great way to help visitors quickly find answers to common questions about your business, and to create a better browsing experience on your site.
-
Where can I add my FAQs?FAQs can be added to any page of your site or on your Wix mobile app.
-
D1. Data discovery : 2. Data nodes : 3. Datavisualisation (dataviz) : 4. Data scientist : specialist in Machine Learning and/or Deep Learning
-
E1. Registration :
-
What is data compliance?Data compliance is a process that identifies applicable governance for data protection, security, storage and other activities, and establishes policies, procedures and protocols to ensure that data is fully protected against unauthorized access and use, malware and other cybersecurity threats.
-
F1. Flow: processing graph built interactively by the user, enabling remediation, preparation and monitoring of data. A flow is by construction designed for production. 2. Flow Designer: interactive construction of processing pipelines.
-
I1. Artificial intelligence: a set of techniques that enable computers to simulate and reproduce human intelligence.
-
How do I add a new question/answer?To add a new question/answer, follow these steps: 1. from the Dashboard or Editor, click on the "Manage FAQ" button. 2. Click on "Add", then select "Question/Answer". 3. Choose a category for your question/answer. 4. save and publish. You can modify your FAQ at any time.
-
Can I add an image, video or GIF to my FAQ?Yes, to add media, follow these steps: 1. from the Dashboard or Editor, click on the "Manage FAQ" button. 2. Create a new question/answer or modify an existing one. 3. In the answer text box, click on the Video, Image or GIF icon. 4. Add the media from your library, then save.
-
How can I change or remove the "Frequently asked questions" title?From the Editor, go to the "Settings" tab in the FAQ. From the Wix Owner app, go to the Site and app tab.
