HR ANALYTICS
Click on the image to view the interactive dashboard
-
The HR Analytics dashboard provides a comprehensive and granular view of employee attendance, work-from-home (WFH) rates, and sick leave (SL) percentages over a three-month period (April to June 2022).
-
The overall presence rate for this period is 91.83%, indicating a high level of attendance across the workforce.
-
However, the WFH rate shows a marked increase from 9.59% in April to 23.44% in June, suggesting a growing trend towards remote work.
-
Concurrently, SL rates, which started at 0% in April, rose to 5.42% by June, indicating an increase in employee sick days.
-
Daily analysis reveals that Mondays have the highest presence rate at 93.21%, gradually decreasing towards the end of the week, with Fridays at 90.19%.
-
WFH and SL percentages follow distinct patterns, with the highest WFH rate on Fridays (13.01%) and the lowest SL rate also on Fridays (0.70%).
-
Individual employee data highlights significant variations, such as Gregory Carr's 100% WFH rate and Ayanna Atkins' 10.71% SL rate, reflecting diverse working conditions and health statuses among employees.
-
These insights enable HR managers to identify trends, address issues, and optimize workforce management strategies effectively.
HEALTHCARE ANALYTICS
Click on the image to view the interactive dashboard
-
The Emergency Room Visit Report dashboard provides an overview of patient visits and associated metrics, offering valuable insights into the functioning and efficiency of the emergency department.
-
At the top of the dashboard, the total number of emergency room visits is prominently displayed, amounting to 9,216 visits, with a nearly even split between administrative (50.04%) and non-administrative (49.96%) appointments.
-
​The dashboard also features an average patient satisfaction score of 5.47, which provides a snapshot of how patients perceive the quality of care they received during their visits.
-
Additionally, it is noted that 75.10% of the services were not rated by patients, pointing to a significant portion of visits where patient feedback was not captured.
-
Another critical metric displayed is the average wait time, recorded at 35.26 minutes. This measure is crucial in emergency room settings, where long wait times can affect patient outcomes and satisfaction.
-
The dashboard further distinguishes between visits that occurred on weekdays versus weekends, with 6,574 visits happening on weekdays and 2,642 on weekends. This disparity highlights the higher volume of patients on weekdays, which might suggest peak operational hours and potential staffing considerations.
-
The dashboard also tracks patient visits over the years, with a noticeable increase from 4,338 visits in 2019 to 4,878 in 2020. This upward trend could indicate growing demand for emergency services or changes in healthcare-seeking behavior.
-
Furthermore, the dashboard includes a trend line that tracks total patient visits across the months, providing a visual representation of how visit volumes fluctuate throughout the year.
-
​Lastly, the dashboard features a heatmap that details average wait times by race, where green indicates lower wait times and red signifies higher wait times. This visual representation can help identify disparities in wait times among different racial groups, prompting further investigation into potential causes or areas for improvement.
-
Overall, this dashboard serves as a powerful tool for hospital administrators and healthcare providers, enabling them to monitor key performance indicators, patient demographics, and service efficiency in the emergency department.