Which distributors exceeded credit period?
Product by Nepal Data Labs
Plain questions. Controlled SQL. Explainable answers.
Dataforge maps business language to approved schemas, query controls, source tables, and answer evidence.
DataforgeQuestion to evidence
Distributor aliases, credit-days metric, approved tables.
14 distributors exceed the configured period.
View SQLSource tablesApplied filters
Questions
Ask without table names.
What were total sales last month?Compare this quarter against last quarter.Which distributors caused the decline?Which products are below safety stock?Which accounts have overdue balances?
Product Preview
Question in. Evidence out.
Dataforge answer
Three distributors need review based on overdue balance, credit period, and recent payment behavior.
3Priority accounts
Generated read-only query
SELECT distributor, region, risk_level
FROM dealer_credit_view
WHERE overdue_days > credit_days
ORDER BY overdue_balance DESC
LIMIT 10;| Entity | Segment | Priority |
|---|---|---|
| Aster Trade | Pokhara | High |
| Himal Supply | Biratnagar | Medium |
| Metro Dealer | Kathmandu | Medium |
Sourcedealer_credit_view
DefinitionOverdue = outstanding invoice beyond approved credit period.
ControlRead-only access against approved reporting data.
Predicted follow-ups
Evidence Standard
Every answer needs a trail.
Fast answers are useful. Visible evidence makes them usable.
Original intent
Terms to schema
Generated query
Tables and filters
Authorized answers
Context preserved
Conversation
Follow-ups keep context.
Ask DataforgeShow sales by region
Answer
Top regions ranked by sales for the selected period.
5Regions returned
Sourceregional_sales_summary
SELECT region, SUM(net_sales) FROM regional_sales_summary GROUP BY region ORDER BY 2 DESC LIMIT 5;Business Context
Business words become data logic.
cust_idCustomer
dist_cdDistributor
outstanding_amtOutstanding Balance
sku_qtyInventory Quantity
credit_daysCredit Period
Architecture
Trace the answer path visually.
Each block shows one decision point in the Dataforge workflow.
Answer Types
Readable. Inspectable. Reusable.
Direct textual answerKPITableChartTrendComparisonBreakdownSupporting data
Answer Evidence
See how each answer was produced.
Answer14 distributors exceeded their 60-day credit limit.
Sorted by overdue balance and current open invoices.
Generated SQL
SELECT distributor, region, outstanding_amt
FROM approved_credit_view
WHERE credit_days > 60
ORDER BY outstanding_amt DESC;Generated SQLSource viewFiltersTime rangeMetric definitionSupporting rows