Hospital Dashboard for CXO to analyze and capture the KPI’s in a real-time basis.
Our Client has a chain of community hospitals that operates across 80+ regions. They wanted a Healthcare dashboard for a better understanding of their operational performance.
A large chain of community hospitals had trouble monitoring operations across its 80+ facilities. Executives wanted to be aware of the data analysis which would show how each facility was performing at the moment; but the only way to find out was to login to 3 different systems for various metrics. Even more frustrating, there were 2 different Hospital Management Systems in use, and that made reporting across facilities even more difficult.
We built a custom web application with a Real Time dashboard for Executives. This application provided visibility into metrics such as patient pathway, wait times by department, occupancy reports, admission & hold times and much more on the healthcare dashboard.
At HashedIn, we choose the best tool available for the job, even if it means going with an off-the-shelf production. However, in this case, we chose not to use an existing healthcare solution such as Tableau or Qlik for the following reasons:
The per user license model would quickly get very expensive given the number of users that needed access to metrics The metrics were well defined and didn’t require a lot of ad-hoc reporting, so they wouldn’t benefit from a drag-and-drop style DIY tool Most of the work involved integrating with multiple inhouse systems and building a star-shaped schema for the metrics. The tools wouldn’t help much in doing this.
It took 3 months to develop and deploy the web application for Healthcare Dashboard. The client was benefitted with the following features after the dashboard went live.
- Data pipeline - to pull raw data from multiple HMS’ and other internal systems on a 5 minute frequency, perform normalization and aggregation, and finally store the derived metrics in a MySQL based star schema.
- Customizable Alerts - on any metric, with custom thresholds. Allowed executives to react to issues as they occur.
- Modern Responsive UI - using HighCharts for charting, Angular JS web framework, and REST APIs to fetch metrics.
- Authentication - Integration with Active Directory to only allow authorized users access to metrics.
- Easy to add additional Metrics - A declarative mechanism to add additional metrics by simply writing a SQL query.