An international research organization in biological sciences
The Client of the project was an international research organization dealing with biological sciences, offering drug development services for the pharmaceutical industry. The organization has 3 research centres in two countries and employs over 600 scientists. It has been operating successfully on the market for 13 years, the best proof of which is the introduction of 25 new drugs into the clinical trial phase in the last three years.
Client profileOrganization name not disclosed
- Industry
- Medical research
- Research centres
- 3 in two countries
- Scientists
- 600+
- On the market
- 13 years
Reports from several systems and undocumented databases
Due to the growth and fragmentation of the client’s organization over different locations, it became increasingly difficult to control finances and human resources. For these reasons, a decision was made to organize and map existing databases and build a data warehouse and a reporting system based on them.
- Time-consuming reports — many employees spent a lot of time creating complex reports with data from several systems.
- Inconsistent databases — designed by different companies at different times.
- No documentation — nothing described the content and design of the databases.
IT architecture, a data warehouse and Pentaho
The project began with designing and planning the development of the client’s IT architecture. The need to build business intelligence capability and its use in existing and target organization processes was taken into account. The target architecture has a unified approach to data analysis and reporting by creating a centralized platform, the so-called Unified Reporting Platform.
Enterprise Architect repository
Describes the organization’s application, data, business and technology architecture.
Flexible data structures
Designed for flexibility and adaptability to new customer requirements.
Pentaho
Business analytics from acquiring, integrating and transforming data to reports, dashboards and pivot tables.
Configurable dimensions
Dimensions can be modified through simple configuration as the organization grows rapidly.
Over a year of gradual implementation
After analyzing the architecture of the organization, the process of gradual implementation of the next elements of the platform began.
IT architecture design
Planning the development of the client’s IT architecture with business intelligence capability in mind.
Analysis and mapping
A repository in Enterprise Architect: systems and services used, the most important data domains, business processes and technology.
Integrating data sources
Integration with over 25 data sources, including relational databases, APIs, batch files and cloud sources.
Reports and views
Over 10 analytical views and reports designed and implemented.
“Inteca ensured a balance between supporting the implementation of the solution proposed by us and providing their own technical knowledge. There was no situation in which the employees of Inteca would not be able to implement the chosen technology. However, more importantly, they have always been able to recognize and identify the technology that best suits our current problems.”
Technologies



