Business Intelligence in the NHS - Reports, Key Performance Indicators and Dashboards 

Many trusts, SHAs and other organisations need better ways to collate, interpret and share information about their teams, departments and organisation as a whole, to create Business Intelligence.

Cloud2 addresses this need through our knowledge of 4 key technologies:

1. SharePoint includes a number of basic key performance indicator tools as well as the ability to display Excel data and charts through Excel Services¹
2. SQL Reporting Services provides a powerful set of tools for creating reports from complex data sets
3. Microsoft PerformancePoint (now provided with Microsoft SharePoint Server 2007^1,2) offers high order data analysis and visualisation tools together with visually rich dashboards and scorecards
4. CUI Scorecard Enabler (developed by Connecting for Health) offers dashboard and KPI business intelligence solution suitable for proof of concepts, rapid deployment and departmental scenarios¹

Each provides powerful BI solutions: the CUI Scorecard Enabler (free to the NHS) emphasises rapid visualisation of business indicators while PerformancePoint provides a fully capable, enterprise class BI solution. SQL Reporting Services emphasises complex report design, while SharePoint acts as the vehicle for making all these available to the users together with action-orientated collaboration and information access. Collectively they address the full spread of needs and budgets.

If your trust needs some element of business intelligence, whether at a whole trust level or for discrete departments or directorates and either has or is thinking about using SharePoint then we would be delighted to show you what can be achieved. SharePoint acts as the container application for both PerformancePoint and the CUI Scorecard enabler and allows users to access the performance indicators and underlying data that would normally be distributed by email or paper directly and quickly through a browser.

The CUI Enablers are all provided to the NHS free of charge and can be downloaded from the PSPG site.

Cloud2 are one of the country’s leading partners for SharePoint based solutions and have worked closely with Microsoft / CFH to support deployment of the CUI components. We can offer advice and information, BI enhancements to existing SharePoint platforms through to extensive, organisation-wide intranets including BI. Since the Scorecard Enabler is free, BI projects need not be expensive and complex to embark on; project delivery can be a matter of a week or two.

Read the full PDF version (700KB)

¹ Note that use of these generally requires purchase or ECALs. These may also be sourced via Connecting for Health, provided the trust can demonstrate achievement of NIMM level 3 or above.

² Available provided Sharepoint Server was purchased with Software Assurance