Five role-specific AI analytics programmes built for practising professionals. No coding background required for P1–P3 and P5. Programme P4 features the Claude + LangChain deep track for analytics engineers ready to build production-grade AI agents.
Every programme is built on the 10-Module Agentic AI Analytics Foundation and adapted for a specific professional role — so the tools, use cases, and capstone project speak directly to your day job.
Hands-on use of real AI tools — Claude, Power BI, LangChain, n8n, Zapier — applied to your professional domain from day one. No theory without practice.
No programming background required for P1–P3 and P5. You build working AI workflows using no-code and low-code tools throughout each programme.
Every programme closes with a role-specific capstone where learners build and present a fully functional AI-powered solution to a simulated panel.
| # | Module | Topics Covered | AI Tools |
|---|---|---|---|
| M1 | AI & Data Foundations for Finance3 hrs | AI/ML concepts in finance: forecasting, anomaly detection Data types: structured (ERP, Excel) vs unstructured (PDFs) Excel AI: XLOOKUP, Power Query, dynamic arrays Claude for Excel: natural language to formula Responsible AI in finance: accuracy, auditability |
Claude for ExcelMS Excel CopilotPower Query |
| M2 | Financial Analysis with AI5 hrs | Automated FSA: Income Statement, Balance Sheet, Cash Flow AI ratio analysis and peer benchmarking Variance analysis with AI commentary Trend identification and anomaly flagging AI-assisted analyst report from raw financial data |
Claude for ExcelClaudeBloomberg Intelligence |
| M3 | AI-Powered Forecasting & Modelling6 hrs | 3-statement model built with Claude for Excel AI revenue and cost driver modelling Scenario analysis: Bull / Base / Bear case toggle Sensitivity tables and Monte Carlo via natural language Cash flow forecasting with AI-generated commentary |
Claude for ExcelPython / Google ColabAnaplan AI |
| M4 | FP&A Automation with No-Code AI4 hrs | Automating monthly close and MIS reporting Power Automate flows for data collection and distribution Zapier: ERP data to Excel to stakeholder email Automated KPI dashboards from live data sources Zero-touch finance report scheduling |
Power AutomateZapierMakePower BI AI |
| M5 | Power BI for Finance Dashboards5 hrs | Financial data modelling: DAX fundamentals P&L, Balance Sheet, Cash Flow interactive dashboards KPI tracking: EBITDA, working capital, DSO AI visuals and smart narratives in Power BI Drill-through reporting for budget holders Power BI AI storytelling and executive summaries |
Power BI DesktopPower BI ServiceDAX StudioPower BI AI Visuals |
| M6 | Agentic AI for Finance Decision Support6 hrs | What are AI agents? Autonomous finance workflows Financial research agent using Claude LangChain basics: RAG over financial documents Agent: reads annual reports → outputs investment notes Multi-agent: research + model + report agents |
Claude (agentic)LangChainn8nCrewAI |
| M7 | AI Agents for Equity & MF Portfolio Building6 hrs | Value / Growth / Momentum investment philosophies Investor profiling: risk tolerance, time horizon, goals Equity screening agent: 3 philosophy-based filters MF portfolio: core-satellite construction with AI Portfolio monitor and rebalancing agent Automated weekly portfolio briefing and alert system |
Claude (agentic)Claude for Exceln8nLangChainPower BI |
| M8 | Capstone: AI Finance Command Centre5 hrs | Automated monthly finance pack: P&L, BS, CF, KPIs AI investor portfolio with rebalancing alert agent Power BI executive dashboard with live AI briefing AI-generated board briefing from model outputs Present to simulated board / investment committee |
All programme tools |
| # | Module | Topics Covered | AI Tools |
|---|---|---|---|
| M1 | AI & Data Foundations for Commercial Teams4 hrs | AI in marketing, sales, and CX: real-world use cases Customer data types: behavioural, transactional, demographic Data cleaning and prep with Excel and Google Sheets AI Introduction to Claude for marketing research and content Prompt engineering: CRAFT framework for commercial use |
ClaudeExcel CopilotGoogle SheetsHubSpot AI |
| M2 | Customer Segmentation & Persona Intelligence4 hrs | RFM analysis (Recency, Frequency, Monetary) with AI AI-powered customer segmentation from CRM data Building ideal customer profiles (ICP) with Claude Sentiment analysis on customer reviews and survey data Persona-driven content and offer strategy using AI |
ClaudePower BIExcel CopilotSalesforce Einstein |
| M3 | Lead Scoring & Sales Intelligence with AI5 hrs | AI lead scoring models: what drives conversion Lead scoring matrix in Excel with AI assistance Predictive pipeline analysis: which deals will close? AI-assisted call summaries and next-step generation Competitive intelligence using AI research agents |
ClaudeHubSpot AISalesforce EinsteinPerplexity AI |
| M4 | Campaign Analytics & Performance AI5 hrs | Marketing attribution: first-touch, last-touch, multi-touch AI analysis of Google Ads, Meta Ads, and email campaigns A/B test interpretation with AI commentary CAC and ROAS modelling with Claude for Excel AI-generated campaign performance reports |
Claude for ExcelPower BIGoogle Analytics 4Meta Ads AI |
| M5 | Customer Service AI & CX Automation5 hrs | AI chatbot fundamentals: intent, entity, workflow No-code customer service chatbot build Automated ticket classification and routing with AI Sentiment analysis on support tickets for CSAT improvement AI response templates and escalation logic |
ClaudeIntercom AIZendesk AIZapierMake |
| M6 | AI Content & Personalisation at Scale5 hrs | Generating personalised marketing content with AI Email sequence automation: personalised at scale Social media content calendar with AI scheduling Dynamic product recommendations using AI Personalisation engines: what they are and how to use them |
ClaudeMailchimp AIHubSpot AINotion AICanva AI |
| M7 | Agentic AI for Revenue Operations5 hrs | What is RevOps and how AI transforms it Sales pipeline AI agent using Claude and n8n Automated CRM updates and deal progression tracking Multi-agent: lead researcher + outreach writer + tracker No-code agent builder: your first RevOps agent |
Claude (agentic)n8nLangChain (basics)HubSpot AI |
| M8 | Capstone: AI Growth Intelligence Dashboard5 hrs | Unified dashboard: leads, pipeline, conversion, CAC, LTV AI-generated weekly marketing and sales briefing Agentic workflow: data to insight to action automatically CRM + Ads + Email unified intelligence system Present findings to simulated leadership team |
All programme tools |
| # | Module | Topics Covered | AI Tools |
|---|---|---|---|
| M1 | AI & Data Foundations for HR Professionals4 hrs | AI in HR: talent, engagement, retention, compliance People data: HRIS, ATS, payroll, survey, performance Excel for HR analytics: pivot tables, XLOOKUP, Power Query Introduction to Claude for HR writing, research, policy Ethical AI in HR: bias, fairness, GDPR, data privacy |
ClaudeExcel CopilotGoogle SheetsWorkday (basics) |
| M2 | Talent Acquisition Intelligence with AI5 hrs | AI-powered job description writing and optimisation Resume screening and shortlisting with ethical AI framework Candidate sourcing intelligence using AI research agents Interview question generation with competency mapping Offer letter and candidate communication automation |
ClaudeLinkedIn Recruiter AIHireVue (basics)Zapier |
| M3 | People Analytics & Workforce Insights5 hrs | Headcount, attrition, and tenure analytics in Excel / Power BI Diversity and inclusion metrics: how to measure and track AI engagement survey analysis and theme extraction Predictive attrition: identifying flight risk employees Compensation benchmarking with AI-assisted market data |
Claude for ExcelPower BIExcel Copilot |
| M4 | Performance Management & L&D AI5 hrs | AI-assisted performance review generation and calibration Goal setting with AI: OKR and KPI structuring Learning needs analysis with AI from performance data Personalised learning path generation using Claude L&D content creation: course outlines and materials with AI |
ClaudeNotion AIPower AutomateWorkday Learning (basics) |
| M5 | HR Operations Automation5 hrs | Automating onboarding workflows with no-code tools HR document generation: contracts, policies, letters at scale Leave and absence management automation Payroll query handling with AI chatbot HRIS integration with Power Automate and Zapier |
Power AutomateZapierMakeClaudeServiceNow (basics) |
| M6 | Agentic AI for HR Decision Support6 hrs | What are AI agents in an HR context? Talent research agent using Claude HR policy Q&A agent (RAG over HR documents) Workforce planning agent: headcount scenarios and cost impact Multi-agent: recruiter + screener + scheduler |
Claude (agentic)n8nLangChain (basics)Zapier |
| M7 | Capstone: People Intelligence Dashboard6 hrs | Power BI dashboard: headcount, attrition, engagement, D&I Automated monthly CHRO report from live HRIS data Agentic workflow: attrition risk alerts to line managers AI onboarding workflow end-to-end automation Present people insights to simulated CHRO and leadership |
All programme tools |
| # | Module | Topics Covered | AI Tools |
|---|---|---|---|
| M1 | AI & Agentic Analytics Foundations4 hrs | The analytics evolution: BI → AI-augmented → Agentic LLMs in analytics: Claude, GPT, Gemini — key differences What are AI agents? Autonomous reasoning, tool use, memory Claude's strengths: long context, analysis, safety LangChain overview: chains, agents, tools, memory, RAG |
ClaudeLangChainPythonJupyter Notebook |
| M2 | Advanced Prompt Engineering for Analytics4 hrs | Chain-of-Thought (CoT) prompting for data reasoning Role-Based prompting: Claude as your senior analyst Structured output: JSON, tables, reports from Claude Few-shot and multi-shot prompting for consistent output Building a prompt library for recurring analytics tasks |
ClaudeNotion AIPromptLayer |
| M3 | SQL & Data Intelligence with AI5 hrs | SQL fundamentals for analytics: JOINs, CTEs, Window Functions Natural language to SQL: use Claude to write complex queries BigQuery and PostgreSQL for business analytics AI-assisted data quality checking and anomaly detection Building an NL-to-SQL tool with Claude and LangChain |
ClaudeBigQueryPostgreSQLLangChain SQL AgentDB Browser |
| M4 | RAG: Making AI Know Your Business Data5 hrs | What is Retrieval-Augmented Generation (RAG)? Building a document Q&A system with Claude + LangChain Vector databases: Chroma and Pinecone basics Indexing business documents: reports, contracts, KPIs Deploying a RAG-powered business analytics assistant |
ClaudeLangChainChromaDBPythonGoogle Colab |
| M5 | Building Analytics Agents with Claude + LangChain6 hrs | LangChain agent architecture: ReAct, Plan-and-Execute Giving Claude tools: web search, calculator, SQL, Excel Multi-step reasoning: research → analyse → report Memory in agents: short-term and long-term context Building a competitive intelligence agent from scratch |
ClaudeLangChainTavily SearchPythonn8n |
| M6 | Multi-Agent Systems for Business Analytics6 hrs | What are multi-agent systems? Why they beat single agents CrewAI framework: roles, tasks, and crew orchestration Design pattern: Researcher + Analyst + Presenter agents AutoGen basics: conversational agent networks Building a full analytics crew for a business use case |
ClaudeCrewAIAutoGen (basics)LangChainPython |
| M7 | Power BI + AI Agents: Insight to Action4 hrs | Connecting Power BI data to Claude via API AI-generated narrative for Power BI dashboards Triggering agent actions from Power BI threshold alerts Embedding Claude insights into Power BI reports Business intelligence meets agentic AI: the full workflow |
Power BIClaude APIPower AutomatePython |
| M8 | Deploying & Governing AI Analytics Agents4 hrs | Agent safety: guardrails and hallucination mitigation Logging and audit trail for AI analytics decisions Governance frameworks for AI in business analytics Testing and validating agent outputs before production MCP (Model Context Protocol) for tool integration |
ClaudeLangChainMCPAnthropic API |
| M9 | Capstone: Enterprise Analytics Agent6 hrs | End-to-end agentic analytics system build Multi-agent crew: research + analysis + reporting + action RAG over domain-specific business documents Choose domain: Finance, Sales, Supply Chain, or HR Present: agent demo, architecture, governance, outcomes |
Claude + LangChain at core — all programme tools |
| # | Module | Topics Covered | AI Tools |
|---|---|---|---|
| M1 | AI & Data Foundations for Accountants4 hrs | AI in accounting: where it adds most value today Accounting data types: transactions, ledgers, invoices, statements Excel AI for accountants: XLOOKUP, dynamic arrays, Power Query Introduction to Claude for accounting: research, drafting, analysis AI ethics: accuracy, audit trail, professional standards |
Claude for ExcelExcel CopilotPower QueryQuickBooks (basics) |
| M2 | Bookkeeping & Transaction Automation5 hrs | Automating journal entry creation from bank data AI-powered invoice data extraction (OCR + AI) Bank reconciliation automation using Excel and AI Chart of accounts management with AI assistance Automated month-end bookkeeping checklist and workflow |
Claude for ExcelPower AutomateZapierXero AIQuickBooks AI |
| M3 | Accounts Payable & Receivable AI5 hrs | AP automation: invoice approval workflow with no-code AI AI-powered three-way matching: PO, GRN, Invoice AR automation: invoice generation and AI follow-up emails Debtor ageing analysis and AI-generated collection letters Cash flow forecasting from AP/AR data with AI commentary |
Claude for ExcelPower AutomateZapierXero AIMake |
| M4 | Financial Reporting & Period-End with AI5 hrs | Automated P&L, Balance Sheet, and Cash Flow preparation AI-generated management accounts commentary Variance analysis: budget vs actual with AI narrative Board pack automation: data to slides with AI narration Audit file preparation and documentation with AI assistance |
Claude for ExcelPower BIClaudePower Automate |
| M5 | Tax Compliance & VAT/GST Automation5 hrs | VAT/GST return preparation with AI-assisted calculations Corporation tax workings with Claude for Excel Automated tax compliance calendar and deadline reminders AI-generated tax planning memos and allowable expense guides HMRC / tax portal integration with Power Automate |
Claude for ExcelClaudePower AutomateZapierXero Tax |
| M6 | Audit, Risk & Compliance AI6 hrs | AI-assisted audit planning and risk assessment Automated transaction sampling and anomaly detection Control testing documentation with AI Internal audit report generation using Claude Regulatory compliance monitoring with AI alert systems |
ClaudePower AutomateCaseWare (basics)Excel Copilot |
| M7 | Capstone: AI-Powered Accounting Operations6 hrs | Automated bookkeeping: transactions to trial balance AI management accounts with variance commentary Power BI accounting dashboard for CFO / Board AP/AR workflows fully automated end-to-end Invoice to payment to reporting — zero manual steps |
All programme tools |
For professionals who want to lead in the AI era.