Monitored the performance of the sales team and improved its marketing strategy for the cattle feed business through interactive dashboards built by leveraging data across multiple sources.
Challenge
Our client is a leader in the animal feed business with 70%+ contribution to the portfolio through their cattle feed division.
The client currently operates across India with a field force of 250+ employees. The requirement was to expand their presence and network of distributors and dealers.
For this, the client developed a new application through Bizom which captures information related to lead generation and tracking, order and supply tracking, etc. This application is primarily used by the field team.
The client wants to leverage the existing SAP data along with the latest SFA data to provide quantitative insights for the sales team.
Solution
Think Analytics defined the key matrix and KPIs, in collaboration with the client ,which should be tracked for various business users to provide meaningful insights.
To help the clients on their journey, we created a data mart through which the data for different sources could be ingested and modeled for automated syncing and updating the reports.
We defined user-access management to limit the data view based on role-level need and security. Further, we also developed interactive dashboards with drill-down provisions for micro-level monitoring.
We also created automated PDF emailers using Selenium and deployed visualization using Power BI.
Impact
We successfully reduced the effort per man month by 10 days, by referring data from multiple sources and providing the relevant information in one view.
With our expertise in interactive dashboards, we enabled the client to understand the root cause of the problem and improved the TAT for resolution. This allowed the leadership to plan market activities and strategies.
