###################################################
Methodology
###################################################

This sequence diagram illustrates the process of identifying root causes of data issues, developing corrective actions, implementing preventive measures, continuously monitoring, testing and validating remediated data, and updating policies and procedures to ensure data quality sustainability.

.. image:: ../_static/img/dqf-sustainability-sequence-diagram.png
   :width: 90%
   :alt: Sustainability Sequence Diagram
   :align: center


|

The sequence diagram demonstrates the steps for addressing root causes and implementing preventive measures in data quality management. The process begins with the Data Quality Analyst identifying the root causes of data issues. The Data Quality Team and Data Stewards then develop long-term corrective actions. Data Stewards and Data Engineers implement preventive measures, followed by continuous monitoring and review by the Data Quality Team. 

This table presents a sustainability methodology, ranging from the identification of the causes of data problems to update policies and procedures. He describes the roles, the necessary actions, the prerequisites and the expected results at each stage, offering a clear roadmap to improve and maintain the quality of the data.
|

.. image:: ../_static/img/dqf-sustainability-methodology.png
   :width: 90%
   :alt: Sustainability Methodology
   :align: center

.. raw:: html

    <p style="text-align: center;font-style: italic;font-size:12px">Sustainability activities</p>
    <br/>


.. -----------------------------------------------

.. .. image:: ../_static/img/dqf-analogy.png
   :width: 50
   :alt: Plane logo
   :align: center


.. 1. **Root Cause Analysis:**
.. At an airport, data quality analysts perform in-depth analysis of the causes of identified ticket issues. They use techniques like the “5 Whys” or Ishikawa diagrams to determine why problems occurred. For example, they may discover that input errors when booking or systemic issues in the ticketing software are causing the problems.

.. 2. **Long-term Action Planning:**
.. After identifying the root causes, the data quality team and airport managers develop long-term action plans to correct these causes. This may include policy changes, updates to IT systems, and improvements to data entry processes, to prevent similar problems in the future.

.. 3. **Preventive Measures:**
.. The management team implements preventive measures to avoid the recurrence of problems. For example, they can introduce system improvements to automate ticket verification, implement additional checks during booking, and train staff to reduce human errors.

.. 4. **Monitoring and Review:**
.. Data quality teams establish continuous monitoring processes to track data quality and the effectiveness of preventative measures. They use monitoring systems to quickly detect any new anomalies and regularly review data to ensure that improvements are effective and that problems do not recur.

.. 5. **Verification:**
.. Data quality analysts and quality managers perform testing and validation to ensure that remediation actions have effectively resolved issues. For example, they can verify that reprinted tickets are correct and that process changes have been implemented correctly.

.. 6. **Policy and Procedure Updates:**
.. Based on the analyzes and implemented measures, the data governance team reviews and updates the airport's policies and procedures. They formalize changes in ticket management policies and standard operating procedures to ensure improvements are integrated into daily practices.