Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Day 1: AI Fundamentals and Python with AI for Finance
AI, Analytics, and Agentic AI in Modern Finance
- Distinguishing between generative AI, machine learning, automation, and agentic AI, and identifying their specific roles within finance.
- Exploring finance use cases across accounting, FP&A, reporting, audit, treasury, and shared services.
- Determining which tasks are suitable for AI assistance versus those requiring controlled automation.
Python for Finance: Using AI as a Coding Partner
- Essential Python concepts for finance professionals, including variables, data types, conditions, functions, and notebooks.
- Utilizing AI assistants to generate, explain, debug, and refine Python code, moving away from isolated coding practices.
- Developing prompting techniques for 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 finance metrics.
- Leveraging AI to explain errors, improve 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
- Constructing an AI-assisted Python workflow to analyse a sample finance dataset.
- Reviewing generated code, testing assumptions, and refining outputs through human validation.
Day 2: Advanced Financial Data Analysis with AI
Financial Data Preparation and Quality
- Cleaning, validating, and standardising finance data.
- Addressing missing values, duplicates, inconsistent classifications, and date discrepancies.
- Integrating data from multiple finance sources for comprehensive analysis.
Advanced Financial Analysis
- Conducting revenue, cost, margin, profitability, and working-capital analysis.
- Performing budget versus actual, variance, and period-over-period comparisons.
- Utilising drill-down analysis to pinpoint key financial drivers.
AI-Assisted Analysis and Anomaly Detection
- Employing AI to investigate movements, patterns, and unusual transactions.
- Generating analytical questions and hypotheses directly from finance data.
- Differentiating between useful signals and misleading AI-generated interpretations.
Forecasting and Scenario Analysis
- Analyzing historical trends, drivers, and assumptions to inform forecasting.
- Executing what-if and sensitivity analysis to support finance decisions.
- Using AI to support scenario narratives while maintaining strict financial controls.
Hands-on Application
- Performing end-to-end analysis of a finance dataset to identify key variances and anomalies.
- Drafting 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 focused on decision-making questions rather than excessive visualisation.
- Structuring views for executives, management, and analysts.
Building Interactive Financial Dashboards
- Connecting and transforming finance data for dashboard integration.
- Creating KPI cards, trends, variance visuals, drill-downs, and filters.
- Developing views for budget versus actual, profitability, cash flow, and performance metrics.
AI-Enhanced Dashboarding
- Using natural-language querying to explore financial data.
- Generating AI-assisted summaries and explanations for KPI movements.
- Leveraging AI to identify areas requiring deeper analytical investigation.
Dashboard Controls and Reliability
- Considering data refresh, traceability, validation, and reconciliation requirements.
- Managing access, sensitive financial information, and controlled distribution.
- Avoiding misleading visualisations or AI-generated conclusions.
Hands-on Application
- Building an interactive financial dashboard using a structured dataset.
- Adding 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 reviews.
- 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 journal entries.
- Analysing period-end journals and generating supporting explanations.
- Defining risk indicators and review checkpoints for finance teams.
AI in Financial Close and Reporting
- Prioritising close tasks and conducting exception-based reviews.
- Using AI for variance explanations, commentary, and review notes.
- Implementing structured approval and validation before final reporting.
Hands-on Application
- Analysing a sample GL dataset to identify anomalies and reconciliation exceptions.
- Producing 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 agentic AI workflows through goals, planning, tools, memory, actions, and feedback loops.
- Identifying where agentic AI can support finance operations and where human approval is critical.
- Distinguishing 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.
- Applying agentic AI for GL exception triage, reconciliation support, and close-status monitoring.
- Utilising agentic systems for forecast refreshes, scenario preparation, and finance query assistance.
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 prior to production deployment.
Final Practical Capstone
- Integrating Python with AI, advanced analytics, and dashboard outputs in a single finance use case.
- Designing an agentic workflow that analyses results, flags exceptions, and prepares management insights.
- Presenting 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 necessary, 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.
- Comfort with navigating financial reports, KPIs, budgets, variances, and related financial data.
- Availability of a laptop with access to the required training tools, datasets, and approved AI platforms for practical sessions.
35 Hours
Testimonials (1)
the tips and recommended prompts that we can take away from this training
