Case Study

Business Intelligence Dashboards
Blythedale Children’s Hospital
Location:
NY, USA
Industry:
Healthcare
Environment :
SharePoint 2010
Skills:
Kendo Controls, SSRS, Visual Studio 2012, SQL Server 2012

Blythedale builds Business Intelligence Dashboards on their Intranet Portal using Microsoft SharePoint platform and Kendo UI

About the Client

Found in 1891, Blythedale Children’s Hospital has been focusing to bring up the quality of life for children’s for the past 120 years.

Blythedale is the only independent specialty children’s hospital in New York and a pioneer in developing inpatient programs which are very innovative. Their expertise and the latest resources makes Blythedale one of the largest pediatric therapy department in New York State, providing incomparable comprehensive care for medically complex children and support for their families.

The Challenge

Blythedale wanted an IT platform for its various departments including Medicine, Accounts, Finance, Health Information and other administrative wings, to provide them with Key Performance Indicators for them visually analyze the data and track their progress towards organizational goals. They were also looking for this system to help them with induction and training of new doctors on board. They wanted their data to be represented graphically to their working staff to make efficient use of resources in the hospital and also keep all the department documentations organized.

 

Objectives

Based on our consulting team's discussion with the hospital, following were defined as key pointers to bring up a solution.

- The Inbound and Outbound patient’s records was required to manage the hospital bedding.

- The children’s had to be attended by the nurses timely as per the triage.

- Doctors and Nurses needed a medium to be trained and be up-to-date with the new
research evolutions.

- The requests made for the transportation of children had to be taken as soon as possible
and efficiently.

- Accounts, Billings and Finances needed to be handled with a clear view for the deciders to
come up and make the organization profitable.

Blythedale-1
Blythedale-2
Blythedale-3
Blythedale-4
Blythedale-5

The Solution

Blythedale has a setup an on-premise intranet portal with Microsoft SharePoint 2010 platform. Thus it was decided to leverage SharePoint to meet this specific requirement.

To begin with, a thorough analysis of the data in their ERP was performed, which was later integrated to SharePoint platform. The data was used by providing connectivity in Application Pages of the SQL server in back-end.

This data was used to develop various dashboards with Performance Point Services with Dashboard Designer and Kendo UI framework.

A Census dashbaord was developed to identify patients' details like the admission time, the relieving time, stay, etc. on the daily basis, helping the staff to keep a track of patient aging and hospital occupancy.

Similarly, a Post Discharge Call Follow Up dashboard was developed, where, after the patient is relieved, they call for a follow up status, to know about the patient's health conditions and other details, making it easier for them to keep a check as well as making the data easily accessible.

With Kendo UI, we developed a self-learning module (SLM) for the doctors and the nurses to keep them updated with the current researches and other enhancements in the medical science and technologies.

Blythedale had a transport facility available for the pickups and the drop-offs of the patients. So, in order to keep a track of that as well, a different dashboard was developed where the staff could access the details, and know the status of the transport services.

Also, to follow up with the nurse’s calls, a different dashboard was created for them to keep a track of calls (attended and unattended) on daily, weekly and monthly basis.

We developed the various other dashboards like Impact Dashboards, Quality Dashboards, Census dashboards, Vent Weaning Dashboard, Clinical Indicators Charts, Length of Stay Reports, Referral Dashboard, Vent census, Post Discharge Call Follow Up Dashboard, etc. to name a few using Kendo UI.

SQL Server Reporting Server (SSRS) was configured to generate various financial and accounting reports, for the finance department. Therefore, with this SharePoint custom solution, Kendo UI and SSRS, Binary Republik helped Blythedale implement various dashboards for enhanced productively for its staff and efficient management of their institution.

Benefits

- Dashboards for the census of patients gave the hospital management an idea for in taking and release of
patients without any error.

- Nurses attended all the children’s in the hospital and focused in maintaining the quality of life of children.

- The Visual data gave a clear view to its doctors and staff for taking decisions.

- Accounts and finance department's dashboard had a clear status on the available cash flow along with other
accounts related information.

- Goals for achieving better results in all the departments were set with ease by the charts and graphs.

Let's Get Started

Our proven methodologies and a track record of excellent services backed with by years of experience with SharePoint will ensure a high success ratio and a greater user acceptance.

Let us know what you are looking for and get a quick quote from our SharePoint team!

close
Error Required Field
Error Required Field
Error Required Field
Error Required Field
X
Menu