SAP Modeling, Excel Integration & Intelligent Financial Automation Workshop
Venue: Sarova Stanley Hotel, Nairobi-Kenya
Date: 23rd - 5th December 2026
Cost: Kshs. 86,000 / USD 850
CPD points: 10
Overview
Connect your ERP and spreadsheets into one efficient finance engine with this two-week SAP modeling, Excel integration and intelligent financial automation workshop. The program teaches finance and ICT teams to extract SAP data, model it in Excel and Power Query and automate recurring financial reports and reconciliations. Participants will learn SAP financial data structures, report extraction, data modelling, automated workflows and controls. Through extensive hands-on labs, attendees will build automated financial reports they can apply at work. This program is essential for SAP finance users, accountants and financial analysts.
Objectives
- Navigate SAP financial modules and data structures
- Extract SAP reports and tables for analysis
- Model SAP data in Excel using Power Query and Power Pivot
- Build automated reconciliations and variance reports
- Create financial models linked to live ERP data
- Automate recurring reports with macros and refreshable queries
- Apply data validation and audit trails to automated outputs
- Visualize financial performance in dashboards
- Design a roadmap for intelligent finance automation
Target Audience
- SAP finance and controlling users
- Accountants and financial analysts
- Management accountants and budget officers
- ERP support and ICT staff
- Internal auditors reviewing ERP data
- Finance managers leading automation
Methodology
- Hands-on SAP and Excel labs
- Data extraction exercises
- Power Query and Power Pivot modelling sessions
- Automation build sprints
- Case studies of finance automation
- Dashboard development
- Capstone automation project
