Conversational insights on governed data for a pharmaceutical manufacturer

The challenge

Commercial reporting existed, but insight reached leadership only when someone opened or built a dashboard. KPI monitoring was reactive. Sales-force effectiveness data sat apart from commercial and market data, and metric definitions drifted between teams and spreadsheets. Business users depended on analysts to translate questions that mixed English and Urdu.

What we built

• A governed semantic layer in the analytics platform over the enterprise data cloud, so every number has one certified definition.
• Leaders subscribe to digests of commercial, sales-force and market KPIs.
• A conversational agent queries the published, certified data source rather than the warehouse, so it inherits the certified definitions and stays aligned with the dashboards.
• Restricted metrics isolated by audience and mandatory business filters encoded in the agent contract, with separate agents for internal sales and market data.
• The agent understands business vocabulary that mixes English and Urdu.

The results

• 65% of routine KPI questions are self-served by digests and the agent before they reach the reporting team.
• A multi-day report cycle became one governed conversational exchange.
• Prompt caching and iteration caps cut the cost per question by 90%.