Tableau dashboard for International Medical Hospital
The hospital previously had reporting systems in place, but they were outdated and did not meet current needs. In response, we developed a Tableau dashboard that includes all the necessary functionalities for monitoring both the hospital and its various departments.
Challenges: The hospital faced certain administrative issues, such as the inability to keep track of active licenses due to the limitations of the old dashboard, which failed to provide timely alerts to the relevant authorities. Additionally, doctors' performances were not monitored in a user-friendly and interpretable manner, and there was no opportunity for comprehensive analysis of department activities. As a result, important patterns were concealed, including (A) the distribution of emergency visits of varying severity over a 12-month period, and (B) significant factors leading patients to cancel their surgeries.
Solutions: We developed a tailored web dashboard capable of sending scheduled email alerts to designated personnel. Each doctor's performance metrics were clearly outlined, making it straightforward to understand and evaluate them. This allowed for systematic analysis of different departments at various levels. Furthermore, charts and graphs were created to highlight trends and seasonal variations in various parameters. The client could easily update their data, and the dashboard would immediately reflect the updated reports.