AI Assistant
Ask anything about DMS data in plain English
DMS AI Assistant
Online — DMS Intelligence Engine
Chat Sessions
Secondary sales this month Top 5 items this quarter MoM growth Purchase trends 6M Primary vs Secondary Top dealers
πŸ” Query Builder
πŸ’°
Secondary Sales β€” This Month
β€”
β€” invoices
πŸ“…
Current Month Value
β€”
vs previous month below
πŸ“ˆ
MoM Growth
β€”
Last month: β€”
Top Items This Quarter
Ranked by secondary sales value
Top Items β€” Detail
πŸ“Š
Select a staff member and click Refresh.
πŸ” Query Builder
Secondary Sales by Item
Billed quantity and value by SKU
Item-wise Breakdown
πŸ“¦
Click Refresh to load.
πŸ” Query Builder
Top Dealers
Dealers ranked by secondary sales value
Top Dealers by Secondary Sales
πŸͺ
Click Refresh to load.
πŸ” Query Builder
Category Distribution
Category Breakdown
🏷️
Click Refresh to load.
πŸ” Query Builder
Secondary Sales Trend
Month-over-month trajectory
Monthly Breakdown
πŸ“ˆ
Click Refresh to load.
πŸ“ˆ
Current Month
β€”
πŸ“‰
Last Month
β€”
πŸ“Š
Growth %
β€”
πŸ” Query Builder
Secondary Sales by Distributor
Top distributors shown
All Distributors
🏭
Click Refresh to load.
πŸ” Query Builder
Team Secondary Sales by Sales Officer
πŸ‘₯
Click Refresh to load.
πŸ” Query Builder
🌍
National Secondary Sales
β€”
πŸ“„
Total Invoices
β€”
🏭
Distributors Active
β€”
πŸ” Query Builder
πŸ›’
Purchase Entries
β€”
⏳
Pending
β€”
πŸ’°
Total Purchase Value
β€”
Purchases by Category
Distribution of purchase value across categories
Purchase Entries
πŸ›’
Click Refresh to load.
πŸ” Query Builder
Category Distribution
Category Breakdown
🏷️
Click Refresh to load.
πŸ” Query Builder
Purchase History for Item
πŸ“¦
Enter an Item ID and click Apply.
πŸ” Query Builder
Pending / Unmatched Purchase Entries
⏳
Click Refresh to load.
πŸ” Query Builder
Purchase Volume by Distributor
Top distributors
All Distributors
🏭
Click Refresh to load.
πŸ” Query Builder
Purchase Trend
Monthly total purchase value
Monthly Purchase Summary
πŸ“‰
Click Refresh to load.
Purchase vs Primary Sales Reconciliation
βš–οΈ
Click Refresh to load.
πŸ” Query Builder
🏒
Primary Sales β€” This Month
β€”
β€” invoices
βš–οΈ
Primary vs Secondary
β€”
Secondary: β€”
Primary vs Secondary Sales
πŸ” Query Builder
πŸ“„
Total Invoices (filtered period)
β€”
πŸ’°
Total Invoice Value
β€”
Daily Invoice Trend
Primary invoices over the period
Primary Invoices
πŸ“„
Click Refresh to load.
πŸ” Query Builder
Primary Sales by SKU
Top SKUs by primary inflow value
All SKUs
πŸ“¦
Click Refresh to load.
πŸ” Query Builder
Primary Sales by Distributor
Top distributors
All Distributors
πŸ—ΊοΈ
Click Refresh to load.
Primary vs Secondary Offtake Ratio
βš–οΈ
Click Refresh to load.
πŸ” Query Builder
Primary Sales Trend
Monthly totals
Monthly Primary Sales
πŸ“ˆ
Click Refresh to load.
🌍
National Primary Sales
β€”
πŸ“„
Invoices
β€”
🏭
Distributors
β€”
Distributor-wise National Primary Sales
🌍
Select a staff member and click Refresh.
πŸ’°
Secondary Sales
β€”
β€” invoices
πŸ“ˆ
SS Growth (MoM)
β€”
vs last month
πŸ›’
Purchase Entries
β€”
β€” pending
🏒
Primary Sales
β€”
β€” invoices
SS vs Purchases vs Primary β€” This Month
Cross-Comparison β€” Distributor-wise (All Modules)
πŸ”—
Select staff + toggle God Mode for full data.
πŸ‘₯ Group Analytics
πŸ‘₯ Group Results β€” β€”
Comparing across 0 users
Group Comparison
πŸ‘₯
Enter user IDs, select a flag, and click Run Group.
πŸ”§ Custom SQL Query
SQL
Query Results
πŸ”§
Write a SELECT query above and click Run Query.
AI Excel Report
Describe the report you want generated