The primary challenge was to provide a sales forecasting analytics tool that offers an overview of the study’s findings as well as the predictive performance derived from these data and comparisons with existing medications and their statistical information.
The task was to implement the familiar Excel model in a web application. It was vital to discover a solution for an industrial approach, as opposed to a one-time scenario.
We have converted a huge mathematical model, which consists of 200k formulas and states, into a user-friendly application (web and mobile). To provide fast and comfortable usage of mobile devices, we have developed a math cluster that can support dozens of users in parallel mode. Besides this, we carried out Veeva CRM integration.
The team had to carry out the analysis of complicated mathematical models to create a computational engine and application that provides an intuitive interface for working with complex calculations. The solution was supposed to have the ability to create templates and reports.
The Forecasting model provides a full-fledged frame that allows working with Excel-like models without a vendor lock.
The solution also offers a new level of data visualization — using laptops and tablets users can change values without Excel and perform calculations as well.
- Support for all browser-enabled devices; no requirement for a desktop with robust functionality;
- Up to 120 times faster recalculation and generation of reports;
- The project has evolved into a product with 30+ models with custom user interfaces.