• English
    • Polish
Real-time analytics for best business decisions - Solwit | Software Development | Tests | Cloud Services

Real-time analytics for best business decisions

0 %

of data in the cloud

analytics in minutes

lightning-fast and clear reports

0 %

of data in the cloud

analytics in minutes

lightning-fast and clear reports

Important information

Client:

FarmaProm Polska Sp. z o.o. sp. k.

Sector:

Pharmaceutics

Looking for similar solution?

Farmaprom is a Business Solutions company providing its products in the fields of marketing, tutoring, analytics, and management to the pharmaceutics industry. It focuses on pharmaceutics retail and services. The company’s SQL database handles 85% of b2b transactions on the Polish pharmaceutical market. At some point the database reached its limits.

Challenge

The overloaded transaction database is impeding further business development.

The transaction database reached its capacity in collecting data. Due to the overload any analysis of its content required too much time and drained too much resources to be performed during a work day – it had to be done at night. Analysis of huge amounts of historical data was even more resource-intensive, making market forecasts impossible and business decisions much harder to make. Lack of technological expertise did not allow the company to efficiently manage the incoming data. With no ability to collect more data the expansion of the business and its client base would come to a halt. There was an immediate risk of the SQL database failing more and more, thus further investment in its maintenance would be wasteful.

Solution

Cloud-based data collection and analysis by means of BigQuery and PowerBI.

The analysis of the situation proved that it was necessary to find a new solution not only to provide additional collection and storage capacity, but also to efficiently analyze and visualize the collected data. Solwit suggested utilizing the potential of cloud technologies – we proposed to migrate the whole database to BigQuery and create an own Datalake. Thanks to PowerBI and developing a set of dedicated reports the data gained its clear visualization.

Result

A scalable database, real-time data analysis, and clear reports.

BigQuery made it possible to analyse both historical and the current data in real-time – in a matter of seconds, instead of many hours as it had been before. A new comprehensive Business Intelligence tool has been created to produce dedicated management reports. The owners of the companies serviced by Farmaprom were given the tools to quickly and effectively make decisions, as well as detect possible transaction mistakes.

 

Apart from scalability and powerful computing capabilities the cloud solution opened a spectrum of new possibilities to the client. Thanks to cognitive technologies, artificial intelligence and machine learning, it is currently possible to predict market behaviour, therefore, to assess the risks and chances in the long-term perspective.

About Farmaprom

Farmaprom is a Business Solutions company providing its products in the fields of marketing, tutoring, analytics, and management to the pharmaceutics industry. It focuses on pharmaceutics retail and services. It uses, among others, a Business Intelligence application – eTAP which integrates all the necessary information, such as sales data (CRM FarmaProm / exFactory / Sellin / Sell Out) and geolocation data from various systems, for use by its sales teams’ every-day work. What is more, Farmaprom maintains and updates daily the most detailed, commercially available database of doctors in Poland – more than 3000 people from more than 60 pharmaceutical companies use it every day. Finally, the company handles 85% of all b2b transactions on the Polish pharmaceutical market.

The solutions used

  • Google Cloud Platform, BigQuery

LEARN ABOUT OUR CLIENTS' SUCCESS STORIES