A large chain of community hospitals had trouble monitoring operations across its 80+ facilities. Executives wanted to know 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 and hold times etc.
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 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.
The web application took 3 months to develop and deploy in production. Since it was first developed, the IT department continues to add additional metrics depending on business needs.