Design Excel Dashboard for HSE with Lagging and Leading Indicators, Graphs, and Tables
Budget: $10 – $30 USD
Looking for experienced professional to design an Excel dashboard for Health, Safety, and Environment (HSE) purposes.
The dashboard should include the following components for each of our 10 site locations:
Lagging and Leading Indicators: Identify and track key indicators for HSE performance at each of the 10 site locations.
Stop Observations Graphs: Visualize and monitor stop observations data for each site to identify areas for improvement.
Fitness to Work Graphs: Display fitness to work metrics for each site, indicating the health and readiness of employees.
Training Matrix Compliance Graphs: Track and display compliance with training requirements at each site using graphical representations.
Driving Violations Graphs: Present driving violation data in graphical format to monitor and address any issues related to driver safety.
Audit and Inspection Graph: Showcase audit and inspection findings in a graphical format to identify trends and prioritize corrective actions.
Man-hours Table and Graph: Summarize man-hours worked at each site in a table and graph to monitor productivity and resource allocation.
Incidents Table and Graph: Compile and visualize incident data for each site, providing insights into safety performance.
Mileage Driven Table and Graph: Display mileage driven by vehicles at each site, enabling analysis of fuel consumption and maintenance needs.
Site Visit Table and Graph: Track and present site visit data in a table and graph to monitor engagement and ensure regular inspections.
Commuting Table and Graph: Summarize commuting data in a table and graph format, providing insights into travel patterns and potential risks.
Action Tracker Table and Graph: Maintain a table and graph for tracking action items and their progress, ensuring timely resolution.
TRIFR, LTIFR, ISR, IR, MVIR, and MVIFR Trend: Monitor and display trends for various safety performance indicators (TRIFR, LTIFR, ISR, IR, MVIR, and MVIFR) at each site.
The dashboard should include the following components for each of our 10 site locations:
Lagging and Leading Indicators: Identify and track key indicators for HSE performance at each of the 10 site locations.
Stop Observations Graphs: Visualize and monitor stop observations data for each site to identify areas for improvement.
Fitness to Work Graphs: Display fitness to work metrics for each site, indicating the health and readiness of employees.
Training Matrix Compliance Graphs: Track and display compliance with training requirements at each site using graphical representations.
Driving Violations Graphs: Present driving violation data in graphical format to monitor and address any issues related to driver safety.
Audit and Inspection Graph: Showcase audit and inspection findings in a graphical format to identify trends and prioritize corrective actions.
Man-hours Table and Graph: Summarize man-hours worked at each site in a table and graph to monitor productivity and resource allocation.
Incidents Table and Graph: Compile and visualize incident data for each site, providing insights into safety performance.
Mileage Driven Table and Graph: Display mileage driven by vehicles at each site, enabling analysis of fuel consumption and maintenance needs.
Site Visit Table and Graph: Track and present site visit data in a table and graph to monitor engagement and ensure regular inspections.
Commuting Table and Graph: Summarize commuting data in a table and graph format, providing insights into travel patterns and potential risks.
Action Tracker Table and Graph: Maintain a table and graph for tracking action items and their progress, ensuring timely resolution.
TRIFR, LTIFR, ISR, IR, MVIR, and MVIFR Trend: Monitor and display trends for various safety performance indicators (TRIFR, LTIFR, ISR, IR, MVIR, and MVIFR) at each site.