AI-driven automation of the monthly Business Review presentation for a subsidiary of a major group

A monthly review powered by AI

Context

Finance department of a subsidiary of a major group seeking to save time on producing the monthly business review

Objectives

  • Automate the production of the business review (data collection, variance analysis, performance comments) in accordance with the template defined by the finance department
  • Reduce preparation time and the risk of errors to ensure the reliability and consistency of deliverables from one month to the next

Deliverables achieved

  • Skill for the automated generation of business reviews, capable of collecting and consolidating source data (P&L, operational KPIs, budget, actuals), producing variance analyses and drafting preliminary performance comments
  • A PowerPoint template for the business review, designed and approved in consultation with the finance department and business teams, incorporating the brand guidelines, slide structure and formatting rules for charts and tables
  • A repository of indicators and calculation rules (Excel file), developed in collaboration with management accounting: definitions of KPIs, data sources, alert thresholds and materiality criteria for variance comments
  • User guide for the skill, including the monthly update procedure, checkpoints and human validation steps prior to release

Key success factors

  • A framework based on the current business review preparation process, broken down step by step to identify what can be automated using AI
  • Supporting teams in designing a target template in collaboration with them
  • Configuration carried out directly within the client’s environment
  • Supporting teams in the implementation and use of the skill

Tools used

Skills copilot

Our other customer cases

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
Automated business plan modelling. Support for growth operations | Modeling of growth operations | Start-up and SME