DD17 Payroll Cost: how it was built
Is payroll growing because of more people or higher pay, and where does overtime cost money? Rebuild this dashboard step by step in the Data Canvas.
DD17 · Payroll Cost
Code in this build: 7 widgets written in SQL, and 4 filter, chart or pivot settings written as code.
The question: Is payroll growing because of more people or higher pay, and where does overtime cost money?
Who asks, and when: The HR and finance controller, monthly.
The decision: Whether payroll is growing because of more people or higher pay, and where overtime costs money.
What the dashboard shows: Payroll grew because Engineering hired: 20 engineers joined in 2025 against 4 who left, 40 people became 56, and of the 17,000.63 a month the department costs more than a year ago, 23,530.06 is the extra people and -6,529.43 is pay - the new engineers came in below its average. Overtime is the other pressure and it is the warehouse's: about 180 hours a month, then 539.9 in November 2025 and 531.3 in December, 2.98 times the rest of the year.
Follow the pictures below, in order, and you end up with the same dashboard. Every step is one thing you do in the Data Canvas, on the demo data that installs with DataPallas.