|
Based on our solutions, strategic decisions such as opening new branches are taken, or yearly direct marketing budgets are assigned, or critical investments are done for the expansion of specific segments, etc. We cannot take the risk that the information critically used in our recommendations systems is corrupted or do not show the true picture. This is the reason why we have invested a lot in designing tools, technology and methodologies for mastering data quality processes.
Our solutions use a combination of business rules, identified with the help of the business, and statistical processes which analyse the range of values for each variable, as well as their dynamic evolutions. The whole process is supported by a well-defined methodology, and proprietary software components for the automatic tracking of dynamic abnormal evolutions.
Data Quality processes are always an important part of other solutions, such as Lead generation, Customer Insight or Risk Mitigations, as shown in the above figure. However, we can also play a role in this area for improving data warehouses or datamarts.
Our services in this area cover the following:
-
Static Audit - This involves applying our QC Audit tool on a set of tables to analyse the value domain of each variable, and map their distributions to the expected business understanding (semantic). The Audit is analysed with the business and data experts so as to identify real problems, and to define a roadmap for corrections at the source processes level if possible.
-
Dynamic Audit - This involves applying our QC Audit tool on a set of tables to analyse the evolution of the value domain and distribution of each variable, and to automatically spot abnormal evolutions. This is a key process to ensure that changes occurring in the source systems are not generating unexpected and unknown effects on the decisional data. This Audit is analysed with the business and data experts so as to identify real problems, and define a road map for corrections at the source processes level if possible.
-
Business & technical dictionary - The Audits typically lead to an updated definition of the business understanding of the variables available to the users in their datamarts. Part of our assignment is to update and industrialise the business and technical dictionaries.
-
Industrialisation of Data Quality Processes - Once the Audits have been done, we can put in place processes that automate the audit controls and warn nominated users about any problems or unexpected deviations. These processes also include automated business rules to improve data quality (coherence, corrections, etc.).
|