Using SQL and Power BI
to analyse data at scale to create SPC charts to aid decision making
NHS England, London
-->
NHS England, London
Organisations and systems need to be able to analyse large volumes of data to create statistical process control (SPC) charts, otherwise the true nature of performance and assurance in processes may be missed, with time and effort spent in the wrong areas.
The innovation led to:
The innovation resulted in:
All the documents and resources relating to this innovation can be found in the downloads section at the bottom of the page.
Innovation K3“An excellent innovation, highlighting how finance teams can use previously under utilised skills combined with new technology to speed up analysis and value to the NHS.”
“This innovation, packaged as it is, is very appealing to users who have come across Making Data Count and want to proceed with their journey into SPC Charts.”
“SPC are a useful additional tool for assessing variation within and assurance of a process. As such it is important that they are widely available and used. “
The Innovation Programme would like to receive applications from individuals who have an interest in appraising NHS Finance Innovations.
Apply nowIn order for the Forum to be able to allocate its resources in worthwhile areas for the benefit of NHS Finance we are crowdsourcing ideas and problems for assessment, research and development.
Share nowHave you developed an innovation that’s delivering value to your team? Don’t keep it to yourself, submit it to our Innovation Programme.
Submit nowHere are all of the documents and resources related to this innovation