Chart library

The chart types the engine and its Power BI output use.

11 chart types, grouped by the job each does, each with a worked example on the same synthetic Meridian Bank data. Pick the shape that answers the question - not the one that looks busiest.

Sickness episodes by weekdayMeridian Bank - demo dataMonTueWedThuFriSatSunMon + Fri = 61.6% of episodes

A monthly average hides the pattern.

One department here starts 61.6% of its sickness episodes on a Monday or Friday; the others sit between 26.7% and 29.5%. A single organisation-wide figure would look ordinary. This view points straight at the days to look at.

The kind of signal the engine surfaces - and a person investigates.

Comparison

Absence days per employee, by departmentMeridian Bank - demo data036912org avg 7.49.2Retail7.8Ops5.1Finance4.6Tech6.3HR11.4ContactContact Centre: 2.5x the Finance rate

Bar / column

Contact Centre runs 2.5x the Finance absence rate.

Question it answers: Which department, location or team has the most or least of something?

Rank teams, locations or categories against each other on one measure - absence, attrition, headcount or pay.

Attrition (bars) vs headcount (line)Meridian Bank - demo dataattr %HC

Combo (line + column)

Attrition and headcount rise together over the year.

Question it answers: How does a rate move at the same time as the thing behind it?

Read a rate against the thing that drives it - attrition against headcount - on two scales in one frame.

Trend

Absence rate (%), rolling 12 monthsMeridian Bank - demo data0%2%4%6%8%target 5%JFMAMJJASOND6.4% peak

Line

Absence has sat above the 5% target since June.

Question it answers: Is this getting better or worse over time?

Track a measure over time so the direction, and the point it turned, are obvious.

Part-to-whole

Workforce by contract typeMeridian Bank - demo data1,284peoplePermanent78%Fixed-term12%Contractor6%Casual4%Stable core: 78% permanent

Doughnut / donut

A stable core: 78% of people are permanent.

Question it answers: How is the workforce made up?

Show the make-up of a whole - contract type, gender or age band - when composition matters more than exact figures.

Relationship

Tenure vs flight riskMeridian Bank - demo dataflight-risk 0.80 yrs11+ yrsflight risk

Scatter

Several long-tenure people still cross the flight-risk line.

Question it answers: Are two things related, and are there outliers?

Plot one measure against another for each person or team - tenure against flight risk - to show correlation and outliers.

Team engagement vs absence (bubble = size)Meridian Bank - demo dataOperationsabsenceengagement

Bubble

Operations is the largest team and the furthest from the norm.

Question it answers: Does a relationship hold once size is taken into account?

A scatter with a third dimension shown as size - engagement against absence, sized by team.

Profile / radial

Team profile - Retail vs organisationMeridian Bank - demo dataAbsenceAttritionEngagePerformPayAbsence is the stretched axis; the rest track the norm

Radar

Absence is the stretched axis; the rest track the organisation.

Question it answers: How does one team compare with the organisation across several factors at once?

Put one team against the norm across five or six measures - where it is strong, where it is stretched.

Sickness episodes by weekdayMeridian Bank - demo dataMonTueWedThuFriSatSunMon + Fri = 61.6% of episodes

Polar area

Monday and Friday carry 61.6% of sickness episodes.

Question it answers: Is there a cyclical pattern, such as by weekday or month?

Show magnitude around a cycle - it catches a Monday and Friday sickness pattern that an average would hide.

Single number

Headline KPIsMeridian Bank - demo dataHeadcount1,284+2.3% vs last monthAbsence rate6.1%above target 5.0%

Card (KPI)

Absence is 1.1 points above target - the number to watch.

Question it answers: What is the headline number right now?

One figure and its movement - headcount, FTE or absence rate - for the top of a board page.

Detail

Department matrix - key measuresMeridian Bank - demo dataDeptHCAttr %AbsRetail4127.89.2Operations3566.17.8Finance1484.25.1Technology2019.44.6Contact6712.811.4

Table / matrix

Contact Centre pairs a small team with the highest attrition.

Question it answers: What are the exact figures behind the chart?

The exact figures in a cross-tab - department by measure - for the reader who needs the number, not the shape.

Control

Department filterMeridian Bank - demo dataAllRetailOperationsFinanceTechnologyAll departments: 6.4% absenceRetail selected: 9.2%

Slicer (filter)

Filtering to Retail lifts absence from 6.4% to 9.2%.

Question it answers: What happens when I look at just my department or site?

A filter that re-cuts every chart to a department, location or period, without rebuilding anything.