Business dashboard template: WORK ACCIDENTS

dashboard template for tableau on Insurance Work Accidents Work Accidents cockpit

Providea workbookcontaining at least22 attributes

Geta ready-to-use,best-in-marketWORK ACCIDENTS dashboard

Work Accidents Home

Get a Home Page for your Work Accidents dashboard

Work Accidents Cockpit

Get an overview of all the work accidents

Work Accidents Top Performers

Get an instant understanding of your top Work Accidents performers: current, mid and long term performance

Injuries per Doctor

Instantly identify which doctors are impacting the most the total work interruptions and quickly identify who tends to over estimate the work interruptions compared to other doctors

22 required attributes

Accident #
Accident Occurrence Date
Accident Nature
Accident Circumstances
Work Accident Flag
Serious Accident Flag
Accident Status
Contract #
Client
Client Type
Victim
Victim Birth Date
Victim Gender
Victim Professional Status
Victim Deceased Flag
Injury Location
Injury Nature
Injury Status
Doctor
Appeal Status
Reject Reason
Work Interruption (days)

12 KPIs

8 dashboard pages

Required Attributes

To get your Work Accidents dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):

Accident # Accident Unique Identifier
Accident Occurrence Date Date when the accident occured (Date used for time-series analysis)
Accident Nature Work Accident, Accident private life...
Accident Circumstances Accident circumstances
Work Accident Flag "Y" if the accident is work accident
Serious Accident Flag "Y" if the accident is serious
Accident Status Status: Accepted, On-hold, Refused...
Contract # Insurance Contract Unique Identifier
Client Insurance Contract Client
Client Type Type of clients
Victim Victim of the accident
Victim Birth Date Birth date of the victim
Victim Gender Male, Female
Victim Professional Status Worker, Employee...
Victim Deceased Flag "Y" if the victim died
Injury Location Head, Arm, Shoulder...
Injury Nature Burns, Fractures, Lesions...
Injury Status Healed, Consolidated with sequelae...
Doctor Doctor
Appeal Status No appeal, On-going appeal...
Reject Reason Not due to work, Prescription, No evidence...
Work Interruption (days) Temporary Interruption of Work (days), 0 is none, Null if not applicable

KPIs

Your WORK ACCIDENTS dashboard will contain 12 KPIs

Nb of AccidentsNumber of accidents
Nb of Work AccidentsNumber of work accidents
Work Accidents %Share of work accidents
Nb of Serious AccidentsNumber of serious accidents
Serious Accidents %Share of serious accidents
Nb of Accidents with Work InterruptionNumber of accidents with work interruption
Accidents with Work Interruption %Share of accidents with work interruption
Avg Work InterruptionAverage work interruption for all accidents (days)
Total Work InterruptionTotal work interruption for all accidents (days)
Nb of VictimsTotal number of victims
Victim AgeAverage age of victim
Nb of DeceasesNumber of deceases

Dashboard Pages & Data Visualizations

Your Work Accidents dashboard will contain 8 pages

Home

Work Accidents Home

Get a Home Page for your Work Accidents dashboard

Cockpit

Work Accidents Cockpit

Get an overview of all the work accidents

Work Accidents Top Performers

Get an instant understanding of your top Work Accidents performers: current, mid and long term performance

Top 4 KPIs Trends (MTD/YTD)

Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Accidents Analytics

Injuries per Doctor

Instantly identify which doctors are impacting the most the total work interruptions and quickly identify who tends to over estimate the work interruptions compared to other doctors

Accidents per Client

Get an overview of all your clients regarding accidents & work interruptions

Accidents per Victim Age

Get an overview of all accidents split by range of victim age

Behavioral Analytics

Work Accidents Adhoc Analysis

Perform simple ad-hoc analysis on your Work Accidents data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

Creating your WORK ACCIDENTS dashboard Step-by-Step

You want to get a clear understanding on your Work Accidents results? You want to build a Tableau dashboard to better understand your Work Accidents data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Work Accidents data in less than 5 minutes!

Work Accidents dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Work Accidents data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

Accident # Accident Unique Identifier
Accident Occurrence Date Date when the accident occured (Date used for time-series analysis)
Accident Nature Work Accident, Accident private life...
Accident Circumstances Accident circumstances
Work Accident Flag "Y" if the accident is work accident
Serious Accident Flag "Y" if the accident is serious
Accident Status Status: Accepted, On-hold, Refused...
Contract # Insurance Contract Unique Identifier
Client Insurance Contract Client
Client Type Type of clients
Victim Victim of the accident
Victim Birth Date Birth date of the victim
Victim Gender Male, Female
Victim Professional Status Worker, Employee...
Victim Deceased Flag "Y" if the victim died
Injury Location Head, Arm, Shoulder...
Injury Nature Burns, Fractures, Lesions...
Injury Status Healed, Consolidated with sequelae...
Doctor Doctor
Appeal Status No appeal, On-going appeal...
Reject Reason Not due to work, Prescription, No evidence...
Work Interruption (days) Temporary Interruption of Work (days), 0 is none, Null if not applicable

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Work Accidents' and upload your Tableau workbook (note: your data is NOT uploaded).

Collapse All Expand All