The review originally appeared on Clutch
The Estyl.pl online store has existed since 2004. It is one of the first online stores in Poland and the fastest growing in the industry of professional hair, body and nail cosmetics as well as various accessories and hairdressing equipment. It offers over 4,000 products from over 90 brands. He has over 350,000 completed orders and tens of thousands of satisfied customers.
Along with the dynamic development of our company and the increasing number of products in our offer, we noticed the need to implement advanced analytical tools that would help us manage reports, e.g. coverage margin report and sales records.
To determine the profitability of sales, we obtain information on product prices from various sources: online price comparison websites, producer price lists, and our own sources. We needed a tool that would automatically collect this data in one place and quickly allow us to define our own pricing policy.
We started with researching analytical tools and systems available on the market. We considered Snowflake, Power BI and BigQuery. We spoke with partner representatives of these technologies. Solwit prepared a dedicated system demo for us using BigQuery and Google Cloud Platform. We knew that they had experience in the implementation of such projects, including for the pharmaceutical industry. After comparing the offers, knowledge and experience of our partners, we decided on the solution proposed by Solwit.
The aim of the project was to obtain business reports allowing to increase the profitability of the company. So far, a team of analysts was involved in generating reports, which took up to several days to prepare the list. We wanted to see these reports faster in order to be able to make the right business decisions on an ongoing basis, depending on the changing market situation.
We needed an advanced analytical tool that would analyze information from various sources quickly and unattended. We wanted to implement the project without major investment expenditures. The rapid development of the company meant that information on the profitability of products introduced to our online store’s offer has become a key element of management documents.
We wanted to consciously make commercial decisions. The margin predictions have a significant impact on the future of the business, which is why we decided to implement an advanced analytical system. We considered various technologies. Solwit recommended a solution based on Google Cloud Platform and BigQuery.
After watching a dedicated demo prepared by Solwit, we decided to implement this project. A system was created that automatically and periodically downloads data from many external systems. An unquestionable advantage of this solution is the lack of limitations in the number and type of data sources.
Previously, collecting data took several days, because it was done manually by our employees, and the preparation of reports integrating the data took up to several hours. Today, we receive transparent dashboards presenting structured data from Data Studio in a second, without involving the working time of people responsible for analytics.
As part of the project, our main analyst was trained in the field of Google Cloud Platform and BigQuery, thanks to which we can make changes on an ongoing basis. The simple handling of resources in the cloud by our employee allows us to develop the tool on our own.
Today, the system quickly transfers data to BigQuery, with low infrastructure maintenance costs. After implementing the system that allows us to analyze the most important data today, we decided to extend our cooperation with Solwit with new orders in the area of data analytics.
On the part of Solwit, the following persons were involved in the project: GCP architect, GCP engineer and Project Manager. Data analysts and business stakeholders participated in the project on the client’s side.
After just three months of cooperation with Solwit, we have implemented a satisfactory analytical tool in the assumed budget, which allows us to quickly generate reports. In cooperation with Solwit, we develop this tool by adapting it to the changing business environment. We did not incur any financial outlays related to infrastructure and licenses. All data is collected and processed in the GCP cloud.
The team showed great knowledge and experience, as well as flexibility and openness to our business needs.
Marcin Moska, E-Commerce Project Manager, estyl.pl
We evaluate the cooperation with the Solwit team very positively. At the beginning of our cooperation, we learned what the reporting implementation process looks like and we were trained in the use of GCP.
During the project, we received all the information, and each of our ideas was analyzed and implemented by Solwit, if possible. The team showed great knowledge and experience, as well as flexibility and openness to our business needs.
Tell us exactly what you need.
Let's set the priorities and the order in which your software's functionalities / features / changes will be implemented.
What is the estimated timeframe for when you need to have your solution ready?
