The pharmaceutical industry has a huge disadvantage considering the amount of data available on consumption, compared to a telecommunications company. It is certain, that the lack of this type of information is responsible for the low level of BI (Business Intelligence) maturity all over the pharmaceutical sector. As this is a clear disadvantage, the late catch-up has many benefits as well. There are many cost effective solutions available on the market (including open source tools) that can be used to achieve similar or better results with less investment.
The aim of my thesis is to document the process of planning, implementing and introducing a complete BI solution to a pharmaceutical company. The solution aims to support the sales force with detailed information they request. My goal is to lower the need for human interaction, while producing accurate and up to date data to the key users. This is achieved by high level of automation in data loading and handling, and presenting through interactive dashboards and triggered notifications. As there was no dedicated budget for this project, I used free and open source BI tools along with self developed solutions.
In this document I show the process of extracting data from the available source systems along with the needed design and implementation steps to merge them in a Data Mart, so we can analyze them using BI tools. Along with the developed dashboards, I’m describing the use of automatic email and SMS notifications.