Real-time analysis of pharmaceutical market data

0 %

of transactions
in the cloud

analytics
in minutes

lightning-fast and clear reports

0 %

of transactions
in the cloud

analytics
in minutes

lightning-fast and clear reports

Important information

Client:

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

Sector:

Healthcare & Life Sciences

Looking for similar solution?

Solwit supported Farmaprom with its knowledge and experience in building BigData analytical systems. We provided consulting and support on BigQuery and Google Cloud Platform to help the client succeed in building their own solution for managing large amounts of data.

Challenge

The overloaded transaction database was impeding further business development.

 

The transaction database had reached its limits of stored data. Any analysis of its content required too much time and due to high loads to the system had to be performed at night.

 

Lack of resources made the analysis of huge amounts of historical data impossible. Therefore making market forecasts and proper business decisions was extremely difficult. With no ability to collect more data the expansion of the business and its client base would come to a halt.

Solution

Cloud-based data collection and analysis employing BigQuery and Google Cloud Platform.

 

After assessing the situation it became obvious that not only did the solution have to allow collecting large amounts of data, but also provide tools for analyzing it and presenting reports in a clean, visual form. Solwit proposed utilizing the power of cloud solutions – the best choice was to move the data from SQL to BigQuery and create one’s own Datalake.

Result

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

 

BigQuery made it possible to analyze both historical and the current data in real-time – in a matter of seconds, instead of many hours as it had been before. FarmaProm developed a new comprehensive Business Intelligence tool to produce dedicated management reports.

 

Apart from scalability and powerful computing capabilities, the cloud solution opened a spectrum of new analytical and reporting possibilities.

how Google Cloud enables real-time data analysis

On April 14, Google officially opened a new region in Poland. We had the opportunity to share with the participants two interesting stories about how the use of the possibilities of Google Cloud accelerated the development of our clients’ businesses.

 

Michał Zieniewicz, the head of the Cloud & Integration Services Business Unit from Solwit, and Michał Górski, Big Data Developer from FarmaProm, talked about how Google Cloud enables real-time data analysis.

 

Watch the recording and learn about:

  • what challenges we faced during the project,
  • the structure of the architecture of our solution,
  • what business results our client reached by using BigQuery and Google Cloud.

 

Watch another conversation, between Michał and Wojciech Sznapka from STS about how Solwit and the Google Cloud helped to accelerate payouts for the sports betting company. Click HERE.

About Farmaprom

FarmaProm is the first open and independent internet platform created for the pharmaceutical market. It provides modern tools (CRM, SFA, and BI systems) for the comprehensive management of pharmaceutical companies and pharmacies. It handles over 60% of transactions done on the Polish pharmaceutical market.

The solutions used

  • Google Cloud Platform, BigQuery

Testimonials

“FarmaProm has reached out to Solwit for professional expertise and support in implementing big data technologies, including Google Cloud Platform and BigQuery functionalities. Co-operation between a FarmaProm specialist and dedicated Solwit specialists has been a valuable partnership beneficial for both parties.”

 

Krzysztof Bronowski, the finance director of FarmaProm Polska Sp. z o.o. sp. k.

LEARN ABOUT OUR CLIENTS' SUCCESS STORIES

Infinitely scalable LMS e-learning platform

0 K

users
a day

scalable resources
on demand

introducing
the product to
the global market

0 K

users
a day

scalable resources
on demand

introducing
the product to
the global market

Important information

Client:

Learnetic S.A.

Sector:

Digital education

Looking for similar solution?

Learnetic is a global provider of digital education solutions. Several years ago it faced the challenge of migrating the LMS platform based on Adobe Flash to a new technology. It was also necessary to prepare the proper infrastructure to effectively serve rapidly changing numbers of users. When education-oriented tools are concerned, the peak loads to the system occur in the morning, when classes take place, and in the afternoon, when students do their homework.

Challenge

The e-learning platform users needed a modern, reliable, universal, and easy way to access the educational content. From Learnetic’s point of view, the solution had to meet another two requirements: the capacity for withstanding high and variable loads, as well as ease of being expanded with new functionalities.

The company did not have the developers and the necessary equipment to provide its clients with a stable e-learning environment. Neither was it ready to invest in launching its own Data Center, due to an exceptionally high cost of such an undertaking. In order to create a system matching the new business requirements, it was crucial to introduce the product to the market without any delay and to utilize the most innovative IT solutions.

 

Learnetic had to find a team of engineers ready to fully commit to designing, developing, but also maintaining the new application in the future.

Solution

Solwit quickly developed a new e-learning environment based on Google Cloud solutions which allow for adaptive learning, real-time analyses, and unlimited scalability.

We developed a new version of the editor and educational content player, and in a very short time were able to prepare together with Learnetic an ecosystem of cloud-based products and mobile-oriented tools, such as:

 

  • mAuthor (an advanced multi-platform content creation and authoring tool),

  • mCourser (an LMS class learning environment),

  • mInstructor (a user-friendly content creation tool),

  • mLibro (an offline extension to the e-learning platform in the form of a mobile app).

 

The e-learning ecosystem created by Solwit is an E2E solution set for digital content creation, e-publishing, content import and distribution, and effective management of the learning process. It has been created to support publishing houses, schools, teachers, and students.

 

The system is still being developed and expanded with new functionalities. The ability for students and teachers to interact has been developed, including voice and video calls, interactive boards, and the option to give students tasks undergoing supervision and assessment.

Result

Over the time of cooperation with Solwit Learnetic has extended its operations to over 30 countries. Its content is used by thousands of teachers and shared with hundreds of thousands of students worldwide every day. The e-learning platform is also used for many popular education events and competitions.

Thanks to Google Cloud Platform the system can be scaled dynamically and with virtually no limitations, optimizing the cost compared to maintaining the fixed infrastructure of a sufficient scale.

 

We have delivered, and continue to expand, a set of on-line applications utilizing cloud computing that facilitates scaling, accessibility, and rapid deployment of new functionalities. This way Learnetic can focus on its business goals and rely on Solwit and its technological partners to perform all the programming and infrastructure-related work.

About Learnetic

Learnetic is a global provider of digital education solutions. The company offers a comprehensive suite of applications and advanced technologies for all stages of education – from publishing educational content to distributing its content to hundreds of thousands of students worldwide. Among its clients one can find publishers and educational institutions, such as Pearson, McGraw Hill Education, Cyber Book, and Klett.

How to deal with quick scaling and sudden spikes in user traffic on global platforms?

How cloud services launched e-learning to its current level and helped Learnetic in its global expansion.

The solutions used

  • Cloud Compute: App Engine Standard, Flex, Cloud Tasks, Compute Engine, VPC, GCS, Firestore
  • Storage & Databases: Firestore, GCS
  • Cloud Analitics: BigQuery, Datastudio
  • App Dev& Monitoring: Cloud IAM, Stackdriver

Technologies

Front-End

Angular, React, HTML5, Javascript (ECMA5/ECMA6), GWT, jQuery, Bootstrap

Backend

REST, Djangae, Datastore, BigQuery, Google App Engine Standard & Flexible, Google Cloud Storage, Datastore/Firestore, Firebase, Flask, Connexion, Go, Redis, Memcache

Mobile

iOS, Android

Desktop

Windows, OSX, Linux, Python, Java, Qt

Domain standards

SCORM, xAPI (TinCan), LTI

Tool

Jenkins, Ant, Grunt, Poetry, CocoaPods, Git

LEARN ABOUT OUR CLIENTS' SUCCESS STORIES

Defining security standards in software development

Written by Maciej Gajdzica (Senior Software Developer)

Maintaining the highest level of system security results in significant increase in cost and duration of the development process. How to evaluate the security standards – explains Maciej, our expert in life-saving software systems.

safety-critical systems

Maintaining the highest level of system security results in significant increase in cost and duration of the development process. On the other hand, not all systems are equally critical and even within one system several sub-systems requiring different security standards can be distinguished. Take a car as an example – a brake system failure will have much more dire consequences than a radio malfunction. Clearly, developing all systems under the same requirement set would be unnecessary and counterproductive.

 

That is why the IE61508 standard, which lays out the rules for production of safety related electronic devices, defines four Security Integrity Levels:

 

  • SIL4 – in case of failure multiple loss of life is possible;
  • SIL3 – in case of failure a single loss of life is possible;
  • SIL2 – in case of failure major injuries to one or more persons are possible;
  • SIL1 – in case of failure only minor injuries are possible;

 

For each level the acceptable probability of an accident occurring have been defined under two categories: PFH – Probability of dangerous failure per hour, and Probability of dangerous failure on demand.

What the numbers say is that for the SIL4 if we assume 1000 devices operating for 10 years constantly, one critical failure can occur. Of course, it does not mean that the failure must necessarily lead to an accident.

 

The rules stated in the IEC61508 standard have become the basis for other regulation sets for various industry fields. Example being the railroad standard DO-178 defining the Design Assurance Level:

dal_safety_critical

In the automotive industry there are Automotive Safety Integrity Levels defined by the ISO26262 standard, where ASIL A and SIL D are counterparts of the previously mentioned SIL1 and SIL4 respectively.

 

In the field of Medicine the levels have been defined in a different way by the EN62304 norm:

class-safety-critical

The level of a given system’s security should be decided after a thorough analysis of security related requirements and when a risk analysis has been performed. If several sub-systems are distinguished within the project, it needs to be proven that failure of a lower-level component does not influence any components of higher security levels. For example, it is not possible to assign two different security levels to two separate parts of a program when they are executed by the same processor.

 

In order to guarantee proper separation in this case virtualisation techniques need to be utilised or the less critical modules should be moved to a different processor.

 

If you are looking for experts who can help you with developing your software or you need a certification of your product contact with us. Check out the case study about safety critical system which equired compliance with CENELEC SIL-3 and SIL-4 standards for one of our clients:  -> Read more!

Latest blog posts