We were approached by a research team from a large South African university to help manage and present results into HIV tests, funded by the Gates foundation.
This is a complicated field, because tests have varying parameters of operation and efficacy and the data is distributed internationally across multiple research centres. Also the data is not always complete and of uncertain quality.
We created a web-based system where result files could be uploaded via Excel. The data is pre-processed to ensure it reached minimum standards for presentation and the normalised results are then stored in a MySQL relational database.
This data can then be accessed in various ways through a website using the Django framework hosted on a university server.
This project ran for about 2 years, and is now being wrapped up in a research paper to be published in the near future.