Use cases
Standardizing data from heterogeneous sources
Discover how our solution for standardizing data from heterogeneous sources simplifies the management and integration of information from different sources, for better quality and a unified view of your data.
The need
Unify formats, structure information and ensure the reliability of critical repositories
Our customer, a major player in the passenger and freight transport sector, wanted to reduce the time spent - several weeks, even months - gathering the input data required to complete a project.
The customer's Data teams therefore began designing an intranet portal where internal project managers could find the data they needed to complete their projects in just a few clicks.
The problem: each department producing potentially reusable data published an information sheet on this data in a specific format. As a result, there were several hundred formats.
The portal's raison d'être was to enable cross-functional searches, i.e. searches on datasets produced by different departments. The harmonization of data sheets was therefore an essential prerequisite for the success of the portal project.
Our solution
Intelligent, automated consolidation of multi-source data
Establishment of a single format for the MSDS.
Format import: Tale of Data uses the target format to automatically suggest to the user the data transformations required to switch from the current format to the target format.
Use of Tale of Data by the customer's Data team to create, for each input MSDS format, the lists of data transformations required to obtain an output MSDS.
Automation of the entire process: every day, new MSDSs are deposited by the various departments on the customer's private cloud (Microsoft Azure). Tale of Data retrieves these MSDSs and automatically applies the corresponding transformations (depending on the originating department and the nature of the MSDS).
Once in pivot format, the records are deduplicated, then sent by Tale of Data to the portal (via API), where they are indexed and made available for search.
Benefits
Clean, centralized data ready for use throughout the organization
Tens of millions of euros saved thanks to a dramatic reduction in start-up times for new projects.
The portal is now systematically used by project managers to gather the data they need for their projects.
The rate of data reuse has risen sharply, with a significant reduction in the number of datasets purchased from external service providers, as the project manager had no way of knowing that they were already held by the company.
The standardization of locations (construction sites, warehouses, depots, etc.) enables precise geospatial searches to be carried out on datasets on the portal.
The risk of failure has been greatly reduced, as projects can be launched more quickly and with the right input data.
Product benefits
Integrate
Seamless integration of AI and No-Code technology for efficient data refinement.
Collaborate
Collaborate across teams to ensure complete data quality.
Shareable
Go beyond data transformation scripts for a readable, shareable project.
View
Move from the "black box" of scripting to an intuitive, documented visualization of all your data transformations.
Powerful
Use powerful dashboards to simplify analysis and drive continuous improvement.
Quality
Achieve superior data quality faster and at lower cost, while demonstrating the tangible value of investing in data excellence.
Intuition
Get a complete, intuitive visual representation of the data journey, from raw data to finalized data products.
Organized
Align your organization with data quality initiatives.
Aligned
Easily align your business with ever-changing regulatory requirements.
Ready to improve your data quality?
Join leading companies that are improving the reliability, compliance and efficiency of their data.