Skip to content
PROGRAM 27 · TEAM TRAINING

AI & Data for FMCG & Retail Professionals

Sell through, not just sell in: AI for distribution, trade marketing and stores.

8 sessions3 modules4 hands-on projects3 days · 9 am–5 pmCertificate on completion
CHOOSE A FORMAT
Request a proposalSee the curriculum

Who this course is for

  • Sales managers, ASMs, TSOs and distributor teams
  • Trade marketing and category teams
  • Supply chain, demand planning and MIS staff
  • Teams in packaged food, beverages, personal care, superstores and retail chains

What your team will be able to do

  • Plan trade schemes, activations and sales communication in hours
  • Turn secondary sales and outlet data into clear reports
  • Plan stock for Ramadan, Eid and winter and spot stock-out risk
  • Deploy four working automations for your sales team
How it runs

3 days at your office, 8 sessions

Three sessions a day plus a hands-on build lab every afternoon. Day 3 ends with capstone presentations.

Day 1

9:00 am – 5:00 pm

AI chatbots for FMCG and retail work

9:00–10:30S1Prompt engineering for FMCG & retail
10:30Tea break
10:45–12:15S2Sales force & distributor communication
12:15Lunch & prayer
1:00–2:30S3Retail execution & store communication
2:45–4:30LABBuild lab: prompt library on your own files
4:30–5:00Q&A and day recap

Day 2

9:00 am – 5:00 pm

Sales data, then the first two builds

9:00–10:30S4Formulas & sales data cleaning
10:30Tea break
10:45–12:15S5FMCG analytics: sell-in, sell-out & stock
12:15Lunch & prayer
1:00–2:30S6Projects 01 & 02: Assistant & alerts
2:45–4:30LABBuild lab: dashboard, assistant and alerts on your data
4:30–5:00Q&A and day recap

Day 3

9:00 am – 5:00 pm

Last two builds and the capstone

9:00–10:30S7Project 03: Scheme claim workflow
10:30Tea break
10:45–12:15S8Project 04: Distributor invoice extraction
12:15Lunch & prayer
1:00–3:00LABCapstone build clinic
3:15–4:30LABCapstone presentations
4:30–5:00Certificates and next steps
Group: 10–40 people from one organisationSame content and projects in both formatsBangla delivery with English technical termsEvery session ends with a deliverable
Curriculum

8 sessions, one build in each

3 modules · 8 sessions · 4 hands-on projects

PART 1AI Chatbots for FMCG WorkSessions 1–3

Chatbot Landscape & Tool Selection

  • Gemini, ChatGPT, Claude, Copilot and DeepSeek: strengths for FMCG and retail work (sales tables, scheme letters, store audit notes, Bangla field messages)
  • Free vs paid tiers; a workflow that needs no international payment card
  • Bangla vs English output quality; when to draft in English and translate
  • Which tool for a long document, which for a formula, which for a polished letter

Prompt Engineering Fundamentals

  • What a prompt is; why the same question gives different answers
  • The four-part structure: role, context, task, output format
  • Role prompting: act as an area sales manager, trade marketing manager, demand planner or store manager
  • Controlling output: length, tone, language, table or bullet format

Advanced Prompting Techniques

  • Few-shot prompting: teaching the model with examples of your own FMCG and retail work
  • Step-by-step reasoning for multi-part tasks such as splitting a scheme budget across territories or planning Eid stock by distributor
  • Constraint prompting: what to include, what to exclude, what to never assume
  • Chained prompts: breaking a trade scheme (objective → mechanics → budget → communication → evaluation) into a sequence of smaller steps

Iteration & Prompt Library Building

  • Why the second prompt matters more than the first; refining instead of restarting
  • Diagnosing a bad output: vague instruction, missing context or wrong tool
  • Building reusable prompt templates for repeated FMCG and retail tasks
  • Testing a prompt before it goes into daily use

Data Privacy & Verification Discipline (Core)

  • What must never be pasted: distributor margins and credit terms, unreleased prices and launches, outlet owner phone lists, sales targets, supplier contracts
  • Anonymising data before prompting; safe vs unsafe FMCG and retail use cases
  • Hallucination awareness; verifying every figure, date, name and legal reference
  • The verification rule: AI drafts, a person checks before anything leaves the building
DELIVERABLEa personal prompt library of 10 templates for your repeated FMCG and retail tasks.
PART 2FMCG Data Analysis in Excel & Google SheetsSessions 4–5
PART 3Applied Projects: AI Assistants & AutomationSessions 6–8
Applied projects

Four automations, running in your organisation

01Session 6

Sales Policy & Scheme Assistant

TSOs, ASMs and distributor staff get answers from the distributor agreement, scheme circulars, price list and credit policy, with the section cited.

  1. INSchemes, price list & policies
  2. AIGrounded Gemini assistant
  3. OUTAnswer with the section cited
Built with Google AI Studio
02Session 6

Distributor Contract & Compliance Alerts

Distributor agreements, bank guarantees, scheme deadlines, listing contracts and batch expiries checked daily, with alerts 30, 15 and 7 days ahead.

  1. INContract & compliance tracker
  2. RUNDaily Make scenario
  3. OUTAlert to the right owner
Built with Make · Sheets · Gmail
03Session 7

Scheme Claim & Distributor Requests

Scheme claims checked against scheme rules and secondary sales, routed to the ASM, trade marketing and finance, with duplicate claims flagged.

  1. INScheme claim form
  2. RULESMake approval scenario
  3. OUTApproved claim in settlement log
Built with Make · Forms
04Session 8

Distributor Invoice & Order Extraction

Distributor orders, challans and invoices become clean rows, matched against the price list and scheme discounts, with orders above credit limit sent to the ASM.

  1. INOrders, challans & invoices
  2. AIGemini structured extraction
  3. OUTMatched rows in your sheet
Built with Gemini API · Drive

Capstone presentation

Each person presents one automation built for their own workplace.

Day 3 afternoon
Applied across every session

Responsible & Ethical AI in FMCG

Fairness & Non-Discrimination

  • Where bias enters FMCG and retail decisions: data, wording, criteria and past patterns
  • Proxy discrimination: address, age, gender or background inferred indirectly

Privacy & Data Protection

  • Data minimisation: collect only what the decision requires
  • Retention and deletion of retailer, distributor and consumer data

Fair Trade & Honest Selling

  • No misleading prices, weights, offers or health claims
  • Fair treatment of distributors and retailers in schemes and disputes

Accountability & Human Oversight

  • Human-in-the-loop by design: AI recommends, a named person decides
  • Who owns an AI-assisted decision when it is challenged

Workforce Impact & Your AI Use Policy

  • Talking to FMCG and retail teams about AI without triggering job-loss fear
  • Reskilling and role redesign as AI absorbs routine work
Outcomes

By the end, your team can

  • Choose the right AI tool and write prompts that work first time
  • Maintain a prompt library covering your repeated FMCG and retail tasks
  • Write scheme circulars, distributor letters and sales force messages
  • Produce store audits, category reviews and online product listings
  • Clean sales and stock data and build a distributor dashboard
  • Build and deploy automations with Make, Apps Script and the Gemini API
  • Apply fairness, transparency and privacy to every AI-assisted decision

And leaves with

A scheme circular, distributor letter and sales message set
A store audit summary, category deck and product listings
A distributor and territory dashboard you can defend number by number
A grounded sales policy & scheme assistant your colleagues can use
A distributor contract & compliance alert engine that reaches the right owner
Four deployed automations running in your own organisation
A written AI use policy for your own sales or retail team

Tools your team will use

Chatbots
ChatGPTGeminiClaudeCopilotDeepSeek
Content
CanvaGammaCapCutGoogle Slides
Data
Microsoft ExcelGoogle SheetsPower Query
Workspace
GmailCalendarMeetFormsDrive
Automation & AI builds
MakeGoogle AI StudioApps ScriptGemini API
FMCG tools
DMS and SFA exportsretail POS exportsDaraz seller centre

What participants need

  • A laptop with Excel and a Google account
  • Basic Excel comfort (VLOOKUP, Pivot Tables) and one month of sales or stock data
  • One real work file to practise on from Session 2
  • No coding background required; free tiers only

How your team will learn

  • build-along classes (you work while the trainer works)
  • practise on your own workplace file, not dummy data
  • every session ends with a deliverable
  • Bangla delivery with English technical terms
  • recordings, prompt library and setup guides
  • certificate after capstone submission
Request a proposal

Bring this program to your sales team

Tell us about your team. We reply within one working day with a plan built around your own documents and workflows.

  1. 1 · A short discovery call with your sales lead
  2. 2 · We tailor examples to your masked files
  3. 3 · Offline at your office, or online live classes
Chat on WhatsApp
Request a proposal