Data governance is a subject that affects all companies nowadays. The challenges are multiple, it is necessary to know how to centralize data, manage access rights, keep a history of changes, manage governance and be able to present this data to employees to help them in their work.
Data management is a subject that affects all companies nowadays. The challenges are multiple, it is necessary to know how to centralize data, manage access rights, keep a history of changes, manage governance and be able to present this data to employees to help them in their work.
The goal: centralize and govern data
There are a multitude of solutions, data warehouses, data hubs, data lakes and PIM (product information management) on the market. These solutions are often complex to use, often requiring extensive training or the implementation of large infrastructures, which are not always relevant to start this type of project. If you start with a blank sheet of paper, it is often easier to develop a solution that will be quickly in the hands of users and will evolve precisely according to their needs.
In addition to the functions of this type of platform, our client needed to format this sometimes complex data for all of the company's employees, i.e. over 7,000 people. It was also necessary to be able to generate reports and manage the centralization and integration of data from different systems in order to eventually become the one and only source of truth.
A technological challenge: centralizing various data sources
One of the main challenges of such a product is the collection of information. Indeed, over the years, needs have multiplied and so have the solutions, many of which are not based on the same technologies or logic (presence or not of unique product identifiers, separation into divisions, etc.). We had to create a solution capable of synchronizing hundreds of thousands of data from different data sources (SAP, Oracle databases, API, API Soap, scrapping, external site, etc.) and extracting the right information each time. The updating of this data is also a central point, each type of data has a precise lifespan and is therefore updated when necessary.
This collection is only the first step, it is also necessary to be able to restore them in a simple, clear, effective and graphic way. For this we provided our expertise in UX & UI to guide the business experts in their choice of display.
The size of our client's company and the importance of such a project involves many decision makers and stakeholders, aligning them all on a clear vision and objective was a challenge in itself.
The solution: a custom centralized database
Since the launch of this project, we decided to involve the business experts as early as possible in the various workshops in order to reduce the problems of change management as much as possible. Moreover, by conducting these workshops together, it is also easier to achieve team cohesion and share the same product vision, despite the differences and user profiles.
The involvement of users from the beginning of the project allowed us to understand precisely what their needs were, it was then easier to define priorities, either on the functional or on the technical and structural evolution of the platform.
After more than five years of evolution, the implemented solution has become the "source of truth", it is the central point to retrieve information but it is also the one that feeds internally a dozen of other systems, some of which are critical for the good functioning of the company.
A project in constant evolution for more than 5 years
When the project was launched more than 5 years ago, the scope was limited to only two divisions of our client. Since then, it has evolved, 2 new divisions have been integrated, numerous functionalities have been added and the project is in continuous evolution. In 2021, a new version of the interface is implemented.
To date, it allows sales teams and business experts to find products and all their information simply and directly via their web browser, smartphone and tablet.