How do I analyse price elasticity of demand with iDBQuery?

Price elasticity measures how much demand moves when you change price. Knowing it helps you set prices that maximise revenue rather than guessing. iDBQuery lets you explore it directly against your own transaction history.

• You'd ask iDBQuery: 'For SKU 4471, plot average selling price against weekly units sold over the last two years, and estimate the price elasticity of demand.'
• It aligns your pricing and sales tables by period, computes the percentage change in volume for each percentage change in price, and returns a scatter or trend chart with the elasticity figure.
• Each observation is cited to its source rows, so you can verify the price and volume behind any point.

This is a directional, data-grounded read rather than a controlled experiment, and iDBQuery is transparent about the SQL it ran so an analyst can refine the method. Follow-ups are easy: 'Compare elasticity for premium vs budget lines' or 'Exclude promotional weeks.' Because price lists, costs, and sales often live apart, the one live model joins them so you can immediately layer margin on top: 'At what price does contribution margin peak?' The Analyst agent can test several price bands and report which one your history suggests is most profitable, with the rows to back it.