Improve by Analysis and Modelling

Automate Data Set Creation at the NHS

Automating processes is an opportunity of making your organisation more efficient. Automation can save time and improve accuracy and allows you to take on more than you normally would have during a manual process. We have the technical expertise and experience automating data processes and reporting using popular frameworks such as Excel VBA and the Python programming language.

The Challenge

Automate a manual process which consolidated data from 3 different patient information systems. The final data set was according to national data set standards. The process would be automated from the extracting the data to creating the final data set.

The Solution

An automated process was set in place using the Excel macros. Reporting within the process for summary information as well as trend analysis for local reporting.


Data connections were created on Excel workbooks to run queries on the patient data systems. The queries were executed by running a VBA macro on the workbook.


The extracted data was copied onto a worksheet and this was then consolidated. If there were no proper formulas available, then macro formulas were used.

The Result

  • The resulting solution shortened the process of creating the data set from 1 week to half a day. The only delay being the time taken to update the patient systems with the latest data.
  • Automation considerably improved the quality of the final dataset as it was less prone to human error.
  • Reporting systems in place meant that management could see an overview of each dataset with checks in place to ensure data quality.

The Applications Involved

During initial investigation we select the best applications that will fix your requirement and build our solutions on top of this.

The Services Involved

Come to us for our unique approach to data solutions taylor made for your unique needs. We have years of experience delivering useful solutions doing only a few things that we are really good at.

Our services allow you to hand over the techincal aspects of data management and analysis over to us to help you focus on the business

Statistical Modelling

A statistical model takes the guesswork out of thinking there are patterns in your data. Using a statistical model, you can mathematically prove if there are relationships between elements of a dataset and if so you can assign a number to the degree of the relationship. When you model real world data, relationships are a grey area. There are exceptions to rules due to the complexity of real world interactions. Intellisolve sets up statistical models the same way as financial models, focusing on the business need first and building the model around that.

We would like to hear from you.

Give us a call on 020 333 20457

Would you like a callback?

Leave your details and we will call you back.