Course Outline
Day 1: AI Fundamentals and Python with AI for Finance
AI, Analytics and Agentic AI in Modern Finance
- Understanding the distinctions between generative AI, machine learning, automation, and agentic AI, and identifying their specific roles in finance.
- Exploring finance use cases across accounting, FP&A, reporting, audit, treasury, and shared services.
- Determining which tasks are best suited for AI assistance versus controlled automation.
Python for Finance - Using AI as a Coding Partner
- Introduction to Python basics for finance professionals: variables, data types, conditions, functions, and notebooks.
- Leveraging AI assistants to generate, explain, debug, and refine Python code, moving beyond isolated coding practices.
- Applying prompting techniques to ensure reliable, finance-focused code generation.
Working with Financial Data in Python
- Importing Excel and CSV data using Pandas and DataFrames.
- Filtering, grouping, aggregating, and calculating key financial metrics.
- Utilising AI to explain errors, enhance logic, and document analysis steps.
Practical Finance Coding Applications
- Automating repetitive calculations, variance analysis, and ratio analysis.
- Creating reusable Python workflows with AI-supported code review.
- Validating outputs to ensure accuracy before use in finance reporting.
Hands-on Application
- Develop an AI-assisted Python workflow to analyse a sample finance dataset.
- Review generated code, test assumptions, and improve the output through human validation.
Day 2: Advanced Financial Data Analysis with AI
Financial Data Preparation and Quality
- Cleaning, validating, and standardising financial data.
- Addressing missing values, duplicates, inconsistent classifications, and date-related issues.
- Integrating data from multiple finance sources for comprehensive analysis.
Advanced Financial Analysis
- Analysing revenue, costs, margins, profitability, and working capital.
- Conducting budget versus actual, variance, and period-over-period analyses.
- Performing drill-down analysis to identify key financial drivers.
AI-Assisted Analysis and Anomaly Detection
- Using AI to investigate movements, patterns, and unusual transactions.
- Generating analytical questions and hypotheses directly from finance data.
- Distinguishing between useful signals and misleading AI-generated interpretations.
Forecasting and Scenario Analysis
- Examining historical trends, drivers, and assumptions for forecasting.
- Conducting what-if and sensitivity analysis to support financial decisions.
- Using AI to support scenario narratives while maintaining financial controls.
Hands-on Application
- Perform end-to-end analysis of a finance dataset to identify key variances and anomalies.
- Prepare a concise AI-assisted finance insight summary backed by underlying data.
Day 3: AI-Based Financial Dashboards and Management Insights
Finance Dashboard Design
- Selecting meaningful KPIs for finance, management, and operational reporting.
- Designing dashboards centred on decision-making questions rather than visual volume.
- Structuring views for executives, management, and analysts.
Building Interactive Financial Dashboards
- Connecting and transforming finance data for dashboard applications.
- Creating KPI cards, trends, variance visuals, drill-downs, and filters.
- Building views for budget versus actual, profitability, cash flow, and performance.
AI-Enhanced Dashboarding
- Using natural-language querying to explore financial data.
- Generating AI-assisted summaries and explanations of KPI movements.
- Leveraging AI to identify areas requiring deeper analysis.
Dashboard Controls and Reliability
- Considering data refresh, traceability, validation, and reconciliation.
- Managing access, sensitive financial information, and controlled distribution.
- Avoiding misleading visual or AI-generated conclusions.
Hands-on Application
- Build an interactive financial dashboard using a structured dataset.
- Add AI-supported management commentary linked to measurable financial movements.
Day 4: Advanced AI Tools in General Ledger and Finance Operations
AI Applications in General Ledger
- Analysing GL accounts, transaction patterns, and posting behaviour.
- Using AI to support transaction classification and account-level review.
- Identifying unusual, high-risk, or out-of-pattern entries.
AI for Reconciliations
- Matching records and identifying exceptions across finance datasets.
- Supporting bank, intercompany, and balance-sheet reconciliations.
- Prioritising unreconciled items for human investigation.
Journal Entry Analytics
- Detecting duplicate, unusual, and manual journals.
- Analysing period-end journals and generating supporting explanations.
- Establishing risk indicators and review checkpoints for finance teams.
AI in Financial Close and Reporting
- Prioritising close tasks and conducting exception-based reviews.
- Using AI to assist with variance explanations, commentary, and review notes.
- Implementing structured approval and validation before final reporting.
Hands-on Application
- Analyse a sample GL dataset to identify anomalies and reconciliation exceptions.
- Produce a controlled AI-assisted review summary for finance management.
Day 5: Agentic AI for Finance Operations and Decision Support
Understanding Agentic AI for Finance
- Defining the characteristics of agentic AI workflows: goals, planning, tools, memory, actions, and feedback loops.
- Identifying where agentic AI can support finance operations and where human approval remains essential.
- Differentiating between single-agent and multi-step or multi-agent finance workflows.
Designing Agentic Finance Workflows
- Creating agents for data collection, analysis, validation, and reporting tasks.
- Connecting agents to structured finance data and approved tools.
- Designing escalation rules, checkpoints, and approval boundaries.
Agentic Use Cases in Finance
- Implementing automated variance investigation and management commentary workflows.
- Handling GL exception triage, reconciliation support, and close-status monitoring.
- Refreshing forecasts, preparing scenarios, and supporting finance query assistants.
Governance, Risk and Controls for Agentic AI
- Implementing human-in-the-loop controls, audit trails, permissions, and segregation of duties.
- Addressing data confidentiality, hallucination risk, validation, and model limitations.
- Defining safe operating boundaries before production deployment.
Final Practical Capstone
- Integrate Python, AI, advanced analytics, and dashboard outputs into a single finance use case.
- Design an agentic workflow that analyses results, flags exceptions, and prepares management insights.
- Present the workflow, controls, outputs, and recommended next steps
Requirements
- A foundational understanding of finance, accounting, financial reporting, or FP&A concepts.
- Proficiency with Excel and experience working with financial datasets.
- No prior Python programming experience is required, though basic familiarity with data analysis is advantageous.
- Basic awareness of AI or generative AI tools such as ChatGPT, Microsoft Copilot, or Claude is beneficial but not mandatory.
- Participants should be comfortable working with financial reports, KPIs, budgets, variances, and related financial data.
- A laptop with access to the required training tools, datasets, and approved AI platforms must be available for practical sessions.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
the tips and recommended prompts that we can take away from this training