A desk-booking tool and inter-corporate solution for storing and managing employee data in one place. It allows companies with 1000+ employees to take full advantage of the hybrid work model and is friendly in use to both employees and HR managers.
CPG Data. Development of a custom sales analytics platform
The development of an extensive sales analytics platform with a variety of modules aimed at facilitating the work of distributors and maximizing their performance.
Customer
CPG Data
Target Audience
Retailers
Pain
Manual data collection, slow report generation, insufficient analytics.
Solution
Sales analytics portal to facilitate report generation and optimize workload of sales representatives and store managers in retail.
Challenge
In 2003, Emerline was contacted by a company working with distributors of drinks and beverages and was asked to create a platform and mobile application that would facilitate their work by allowing them to upload pictures directly into the system, so it would be easier to recognize where certain products are displayed, and in what quantities. But the development didn’t end there, because the customer wanted to extend the product’s capabilities with more possibilities for analytics, new modules, features, and UI elements. As for today, the sales analytics platform still sees constant enhancements and has already gained the status of the industry-leading application.
Product Description
The client was provided with a solution that offers a variety of modern features that make a sound sales analytics platform capable of reducing supplier data analysis time from several hours to just 22 seconds.
Key features
- Centralized sales data management
- Mobile accessibility
- Real-time updates and monitoring
- Online data sharing
- Intuitive UI and interactive dashboards
- Data Visualization
- Pipeline Management
- Tracker execution
- Historical execution analytics
- Advanced exporting features
- Identification of mutually supporting brands
Approach
General
For 17 years of the product’s existence, the backend, frontend, and DevOps technologies used for the creation of the application have been changing. This allowed keeping the portal up-to-date, robust, secure, and easy-to-use.
Backend development
Initially, the portal’s backend was developed with Python 2.7, Django 1.6, and MySQL database. Later, these technologies were replaced with more modern ones: Python 3.8, Django 3.0, and the PostgreSQL database. Other backend highlights included the use of Celery for scheduled jobs and task concurrency, and Websockets used for the updates of the progressbar.
Frontend development
The frontend of the application was initially based on a JavaScript library - Jquery, that was later replaced with ReactJS.
Integration Services
The portal was integrated with multiple data providers, including SAP (HTTP API), SFTP servers, and Rest API.
DevOps
In terms of DevOps, initially used EC2 machines were replaced with the following mixture: Kubernetes cluster + Gitlab CI/CD process + Grafana monitoring visualization.
Result
As a result of complex development, the delivered sales analytics platform features everything needed for efficient, convenient, and well-organized performance. The platform created by the Emerline team has gained the status of the industry-leading application, allowing the client to get a sharp competitive edge and stand out from other companies working with distributors of drinks and beverages. Furthermore, meeting the growing needs of the industry, the platform constantly develops and gets enriched with new innovative features.
Customer review
No project overview is complete without incorporating the customer's perspective. Discover the impact and value of our solution through the eyes of those who benefit from it the most.
More Case Studies
Oomnitza
Smart asset management platform for optimizing IT asset management in the companies big and small. It lets businesses monitor and manage all IT assets across company facilities, schedule equipment replacements, and automate routine tasks
GoDog
A customized dog training and walking plan in an app that helps you keep it well-behaved, fit, and happy
The individuals we work with aren't just contractors, they are an important part of our strategic Team and we enjoy working with them every day!
Emerline has been our technology partner since late 2012. In the early years I thought that would be a short-term gap fill until I could afford to hire my own technical team in the US. But they have consistently met the demands of our growing company and helped us build what we believe is the industry's best solution option. Emerline provides high quality work, so much so that our platform's reliability and accuracy has been mentioned by our largest customer's internal vendor survey repeatedly. The individuals we work with aren't just contractors, they are an important part of our strategic Team and we enjoy working with them every day!
President/CEO, CPG Data
country
USA
company
CPG Data
project summary
Extensive sales analytics platform aimed at facilitating the work of distributors and maximizing their performance.
solution category
Analytics and Reporting Software
industry
Supply Chain Management