Improvement of the CSR reporting process of a large group

11

Context

  • Annual production of a summary of the group’s CSR performance (HR, societal, energy, etc.) with multiple and complex steps

Objectives

  • Deletion of a Power BI report without real added value in order to keep only one technical solution in Excel
  • Implementation of consistency checks during the process
  • Integration of new CSR indicators
  • Improvement and acceleration of the entire production process

Deliverables achieved

  • Excel model using Power Query including:
    • Automatic transformation of data from the dedicated tool
    • Analyses required for CSR reporting
    • Data consistency checks
    • A simple user guide
  • Accelerated production of analyses
  • Better data quality control throughout the reporting process by subsidiaries

Key success factors

  • Good knowledge of Power Query in Excel
  • Good understanding of CSR reporting issues
  • Long-term support for the client in his assimilation of the new tool

Tools used

  • Excel, Power Query

Our other customer cases

AI-driven automation of the monthly Business Review presentation for a subsidiary of a major group | Automation of tasks and processes using AI | Mid-cap and large group
AI-driven automation of analytical code cleaning during the month-end closing process for a medium-sized enterprise | Automation of tasks and processes using AI | Mid-cap and large group
Performance assessment and operational turnaround of an investment. Operational restructuring and special situations | Assessment of
stress factors and identification of levers for recovery | Funds
Support for a court-ordered sale, corporate restructuring and the sale of an SME. Operational restructuring and special circumstances | Design and implementation of a recovery plan | Start-ups and SMEs
Support with the restructuring and sale of an SME. Operational restructuring and special situations | Design and implementation of the recovery plan | Funds
Analysing the profitability of an investment. Modelling and performance analysis | Profitability analyses | Fund