askMIH Home
Sales analytics & AI · Bangladesh

Your whole sales picture on one page. AI tells you what to do next.

The dashboard below belongs to a fictional agro-input company. Change the month and region, ask the AI a question. I build exactly this from your own Excel data.

Book a free 30-minute call See the demo ↓
DA

Demo Agro Limited · Sales overview

Up to 22 September 2026 · 19/26 working days
Fictional data
✦ Ask MIH
Sales (so far)BDT 1.51 crore▲ 6% vs the same point last month
Target achieved64%
Target BDT 2.38 crore
Month-end projection87%! Keep watching
CollectionBDT 1.30 crore86% of sales collected
Active dealers73 / 807 inactive for 21 days

Sales this month, day by day

lakh taka, cumulative

Sales so far BDT 1.51 crore. At this pace the month ends at BDT 2.07 crore, 87% of target.

✦ AI insights

generated from the data
! Forecast

At this pace the month will end at 87% of target. To reach 100% you need BDT 12.3 lakh a day across the remaining 7 working days; the current average is BDT 8.0 lakh.

✕ Lagging territory

Jashore is at 69% of target (projected). The biggest gap is Fungicide, where its share of sales runs 25% below the other regions.

! Receivables risk

Receivables older than 90 days stand at BDT 36.2 lakh, 13% of the total. 23% of that sits with just two SRs: SR-20 and SR-07.

✓ Opportunity

Fungicide is selling 25% more than the same point last month. The season is on, so check dealer-level stock. The biggest drop is Herbicide (−33%).

! Inactive dealers

7 dealers have not ordered in over 21 days (D-19, Rangpur; D-42, Khulna; D-50, Khulna …). Together they normally buy BDT 19.5 lakh a month.

i Dealer reliance

The top 20% of dealers (16 of them) bring in 57% of all sales. Losing one would hurt, so keep those relationships separate and warm.

Achievement by territory

% of target, month-end projection
✓ 100%+ ! 85–100% ✕ below 85% ┆ target line

Products: this month vs last month

lakh taka

Receivables ageing

lakh taka

Total receivables BDT 2.89 crore, of which over 90 days BDT 36.2 lakh.

Dealer concentration

how much comes from how many dealers

A steep curve on the left means heavy reliance on a few dealers. 80 dealers in total.

SR performance

click a column name to sort
SR-02BoguraBDT 6.5 lakh111%93%BDT 0.6 lakh109✓ On track
SR-24SylhetBDT 8.6 lakh110%89%BDT 1.5 lakh141✓ On track
SR-07DinajpurBDT 8.4 lakh104%82%BDT 3.9 lakh111✓ On track
SR-03BoguraBDT 6.9 lakh103%77%BDT 1.2 lakh144✓ On track
SR-14KhulnaBDT 6.3 lakh101%82%BDT 0.8 lakh152✓ On track
SR-08DinajpurBDT 7.6 lakh101%92%BDT 1.1 lakh110✓ On track
SR-05RangpurBDT 7.0 lakh101%90%BDT 0.8 lakh115✓ On track
SR-01BoguraBDT 7.8 lakh100%73%BDT 1.5 lakh109! Watch
SR-22SylhetBDT 5.9 lakh98%94%BDT 0.6 lakh97! Watch
SR-06RangpurBDT 8.2 lakh95%93%BDT 1.4 lakh101! Watch
SR-18BarishalBDT 7.0 lakh89%92%BDT 0.9 lakh130! Watch
SR-23SylhetBDT 6.1 lakh86%93%BDT 1.2 lakh141! Watch
SR-09DinajpurBDT 7.0 lakh84%75%BDT 0.8 lakh107✕ At risk
SR-15KhulnaBDT 4.8 lakh82%91%BDT 1.3 lakh108✕ At risk
SR-13KhulnaBDT 6.4 lakh81%86%BDT 1.0 lakh116✕ At risk
SR-04RangpurBDT 6.7 lakh80%94%BDT 1.8 lakh116✕ At risk
SR-21CumillaBDT 4.7 lakh75%73%BDT 0.7 lakh126✕ At risk
SR-16BarishalBDT 5.4 lakh74%80%BDT 1.8 lakh135✕ At risk
SR-17BarishalBDT 4.3 lakh73%82%BDT 1.4 lakh144✕ At risk
SR-11JashoreBDT 5.1 lakh71%76%BDT 2.0 lakh100✕ At risk
SR-20CumillaBDT 5.2 lakh69%74%BDT 4.4 lakh140✕ At risk
SR-10JashoreBDT 6.1 lakh69%96%BDT 1.9 lakh122✕ At risk
SR-19CumillaBDT 4.9 lakh68%91%BDT 2.0 lakh147✕ At risk
SR-12JashoreBDT 4.2 lakh67%95%BDT 1.6 lakh116✕ At risk

Seasonal pattern: last 12 months

low high

Each cell is that month’s sales in lakh taka. Insecticide and fungicide rise through the Boro and Aman seasons, seed through Rabi. Stock and targets should follow this rhythm.

Aman
Rabi
Boro
Aman
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Insecticide
56.4
38.3
45.1
62.0
76.0
82.4
71.5
47.4
42.4
54.7
68.1
75.8
Fungicide
50.4
33.8
34.1
42.6
53.2
62.5
58.1
36.0
27.4
37.5
50.3
62.9
Herbicide
19.0
22.2
33.9
40.3
31.7
23.6
17.9
18.0
27.0
43.9
37.5
25.1
Organic fertiliser
25.3
30.6
30.2
26.2
22.5
18.5
16.1
16.2
18.6
21.2
22.0
24.1
Seed
25.2
27.7
18.8
16.6
13.5
11.9
11.9
15.9
24.3
20.8
16.8
18.7
Micronutrient
13.9
13.0
13.0
14.8
16.5
18.4
16.7
14.2
12.7
14.7
16.0
17.8
Services

The dashboard above, built on your data

We can start with the Excel reports you already have. No new software to buy, and the dashboard works on a phone.

Sales dashboard

A one-page dashboard like the one above, with your territories, SRs and products.

  • Target vs achievement
  • Month-end projection
  • Receivables and collection

KPI & SFE

Clear rules and a scorecard for measuring the field team.

  • KPIs for SR, TSO and manager
  • Incentive calculation
  • Reporting workflow

Monthly review

A monthly data refresh and a one-page summary for management.

  • AI insight report
  • Comparison with last month
  • Team review meeting

AI sales agentComing soon

Ask in Bangla on WhatsApp and get an answer; dealers can place orders there too.

  • "How much did we sell today?"
  • Take dealer orders
  • A summary every morning
How I work

From first call to a live dashboard

The first call is free. I look at your data, then agree the scope and the cost.

  1. 1

    Free call

    Thirty minutes to understand your current reports and where they hurt.

  2. 2

    Agree the KPIs

    We pick together which numbers need to be seen every day.

  3. 3

    Dashboard goes live

    I build it on your data and train the team to use it.

  4. 4

    Monthly updates

    Data refresh and an AI insight review.

About

Md Imtiaz Hossain

Founder, Ask MIH

Focus
Sales Force Excellence (SFE), KPI frameworks, business intelligence and AI agents
Experience
Working in IT, software and sales operations since 2016, hands-on with agro-input and FMCG sales teams
Education
MS in Computer Science, East West University
Tools
Power BI, Looker Studio, SQL, Python, Excel, LLMs and AI agents

Want a dashboard like this on your own sales data?

Message on WhatsApp or send an email. The first 30-minute call is free, with no obligation.

WhatsApp+880 1880-181818
Emailimtiaz@askmih.com
Message on WhatsApp