Related Experiment Video
Updated: Jul 7, 2026
08:18
Self-Nanoemulsification of Healthy Oils to Enhance the Solubility of Lipophilic Drugs
Published on: July 27, 2022
Integrating a Fragmented Pharmacy Network into a Unified Supply Chain System: A Case Study from Qatar's Primary
Manal Al-Zaidan1,2,3, Chiragkumar Gohel4, Regina Padmanabhan2
1Department of Pharmacy and Therapeutics Supply, Primary Health Care Corporation, Doha, Qatar.
Journal of Healthcare Leadership
|July 6, 2026
Summary
Integrating supplier data into an enterprise data warehouse improved pharmaceutical supply chain visibility and governance for Qatar
Area of Science:
- Health Informatics
- Supply Chain Management
- Data Analytics
Background:
- Healthcare organizations increasingly use digital integration for pharmaceutical supply chain governance.
- Qatar's Primary Health Care Corporation (PHCC) lacked an internal Enterprise Resource Planning (ERP) system, leading to fragmented data and poor visibility.
- Decentralized pharmacy networks pose challenges for effective supply chain management.
Purpose of the Study:
- To design and implement an enterprise-level data integration and analytics solution for PHCC.
- To enhance procurement transparency and inventory visibility across PHCC's pharmacy network.
- To enable data-informed decision-making for improved supply chain governance.
Main Methods:
- Employed a Design Science Research (DSR) methodology.
- Developed a centralized Enterprise Data Warehouse (EDW) by integrating supplier ERP data.
- Deployed a Tableau-based analytics dashboard with KPIs across 32 pharmacies.
Main Results:
- Achieved real-time visibility of pharmaceutical procurement and inventory.
- Reduced back-order rates from 6.7% to 4.5% in 2024.
- Increased average medication shelf life by 3% (551 to 568 days) and improved expiry profile.
Conclusions:
- Integrating external supplier ERP data into an EDW enhances visibility and decision support in public healthcare.
- This approach offers a scalable model for strengthening pharmaceutical supply chain governance without a full ERP implementation.
- The study demonstrates a practical solution for healthcare systems with fragmented data.
Related Concept Videos
01:20Integrated Healthcare System
An integrated healthcare system (IHS) is a set of organizations that provides for or arranges to provide coordinated and continuous service to a defined population. The IHS takes responsibility for that particular population's health status and outcome, both clinically and fiscally. An integrated healthcare system is a well-organized, well-coordinated, and collaborative network. The integrated delivery system is a network that connects different healthcare providers to deliver organized,...
01:11Secondary Healthcare System
Secondary healthcare is offered by a specialist, generally in hospitals or clinics for patients referred by primary healthcare providers. It occurs when a person has an illness or injury that requires specific medical care. Secondary care is often referred to as acute care. Secondary care can range from uncomplicated care to repair a minor laceration or treat a strep throat infection to more complicated emergent care, such as treating a head injury sustained in an automobile accident. Whatever...
01:30Primary Healthcare Services
Primary care promotes wellness and prevents disease. This care includes health promotion, education, protection (such as immunizations), early disease screening, and environmental considerations. Settings providing this type of healthcare include physician offices, public health clinics, school nursing, and community health nursing.
In 1978, international leaders convened in Alma-Ata, Kazakhstan, for what would be a pivotal event in global health. The Alma-Ata Declaration was the first to call...
In 1978, international leaders convened in Alma-Ata, Kazakhstan, for what would be a pivotal event in global health. The Alma-Ata Declaration was the first to call...
01:26Methods Of Healthcare Delivery System
At the different levels of the healthcare system, we see varying methods of healthcare used. These methods include managed care systems, case management, and primary healthcare.
Managed Care System:
The managed care system is designed to control the cost while maintaining the quality of care. The patient's care from admission to discharge is planned by the primary care provider or the case manager, also known as the gatekeeper. In a managed care system, the number of care providers is limited...
Managed Care System:
The managed care system is designed to control the cost while maintaining the quality of care. The patient's care from admission to discharge is planned by the primary care provider or the case manager, also known as the gatekeeper. In a managed care system, the number of care providers is limited...
01:21Tertiary Healthcare System
Specialized care provided over an extended period is called tertiary care. Usually, a primary or secondary care physician will refer a patient to tertiary care. A patient's maximum physical and mental function is restored in tertiary care, which is caused due to the impact of a chronic illness or condition. Tertiary care aims to achieve the highest level of functioning possible while managing chronic illness. For example, a patient who falls and fractures their hip will need secondary care to...
01:27Nursing Clinical Information System
Nursing Clinical Information System (NCIS)
A Nursing Clinical Information System (NCIS) is a specialized type of healthcare information system tailored to meet the unique needs of nursing practice. It incorporates the principles of nursing informatics to streamline information management and improve the quality of care delivery.
Critical attributes of NCIS include:
A Nursing Clinical Information System (NCIS) is a specialized type of healthcare information system tailored to meet the unique needs of nursing practice. It incorporates the principles of nursing informatics to streamline information management and improve the quality of care delivery.
Critical attributes of NCIS include: