• Business Intelligence

Canterbury District Health Board

The Oral Health team at Canterbury District Health Board wanted to develop a culture of reflective practice, they understood the value of getting good information out to Clinical Staff and Senior Management but they didn’t know how to do this timely way. They engaged us to develop a solution that would address the key issue of making the patient data more accessible.

Situation

Oral health services for children are managed and delivered by District Health Boards (DHB’s) across New Zealand. As part of normal clinical practice a wealth of information is captured about the patient and the service provided. In most DHBs this data is captured by the Titanium a point-of-care software application and becomes the patient’s electronic dental record.

Utilising this information to improve the quality of child oral health services at the Canterbury District Health Board (CDHB) is the responsibility of Community Dental Service Clinical Director Dr Martin Lee.

“The key driver for us is to improve what we are doing” says Dr Lee, “we follow the IHI’s Triple Aim Initiative which describes an approach to optimising healthcare performance by focusing on three dimensions, Improving Population Health, Improving Patient Experience and Reducing the cost per capita of Health Care”. Dr Lee recognised that they needed to measure if they were to improve. “We needed access to information that would drive better performance in these key areas. We had limited reports and our ability to query and analyse trends from a dental services standpoint needed to improve”.

The point-of-care dental system’s data structure was not designed for easy querying, and thus it was difficult for others coming in to analyse the data as it was unfamiliar and required an in-depth knowledge of the system. “We needed a better way to collate, analyse and view the information we had. The various performance metrics and clinical indicators that we had developed were very manual or required special projects to deliver. They involved using Excel spread sheets and Access databases, which took a lot of time and meant our ability to push information out was unsustainable.”

Solution

The Oral Health team engaged the services of Montage – a Microsoft partner with a gold competency in Business Intelligence - to develop a solution that would address the key issue of making the Titanium data more accessible.

Montage in turn worked closely with Dr Lee, “Having a subject matter expert like Martin who not only understands the business but also has an in-depth understanding of the data is a huge asset in any Business Intelligence project” said Chip Felton, Principal Consultant at Montage”

Montage developed an ‘information layer’ using WhereScape Red data modelling software in conjunction with Microsoft SQL Server, as well as utilising Microsoft Reporting Services to publish the information out to the key stakeholders. “They had all the technology they required” said Felton, “they just needed a team to manage not only the process of introducing a proven Business Intelligence framework but also to manage the requirements and expectations of the stakeholders”.

“Montage are the experts so it was good to have a team of people who could lead the project from start to finish. They had a good approach, understood our business and what we wanted to achieve.”
Dr Martin Lee
Community Dental Service Clinical Director

Results

The Oral Health team engaged the services of Montage – a Microsoft partner with a gold competency in Business Intelligence - to develop a solution that would address the key issue of making the Titanium data more accessible. “Montage are the experts so it was good to have a team of people who could lead the project from start to finish. They had a good approach, understood our business and what we wanted to achieve” said Dr Lee.

Montage developed an ‘information layer’ using WhereScape Red data modelling software in conjunction with Microsoft SQL Server, as well as utilising Microsoft Reporting Services to publish the information out to the key stakeholders. “They had all the technology they required” said Felton, “they just needed a team to manage not only the process of introducing a proven Business Intelligence framework but also to manage the requirements and expectations of the stakeholders”.

“The project was certainly well managed and communicated” said Dr Lee, “we were provided with good detail so understood what we were getting from the start. My expectations were that it would be delivered on time and to specification and it was.”
Dr Martin Lee
Community Dental Service Clinical Director