Back

Hospital Equipment Procurement

Introduction

Procurement in health involves the purchase of producrs, supplies, equipment, and related services.

By analyzing procurement data, hospitals can identify suppliers offering competitive prices, negotiate better contracts, and eliminate unnecessary expenses.

In this projects, the federal ministry of health requires efficient management of equipment procurement to ensure availability of resources for patient care

Explore Dashboard

Project Objectives

  • To use Power Query to explore, clean and prepare the data for analysis
  • To analyze the data to identify patterns, trend and opportunities for optimization of equipment procurement process

Project Links

Github

Power BI

.

Tools used

  • Microsoft Power BI

Skills Utilized

  • Data Cleaning
  • Feature Engineering
  • Data Modeling
  • Data Analysis
  • Data Visualization
  • Dashboard & Storytelling

Insights

Dashboard 1

Introduction

  • Analysis showed that data was collected from 35 states in the country
  • The data was collected on the procurement made by 86 hospitals which span 21 departments
  • 65 unique types of medical equipment was procurement
  • A total of 612 equipments were procured in the first quarter, with a total procurement cost of $21M

Dashboard 1

Order Analysis

  • Analysis showed that data was collected from 35 states in the country
  • The data was collected on the procurement made by 86 hospitals which span 21 departments
  • 65 unique types of medical equipment was procurement
  • A total of 612 equipments were procured in the first quarter, with a total procurement cost of $21M

Recommendation

  • The monthly contract should be upgraded to a six months contract, this may lead to low churn rate.
  • A reduction in monthly charges may lower the churn rates as 56% of churn customers payed above average rate.
  • Upgrading to a better device and providing better offer types than the competitions can increased rentention.
  • Implementing a loyalty reward program can help retain high valued customers
  • Re-training of the support staff on customer management will help resolve customers problems and in-turn increase retention rate