Development Project Status: Ongoing

There have been several topics raised in respect to this. Nick raised the ability to export data in a chosen format. Bayer has expressed interest in creating the ability for pratice managers to export data automatically and even in a scheduled fashion. There have been a variety of requests for practice reports in other posts as well.

Tony De Keizer has suggested an approach that could encompass all of these requests and future anticipated needs as well. Essentially the key steps are to;

a) Create a Data Warehouse

This would involve a snapshot of sorts of the data within our OpenVPMS database. It is organised however in a way that is more suitable for reporting and business analysis.

b) Use software to allow an intuitive building of new reports without having to understand SQL or other database languages.

There are apparently several options here including some which will handle scheduled reports and report delivery (email etc).

The potential benefits here span many entities. Here are some possible scenarios:

Practice Managers

Can design reports specific for their practice and run these reports without slowing down the application. The practice manager wont need to know SQL, just a clear understanding of what vital signs they want from their business.

Manafacturers

Some of us provided anonmysed sale data to some manafacturers and this imposes a workload on our clerical staff. Here the interested parties can design their own "Analysis Modules" and we can plug them into the interface.

Business Analysts

For that associated industry that provides advice and business analysis, they can design their own suite of reports that they use to provide their analysis, easier and quicker for OpenVPMS practices.