Back to projects

Hackathon: Venezuelan Healthcare System: Bot and Dashboard

Telegram Chatbot to inform about the status of Venezuelan hospitals.

Team Lead, Developer2020

*Description

We built this project during the 2020 Data Analytics Hackathon organized by Code for Venezuela and Hult International Business School. The objective of the hackathon was to create a visualization dashboard to inform about the status of Venezuelan hospitals to the general public and press. The data we had was coming from weekly surveys filled by the hospitals reporting the current status of their services. For example, these hospitals reported their supply levels, if they had outages and how frequently, the beds available, etc. We took this data and created a 3-point system for each service of the hospital: Good, Intermediate or Bad. This data with the hospital and their services score was then uploaded to Big Query to be able to pull it and feed our Tableau Dashboard and our Telegram Chatbot. The project is available on Github: https://github.com/93arnaldo/c4v2020

*Key Achievements

  • Awarded with 1st place in the Hackathon
  • Created a Telegram Chatbot to inform about the status of Venezuelan hospitals
  • Created a Tableau Dashboard to inform about the status of Venezuelan hospitals

*Technologies

PythonTableauTelegram BotGitBig Querypandasnumpymatplotlib

*Project Gallery

1st place award

1st place award

We launched the bot during the hackathon for everyone to use

Presenting the project to the judges

Presenting the project to the judges

During the hackathon

During the hackathon