Case Study | Pharmaceutical Laboratory

Definition and design of the Informational data model

Consultancy service to define and conceptualize the design of the informational data model for the commercial area of the laboratory.

08-bismart-business-intelligence-laboratorio-farmacutico-data-warehouse-data-management-data-quality

GOAL

Proposing a data model that offers:

  • Improvement in the quality of decisions.
  • Stability.
  • Centralized knowledge.

STRATEGY

  • Requirement taking and study of data origins.
  • Definition of load interfaces.
  • Design of indicators and dimensions.
  • Data warehouse design and processes.
  • Definition of an RFP (scope, budget, project plan, risks…).

RESULTS

Consultancy document (RFP) for the construction of an analytical model with:

  • Unique and well structured data repository.
  • Normalized information.
  • Reports that guarantee the coherence of information.

08-bismart-business-intelligence-laboratorio-farmacutico-data-warehouse-data-management-data-quality-1
6 therapeutic areas

 

08-bismart-business-intelligence-laboratorio-farmacutico-data-warehouse-data-management-data-quality-3
€ 376 Million in research

08-bismart-business-intelligence-laboratorio-farmacutico-data-warehouse-data-management-data-quality-5
50 offices worldwide

Other Case Studies

 

Discover what we can do for your business