Improving efficiencies across healthcare settings with powerful business intelligence

Anglia Support Partnership is helping healthcare commissioners improve operations, cut costs, and adapt to change with a Business Intelligence solution from EMIS Health and Microsoft.

Anglia Support Partnership (ASP) is the leading provider of support services to healthcare organizations in eastern England, including general practitioners and NHS trusts. A business division of the NHS, the support group focuses on helping healthcare organisations improve efficiency and cut costs. With new healthcare reforms taking effect, ASP wanted better business intelligence (BI) tools to support healthcare commissioning processes.

Jeremy Lane, Data Warehouse Manager at ASP says “We needed to deliver data to general practitioners and practice managers whose main role is not analysing data, they’ve got the far more important job of looking after patients.”

“We wanted a more automated, centralised solution”

Jeremy Lane, data warehouse manager at ASP

Enterprise wide BI solution

ASP sought an enterprise-level BI solution that would simplify access to data. Lane says, “We wanted a more automated, centralised solution so that people could find the right information more quickly.”

ASP turned to EMIS Health, a Microsoft partner with a gold competency in business intelligence, to help design a centralised BI platform with self-service tools based on Microsoft SQL Server 2012 data management software. “We were already using SQL Server 2008 R2 internally, and we knew that EMIS Health worked with it too,” says Lane. “And with all the new BI features available, it seemed like a good opportunity to implement SQL Server 2012.”

Enhanced operational efficiency

ASP believes that the BI solution will help healthcare organisations handle change more easily and affordably. As a result, family doctors will be able to focus on patient healthcare instead of managing data. “Managing information will be the key to staying on top of healthcare reform,” says Lane. “If you want to create a better National Health Service with less money than was available in the past, you need to put the right information in front of the right people,” says Lane. “A BI solution based on SQL Server 2012 helps us do that in a managed, straightforward, and intuitive way.”

Improves Flexibility and Insight

ASP is confident that it has found the right self-service BI tools for diverse healthcare organizations, from national trusts to general practitioners. “We want to provide information in a meaningful manner so that end users can ask their own questions,” says Paul Brenchley, Strategic Account Manager at EMIS Health. “Power View in SQL Server 2012 is a very elegant way to visually display and interrogate data.”

ASP believes that commissioners can use the new tools to improve management in multiple scenarios, including patient admissions and billing procedures. “Identifying trends and asking ‘what if’ types of questions are the sort of things people will want to do going forward,” says Lane. “Power View in SQL Server 2012 is quite a good exploratory tool for such purposes because it’s fast and very intuitive to use.”

Eases Management and Speeds Reporting

Now, both ASP and end users can work more efficiently. “Using Power View in SQL Server 2012 will be a much faster way to produce reports,” says Lane. “Instead of spending hours creating custom tables and queries for users, we can quickly put together a data model in SQL Server 2012 that they can use to produce reports within minutes.”