Silhouette of a scientist at a microscope on a purple background

Medical research · Business intelligence · Data warehouse

Unified Reporting Platform for a research organization

Inteca designed the IT architecture and built a data warehouse and reporting system integrating over 25 data sources – finance and HR reporting is now automated.

  • Reports in a few hours instead of two weeks
  • An audit of data quality and existing systems
integrated data sources
25+
analytical views and reports
10+
of cooperation
1 year+

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.

  1. IT architecture design

    Planning the development of the client’s IT architecture with business intelligence capability in mind.

  2. Analysis and mapping

    A repository in Enterprise Architect: systems and services used, the most important data domains, business processes and technology.

  3. Integrating data sources

    Integration with over 25 data sources, including relational databases, APIs, batch files and cloud sources.

  4. 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.”
Armin AminSenior Project Manager

Technologies

Pentaho · Enterprise Architect · Data warehouse · Business intelligence · API · Cloud sources

Reports in hours, not weeks

Finance and HR teams no longer spend two weeks each month analyzing data and developing reports, and can focus on other tasks.

integrated data sources
25+
analytical views and reports
10+
of cooperation
1 year+
  • Automated reporting

    The whole reporting process has been automated, unloading the finance and HR teams.

  • Configurable analytics

    The new system is dynamic and allows users to configure settings for various analytical and reporting needs.

  • Understanding of systems

    Existing systems, data sources and connections between them are now understood.

  • Data quality audit

    The project identified problems with data quality and with the construction and use of existing databases and systems.

Need unified reporting across your organization?

  • 30 minutes with an IT delivery expert
  • A reply within 1 business day of your request
  • An NDA before we talk, if you need one
Let's talk about your project