Advanced Analytics Tool for an Online Drugstore
Project Title: Advanced Analytics Tool for an Online Drugstore
Client: Estyl.pl
Industry: Retail, Media & Services
Expertise: Data Managment & AI
Scope of the project: Implementation of an analytics tool integrating data from multiple sources
Tools: Google Cloud Platform, BigQuery, Data Studio
A data integration analytics tool is a system that automatically collects, processes, and analyzes information from various sources, such as price comparison platforms, manufacturer price lists, and internal databases. In the context of an online drugstore, it enables the rapid generation of reports on sales, margins, and pricing strategies, supporting informed business decision-making.
ALTEN Polska (formerly Solwit) assisted Estyl.pl in developing an advanced analytics system to automate the generation of business reports. The primary goal was to simplify data analysis processes and optimize strategic operations.
The project required the use of cloud technologies to enable fast processing of large datasets from various sources. The client needed a solution that would deliver high performance and flexibility while maintaining low operational costs.
ALTEN Polska’s Role
ALTEN Polska’s team was tasked with designing and implementing an analytics system capable of integrating data from multiple external sources into a single platform. The client sought to reduce the time required for report preparation and automate analytical processes, enabling quicker business decision-making. A key requirement was ease of use and the ability for the client to independently enhance the tool.
Project Execution
The project began with a detailed analysis of the client’s needs and an evaluation of available technologies. ALTEN Polska proposed the use of Google Cloud Platform and BigQuery, supported by a dedicated demo. Once the concept was approved, the system was implemented to automatically gather and process data from various sources, such as price comparison websites, manufacturer price lists, and internal databases.
Simultaneously, the client’s lead analyst received training on GCP and BigQuery, enabling independent management and development of the system. With ALTEN Polska’s support, the implementation proceeded on schedule without requiring additional infrastructure resources.
Final Outcome
The implemented solution enables the generation of detailed reports in real time. Analytical processes that previously took several days were automated, saving significant time for the client’s team. Clear dashboards in Data Studio now present structured data, supporting pricing strategies and offer optimization.
By leveraging Google Cloud’s low-maintenance infrastructure and capabilities, Estyl.pl significantly reduced operational costs. The new system became a foundation for strategic business decisions, enhancing the company’s overall efficiency.
Conclusion
The project delivered by ALTEN Polska allowed Estyl.pl to streamline analytical processes and improve profitability. The client appreciated the team’s flexibility and expertise, which led to an extension of the collaboration into additional analytics projects.
