Development & Data Services

Consultancy Tools

For a number of years now we have been assisting clients with exporting medical data from their database systems and helping them produce meaningful analysis, reporting and publications. Exporting data from a database is relatively straight forward nowadays due to the fact that most systems have the ability to export database tables as either utf8 comma separated values (.csv) or javascript object notation (.json). A common problem that clients encounter concerns the sheer volume of ...read more

Importing, Organising, Cleansing and Mapping

Consultancy Tool are capable of performing a number of important and useful tasks, the first being the ability to import, organise, cleanse, map and desensitise .csv and .json files. Cleansing is the process of ’tidying’ up and transforming the imported data into consistent values and formats such as dates, values, measures and codes. The consultancy tools are able to do this using arrays of internal mappings that have been developed and refined over time. Mapping ...read more

Datasets for Charts, Reporting and Publication

The Consultancy Tools not only produce datasets, graphs and reporting for iOS and macOS; they also generates a series of scripts that are linked together to produce an automated process that can be run again and again as additional files are imported.Data sensitivity is also something that we take seriously and a feature within the Graphical User Interface (GUI)allows you to hide or disguise any field from the imported .csv or the generated dataset. Names ...read more

Medical Sample Registration

pi.healthcare has also developed a commercial product that is used to register and secure sample data received from medical institutes. Samples are received either digitally over secure SFTP or via a physical hard drive. The pi Registration Software can register, verify and copy received samples directly to a specified server or backup location. An audit of the registered data is logged in the system so that its integrity can always be verified. The audit also ...read more

Email, Website and API Servers

pi.healthcare is committed to being as self-sufficient as possible when it comes to IT infrastructure. As well as developing our own tools to analyse and manage data, we also build and deploy servers for managing email, websites and RESTful APIs; thus reducing the monthly subscription costs and usage fees in having the same services hosted by Cloud Service and Web-Hosting providers such as Amazon Web Services, Alibaba and Tencent. By having all these services ’under ...read more

App Store

pi.healthcare is now in the process of adapting a number of consultancy tools for general release via Apple's App Store. These products include a .csv importer, a data mapping tool and a sample registration utility. ...read more