Business Intelligence Reporting

We are now in our fourth month of live running with Clinic Office, so we are starting to see possibilities for analysis and businees intelligence reporting.

To keep it simple would be looking to extract data (via a csv report would be fine) into a reporting database (aka Excel). This can of course be done for the existing report templates. This however is tedious if you are extracting a report on a daily or weekly basis.

So how easy would it be to produce a “matrix” style report. With the left hand column as the “lable for the data” and then the time periods running across as columns.

The label would follow the same pattern as many of the existing reports with the data point as a single value such as Total Payment or Total Invoice Value or Number of Treatments.

The time periods would be a contiguous preriod of either days, weeks or months.

Not sure what is easy or difficult to achieve from Clinic Office. If it looks possible and cost effective I would be happy to specify more precisely.

Regards
Tony Taylor