Skip to content
Contents

Informatics Technical Solutions

Reference: 23-24263

Date response sent: 04/10/2023

Details of enquiry

Dear informatics lead, please can you provide a response to the following questions:

Section 1:

  1. What are the core patient administration system(s) used by your organisation?

Carenotes

  1. Do you have a data warehouse solution in place to extract, transform and load data from your patient administration system(s) into a central repository for secondary use?

Yes

  1. What systems/software/programmes/applications does your informatics teams use to:
    1. Manage workload, incorporating receiving requests internally and externally, managing work in progress and communicating to customers through to task/product completion?

Hornbill Customer Service Management

  1. Provide regularly available information to customers, including patient data, reports, dashboards, scorecards and other visual representations of data?

MS Excel, SSRS, MS Power BI

  1. Analyse data, including descriptive, diagnostic, predictive and prescriptive analysis (as defined in table 1 below).

MS Excel, Database/Data warehouse developed on SSMS (SQL Server Management Studio), Data Visualization and further analysis on Microsoft Power BI

Table 1 Types of analysis, adapted from Gibson (2021)

Descriptive analysis This is the simplest and most common use of data in business today. Descriptive analysis answers the “what happened” by summarizing past data, usually in the form of dashboards.  The biggest use of descriptive analysis in business is to track Key Performance Indicators (KPIs).
Diagnostic analysis Diagnostic analysis takes the insights found from descriptive analytics and drills down to find the causes of those outcomes. Organizations make use of this type of analytics as it creates more connections between data and identifies patterns of behaviour.
Predictive analysis Predictive analysis uses the data we have summarized to make logical predictions of the outcomes of events. This analysis relies on statistical modelling, which requires added technology and manpower to forecast. It is also important to understand that forecasting is only an estimate; the accuracy of predictions relies on quality and detailed data.
Prescriptive analysis Prescriptive analysis utilizes state of the art technology and data practices, such as Artificial Intelligence (AI) systems to consume a large amount of data to continuously learn and use this information to make informed decisions, communicating these decisions and even putting those decisions into action.

 

For the next section of questions, please provide an answer for each system included in response to question 3 (i.e. for parts a, b & c).  A matrix has been provided for convenience.

 

  3a 3b 3c
4.     How long have these systems been in place/used for? 3<4 years 5<10 years 5<10 years
5.     What are the annual costs to use these systems? This has varied due to number of accounts.  Currently £33.5k They come as part of several different packages and can’t be itemised These come as part of our Microsoft Enterprise Licences
6.     Were there any initial set up costs to implement these systems?  Is so what costs were incurred? No No No
7.     Have these systems been assessed for their return on investment?  If so, what was the outcome? No No No
8.     Do you intend to continue to use these technological solutions in the next 3-5 years?  If not, what other solutions are you considering? We do not hold this data We do not hold this data We do not hold this data

 

Section 2:

  1. On average (excluding Freedom of Information requests), how many requests in total do you receive per week or month from both internal and external colleagues/customers for:
    1. Information provision

200 or more

  1. Regular reports

20<30 This can vary by month

  1. Analysis 20<30 or comment here

This can vary by month

  1. On average (excluding Freedom of Information requests), how long does it take from a request being received to completion (i.e. turnaround/process time) for:
    1. Information provision 5<10 days or comment here

Depends on complexity of the request

  1. Regular reports 10<15 days or comment here

Depends on complexity of the request

  1. Analysis 5<10 days or comment here

Depends on complexity of the request

  1. How many staff (whole time equivalents) are employed in any capacity to service these types of requests?
    1. Information provision

1<5 or comment here Click here to enter text.

  1. Regular reports

1<5 or comment here Click here to enter text.

  1. Analysis

1<5 or comment here Click here to enter text.

  1. Do you use business intelligence cubes / OLAP (Online Analytical Processing) cubes to standardise, consolidate or aggregate relevant data for fast and efficient analysis?

No

Have you implemented or experimented with the use of artificial intelligence or machine learning?

No (If a relevant option is not available, then enter your own)

  1. If so, what has this been used for? Click here to enter text.
  2. How often is this type of analysis conducted? Click here to enter text.
  1. Would you be willing to provide more information and discuss these points on a one-to-one basis? If so, please can you provide your details below:

No

Table 2 Contact details

Name: Click here to enter text.
Job title: Click here to enter text.
Email address: Click here to enter text.
Phone number: Click here to enter text.

 

  1. Do you have any other comments you would like to add?

No

References

Gibson, P (2021). Types of Data Analysis.  Available from: https://chartio.com/learn/data-analytics/types-of-data-analysis/ (Accessed 19/09/2023)

 

Response sent

Responses included in enquiry above.

Back to top