Case Studies

Over the years we have developed a fine reputation for delivering innovative and cost-effective solutions to a range of multinational organisations, within both the public and private sectors. With a highly experienced and talented team that is committed to delivering consistently professional results, our clients trust us to conceive, implement and manage expert Business Intelligence and IT solutions, for improved organisational performance.


Burton Hospitals Foundation Trust – Burton upon Trent

This Trust is the principal provider of acute hospital services for the residents of Burton upon Trent and surrounding areas, including: South Staffordshire, South Derbyshire and North West Leicestershire.

Scenario

Burton Hospitals required a range of Business Intelligence Analytics, Data Warehousing, Development and Support services. These included the Development and provision of Support services for a major upgrade of their Patient Administration System (MEDITECH). Additionally, the Trust required consultancy, supervision, management and governance of the V6 Reporting Workstream, prior to and after going live.

Solution

Having evaluated and defined business requirements by working closely with key stakeholders; including a team of Senior Management, Analysts and Developers, the solution was to deliver a suite of mission critical V6 reports for the ‘business as usual’ team.

Further solutions that were developed and delivered for the Trust include:

Outcome

Following the delivery of the V6 Reporting Workstream, along with the design, development and implementation of Business Intelligence solutions and products, Burton Hospitals experienced the following improvements:

  • An overall performance and Data Quality improvement of 90%.
  • An 80% improvement in System Integration.
  • Significant improvements in Cost Efficiency and Productivity.
  • Continuity of operational processes.

 

Technologies utilised: Sharepoint 2013, SSIS, SSRS, QlikView, ASP.NET, VB.NET, C#, SQL 2008 R2, SQL 2012, T-SQL, Access, Excel, MediTech and range of other inter-related software systems and applications.

Brent CCG – London

Brent CCG is a GP member practice organisation, that decides upon and supplies the health services required by the residents of Brent.

Scenario

Brent CCG required a range of Business Intelligence Consultancy services, aimed at the service re-design, migration, process improvement, robustness, support and maintenance, and automation of commissioners and providers KPI NHS datasets for the Performance team.

 

Solution

Having evaluated and defined business requirements by working closely with key stakeholders; including a team of Senior Management, Analysts and Developers, the solution was to deliver a complete Web based interface, automation and upgrades. A robust and cost-effective Web based Solution was developed and implemented to deliver performance improvements for Brent CCG.

Outcome

Following the design, development and implementation of the Business Intelligence solutions, Brent CCG experienced the following improvements:

  • An improvement in data integration and operational processes, resulting in an overall performance gain of 80%.
  • 90% improvement in Data Quality.
  • The Automation of 95% of operational processes.
  • Significant improvements in Cost Efficiency and Productivity.

 

Technologies utilised: SSIS, SSRS, QlikView, ASP.NET, VB.NET, C#, SQL 2008 R2, T-SQL, Access, Excel and MS Project

Royal Surrey County Hospital – Guildford, Surrey 

The Royal Surrey County Hospital is a leading UK General Hospital and specialist tertiary centre for cancer, Oral and Maxillo-facial surgery and pathology.

Scenario

The Royal Surrey County Hospital required a range of Business Intelligence consultancy services, aimed at the service re-design, Dimensional Modelling and automation of Finance and Board Key Performance Indicators.

Solution

Having evaluated and defined business requirements by working closely with key stakeholders; including a team of Senior Management, Analysts and Developers, the solution was to deliver a complete Dashboard and Data Warehousing system.

A robust and cost-effective Dashboard Performance Scorecard was developed and implemented, for the trust executive to achieve vital strategic goals and objectives, while a service re-design was also conducted. This entailed Business Intelligence analysis, solution design and dimensional data modelling, to develop a solution of best fit and deliver performance improvements for Royal Surrey County Hospital.

Outcome

Following the design, development and implementation of the Business Intelligence solutions, Royal Surrey experienced significant improvements in cost efficiency and productivity.

Specifically, the solutions delivered resulted in 95% automation and an 85% improvement in data quality and system integration. Further enhancements to the hospitals data integration and operational processes, resulted in an overall performance improvement of 80%.

Technologies utilised: SSIS, SSRS, QlikView, VB.NET, SQL 2008 R2, T-SQL, Access, Excel and MS Project.

CACI/Ministry of Justice – London

CACI provides a range of Digital Business Intelligence solutions to a wide range of industries, in both the Public and Private sectors.

Scenario

CACI required a range of Business Intelligence consultancy services. These included data analysis, along with the design and delivery of a bespoke Data Warehousing solution, which was to be integrated with Pentaho Business Analytics. Furthermore, CACI required the development of a Case Reporting Tool, for the Ministry of Justice.

Solution

Having evaluated and defined business requirements by working closely with key stakeholders; including a team of Senior Management, Analysts and Developers, we were tasked with developing a Case Reporting Tool for the Ministry of Justice. This provided the Youth Justice Board and Youth Offending Teams a web based Business Intelligence reporting tool, to improve analytics and organisational performance.

Outcome

Following the delivery of the Case Reporting Tool, the Ministry of Justice experienced the following improvements:

  • An overall performance improvement of 85%.
  • A 95% improvement in Data Quality.
  • Significant improvements in Cost Efficiency and Productivity.

 

Technologies utilised: SQL 2012/14, SQL 2008 R2, T-SQL, Pentaho ETL and Analytics, GIT and Source Tree etc.