medigo-bi

View project on GitHub

MEDIGO: Third party administration (TPA) services with tech-driven efficiency

Navigate the Global Healthcare System with world-class customer service

By: Cevi Herdian: Data-Driven Strategist

Note: All data provided in this file has been randomly created and does not reflect the state of MEDIGO’s performance. It does, however, resemble to part of the MEDIGO data warehouse and is to be understood as a simplification of our business model.

Background information:

MEDIGO is a marketplace where patients looking to undergo a medical procedure can search for high quality clinics, inquire for the price of a procedure and exchange with clinics and hospitals in order to eventually make an informed decision on where to get the treatment they need.

MEDIGO works with clinics from all around the globe and helps patients from many different countries to get in touch with clinics primarily located outside their home country. MEDIGO makes quality healthcare easily accessible.

At the starting point of the medical travel process, potential patients need to send an inquiry to a clinic through the MEDIGO platform. These patient inquiries are received by a facilitator (someone from the clinics’ staff) who will then take upon her/himself to provide patients with answers to their questions as well as with a quote and a treatment plan.

MEDIGO considers that an inquiry becomes a booking as soon as the patient and the facilitator have agreed on a date and a price for the treatment – we would then consider this inquiry as scheduled. After the scheduling of a treatment, most patients ask the facilitator for help with booking their flights and accommodation before going for treatment. Unfortunately, some patients sometimes cancel their scheduled treatment due to unforeseen change of plans.

MEDIGO uses various online and offline marketing channels to attract patients to its website. The marketing team based in MEDIGO’s Berlin HQ constantly optimizes its marketing campaigns so as to reduce the cost per inquirer and to improve ROI.

MEDIGO earns money by charging a 30% commission on all completed treatments.

Task:

You are a Data-Driven Consultant at itsmecevi.github.io to help MEDIGO to brief a potential investor on the company’s performance, revenues and profits. This investor knows very little about MEDIGO and needs to understand the business as much as possible before making his investment decision. You should find all the information needed for this analysis in the Excel file attached.

1-) Please provide insights on MEDIGO’s key business and revenue metrics. Conversion Rate and Cash Flow Generation are examples of important metrics for MEDIGO but there are many others.

Note: You do not need to create a comprehensive presentation to present the industry, the business model or the company itself. Presenting key metrics and analyzing them is what matters here! 🤟

2-) Please also (shortly) list the information missing in the Excel document and you wish you had to your disposal to either go deeper in your analysis or to calculate some metrics.

Additional information:

Average Basket Value for MEDIGO’s most popular procedures (EUR)

  • Hip Replacement: €10,000
  • Veneers: €300
  • Teeth Whitening: €250
  • Breast Implants: €5,000
  • Cancer Treatment: €9,000
  • Laser Eye Surgery: €1,000

Average CPI (Cost per Inquirer) for MEDIGO’s most popular procedures (EUR)

  • Hip Replacement: €250
  • Veneers: €45
  • Teeth Whitening: €50
  • Breast Implants: €100
  • Cancer Treatment: €300
  • Laser Eye Surgery: €75

Data Source: MEDIGO-data.xlsx

Please get an analytical insight with your software or methods. You can used one of the famous software in the market, such as EXCEL, TABLEAU, or KNIME. After that please created a Picthing Presentation with your own presentations software, maybe prezi, MS-Power Point, Google Slide, or VideoAsk (FEEL FREE about the Presentation formatting and software)

Medigo Notes:

  • Third party administration (TPA): Outsourcing Sytems
  • Tech-driven: technology freak
  • Marketplace (e-commerce), all about marketplace
  • Patient search clinics (health procedure)
  • Costumer->medigo->clinics
  • Fasilitator->(medigo, internal clinics)
  • Medigo marketing plan (offline/online)-> 1. min(CPI), 2. max(ROI)-> value investing (user completed, ###view, services, market share, profitability, stocks###)
  • 3 fase BP (business process): 1. inquiry, 2. fasilitators, 3. cancel/completed
  • Profit: 30% from completed treatments
  • Key business & revenue matrix (marketing plan, market share, profit from services, swot analysis, BCG matrix)
  • Average Basket Value, please googling
  • CPI, please googling
  • Medigos gross profit: Average Basket Value (harga rumah)*30%
  • Medigos net profit: gross profit-CPI (per inquiry, per personal)