Creation of a dynamic dashboard for the financial management of a large group

Illustration of user interface

Context

  • Newly created business unit, implementation of a new complex organization with regional hubs (EMEA, America, Asia) and more than 50 markets
  • Urgent need for the CODIR to obtain a precise and consolidated vision of financial performance
  • Need for regional hubs to accelerate financial reporting so that the finance department can focus on financial analysis

Objectives

  • Design of a dashboard that is easy to update, shareable and usable by the CODIR and the different departments of the BU (Finance, Marketing, Sales)
  • Progressive implementation of the dashboard within the BU’s general management (consolidated data) and then within the various regional hubs (local accounting system). Multiple data source integration (e.g. sell-out)
  • Weekly iterations during workshops with end-users during the creation phase and training of the finance team to maintain the dashboard
  • Support to the IT team to develop a suitable source database

Deliverables achieved

  • Interactive and attractive dashboard replacing numerous Excel files
  • Monthly reporting time reduced to 2 hours (vs. several days)

Key success factors

  • Quick adaptation to client tools
  • Understanding of CODIR and departmental issues
  • Fluidity of exchanges with the customer

Tools used

  • JDE
  • Power BI

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