Case Study 1 | Case Study 2 | Case Study 3 | Case Study 4 | Case Study 5
Case Study: Web Based Utilization Report...
Client
A healthcare information company
Problem
At the firm’s quarterly meetings with their own end-clients, this client needed to show rich, detailed reporting of the efficacy of their care management activities. Given the complexity of each client’s patient load, and the depth of detail to be included, the task of generating the report could take several weeks per client.
Solution
We created a web-based reporting tool to perform multiple levels of calculations and generate a presentation-worthy report, with all necessary patient breakdowns.
Approach & Challenges
The client anticipated needing access from any location (e.g., from a hotel room the night before a client presentation) so we built this as a web-based application on a password protected server. The density of columns and rows made scanning difficult, so we provided a “zoom” feature, using DHTML and CSS. Drill-down reporting was provided by hyperlinking key statistics. Data updates were performed using backend tools. The client quickly came to refer to this report as their “Gold standard” in all discussions of performance metrics.
Technologies
- DHTML
- Active Server Pages
- SQL Server 2000
- XML
- Internet Explorer DOM
- ADO & MTS