North Tees and Hartlepool maintained an ever-increasing amount of data in an on-premises EMIS Health clinical intelligence system. They had been using Crystal Reports software to analyse their pharmacy data, however they did not know the restrictions of this software.
EMIS Health proposed that North Tees and Hartlepool became a test site for a new, self-service, BI toolset to use with EMIS Health data. EMIS Health’s Business Intelligence team specialise in providing effective intelligence solutions in healthcare, so were ideally placed to take up the task of creating the toolset for North Tees and Hartlepool.
A new BI toolset
The new toolset is part of Microsoft Office 365, called Microsoft Power BI. Power BI includes four key tools:
- Power Query to find and access data
- Power Pivot to create data models for analysis
- Power View to produce highly visual reports
- Power Map to integrate data with 3-D geospatial maps
Faster data analyses
To demonstrate the possibilities of Power BI, EMIS Health took an extract of the trusts data and imported it into a Power Pivot model. Using Power BI reduced the time needed to create the report by 80%.
The team then used Power Query to identify and incorporate other external data sets that related to the initial report.
View results with ease
Professor Philip Dean, Head of department of pharmacy at the trust says that the ability to link disparate data sets for an integrated analysis was “one of the ‘wow’ things” that impressed him most in his use of Power BI.