“is ideal for anybody wishing to ensure that they are achieving maximum efficiencies within their data management/analytical functions.”
Grace Birch
NHS Bolton

  • What are the potential cost savings?

  • If a Trust with 3000 staff reduced sickness levels by just 1 day per person per year they would save £500,000 per year
  • If a Trust with 6000 staff reduces its bank and temporary staff to cover absences and sickness by just 10% they would save more than £1m per year

Difficult times, difficult decisions

Within this new, austere economic climate, every NHS organisation will have to achieve significant cost savings, and the single biggest item of expense within an NHS organisation is its staff.

Manpower optimisation, efficient resource allocation and elimination of unnecessary staff cost has to be a major focus for any organisation serious about saving money. But where do you get the information to enable you to take the right decisive actions needed?

Insource ESR BI is a business intelligence system for workforce and payroll reporting and analysis. It enables Trusts to get a significant insight into data held within ESR relating to its staff.

How can you justify it?

The low cost deployment model of Insource ESR BI enables secure self service reports to unlimited numbers of authorised users including Directors, Managers and other key decision makers for a fixed cost.

Flexible purchase options range from outright purchase through to a 5 year purchase plan, provides a demonstrable and immediate return on investment

Can you afford not to buy Insource ESR BI?

  • What will it do for you?

    Amongst many features, it provides
    the ability to make cost savings through
  • Identification of high levels of sickness and absenteeism, looking for patterns and trends
  • The ability to optimise Bank and Agency staff usage
  • And can also provide the ability to
  • make ESR reports available to end-users via the Trust’s own reporting portal (this facility is not available using Discoverer to which typically only a few members of staff in the payroll and workforce departments have access)
  • generate reports from the data warehouse and deliver them to the users far quicker than those provided by the ESR Discoverer interface; one can expect most reports to be generated from the data warehouse to be delivered in seconds.

A More Detailed Look at Insource ESR BI

The Insource Health Business Intelligence (BI) solution provides the framework which enables all of your existing systems to work together. Insource Health BI is capable of taking data from any source that you already possess and turning it into information that is consistent, accurate, easy to use and readily accessible.

Insource ESR BI is a workforce and payroll reporting and analysis solution that enables Trusts to get a significant insight into data held within ESR relating to its staff which can account for up to 70% of the trust’s overall budget. The solution will enable more accurate measurement of key indicators such as absenteeism, vacancies and the use of agency staff.

Once the data is brought into your data warehouse it is possible to query the data to produce permutations of reports which are not easily available from your core ESR. The transformation contained within the Insource ESR BI will enable you to slice and dice reports by any of the elements in the data model for example: leavers by sex / ethnic origin etc, positions by Grade/ business unit / assignment type sex / age etc.

It is also possible to link ESR data to data held in your data warehouse from other systems, for example Finance and PAS activity systems, which is not possible using Discoverer queries that are provided with your core ESR. By using our Insource ESR BI solution together with data linked from PAS systems you will have the platform to support Patient Level Costing / Service Line Reporting and Costing.

[ Top ]

Included Analysis Cubes & Relational Data Sets

Insource ESR BI solution provides a number of pre-built analysis cubes and relational datasets which may be used by Information Analysts to produce reports easily and efficiently. If you already have our Analyzer reporting tool you can quickly connect to the cubes and produce high value reports within minutes.

The pre-built analysis cubes and relational datasets included within our Insource ESR BI “starter pack” include:

  • Employee Assignment details
    This dataset includes details of all employee assignments. This data has been processed to provide information as at any given point in time and takes into account changes to positions, employee contracted hours, assignment details and other related data that changes over time. This level of granularity of data is not possible to obtain via the Discoverer reporting tool provided with your core ESR.
  • Employee Assignment Monthly snapshot
    This dataset provides a census based snapshot of employee assignments and, therefore, staff in post and associated costing details. These snapshots allow both historic and trended reports to be produced quickly and easily.
  • Employee Leavers
    This dataset provides details of leavers, when and why they left and the positions they left. Again, this dataset allows both historic and trended reports to be produced quickly and easily.
  • Employee Absence
    This dataset provides details of employee absence, allocating absence periods to the positions to which the employee was assigned to at the date of the absence.

Additionally there are datasets that combine the above datasets which will enable you to analyse staff turnover and absence measured against staff in post snapshot details. This allows questions such as:

  • What % of our total manpower available was lost due to sickness in a given month/year for a given directorate / department / grade / position type etc?
  • What was the level of staff turnover in relation to our employee base in a given month/year for a given directorate / department / grade / position type etc?
  • What is the correlation between staff sickness and turnover in a given month/year for a given directorate / department / grade / position type etc?
[ Top ]

Included Data Loaders

The data included within Insource ESR BI includes:

  • Assignment Costing
    Holds the financial coding to which an employee assignment belongs (is related) to in terms of both the department and cost centre.
  • Organisations
    Contains details of business units within the Trust.
  • Organisation Hierarchy
    Contains the Business Unit Hierarchy which is in place within the Trust
  • Employee
    Holds the basic demographic data relating to members of staff both current and archived. A single record per employee is provided.
  • Employee Absence
    Contains details of employee absence.
  • Employee Assignment
    Contains multiple records per employee assignment, duplicates within the assignment number will be created on each change to the FTE, grade step, and pay increment within the assignment.
  • Leavers
    Contains details of Employees who have left the Trust including exit date and details.
  • Positions
    Contains details of the position to which an employee may be assigned, a history of the positions is held bound by start and end date.
[ Top ]

Find Out More...