Excel to excellence for Kennect

Kennect calculated sales incentives for the pharmaceutical industry using cumbersome, time-consuming Excel spreadsheets. The manual process bred inefficiency and a steady stream of field-force queries, as discrepancies and errors were common.

Kennect envisioned a tool that could make incentive calculations as simple as pushing a button. The challenge was twofold: build a system that could handle the complex, often Byzantine rules of pharma sales incentives, and make it so user-friendly that everyone would willingly make the switch.

We built a comprehensive platform that automated the entire incentive calculation process, engineered on top of an ETL platform we had already delivered for Kennect so the whole system stayed seamless and robust.

• An intuitive dashboard for creating and managing incentive schemes.
• Flexible criteria-setting tools to handle even the most complex rules.
• A bird's-eye view of the entire organisation's incentive structures.
• Scenario modelling to experiment across multiple years.
• An interface that felt as familiar as Excel, to make the switch effortless.

• UX designed to help users transition from Excel and adopt the new platform without difficulty.
• Incentive calculations cut from a month to a single week.
• Architecture that let Kennect scale operations quickly and serve far more clients.

Quantitative benefits

• Client base grew from 3 to over 20, including AstraZeneca, Sanofi and GSK.
• Incentive calculations completed in one week, a 75% reduction from the previous monthly cycle.
• 100% return on investment achieved within a year of project completion.
• Significant growth in Kennect's pharma-sector market share.