Skip to main content
Data Dare hr & payroll analytics L2 sticker: the findi360 mascot analysing Mizan Manufacturing and Logistics: Two Payrolls, One Ledger — HR & Payroll Analytics.

DD-HRM-002

Mizan Manufacturing and Logistics: Two Payrolls, One Ledger — HR & Payroll Analytics

Mizan Manufacturing (two plants, a warehouse and sales offices) and Mizan Logistics (eight depots, its year running April to March) - 830 people. You get every pay line by element from January 2023 - 108,581 rows to June 2026 as CSV and the latest quarter as a separate Parquet file - the employees (JSON), cost centres, leave, exits and final settlements, the headcount budgets and the salary journal of the general ledger. There is no calendar. Make payroll agree with the ledger, find the settlements paid late - and the gratuity one payroll system got wrong.

  • HR & Payroll Analytics
  • L2 · CSV
  • ~108,581 rows
  • 8 tables
  • 40 questions
Get the data 40 questions
Free account: download the data, check your answers and earn a certificate. Create it → More HR & Payroll Analytics: L1 · L3

Get the data

v1.0 · 6 files

Files are for members. A free account takes a minute, and you come straight back here.

Create a free account Sign in
  • Question Book PDF DD-HRM-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-HRM-002_Data_Dictionary.xlsx 12.3 KB · v1.0
  • Business Introduction PDF DD-HRM-002_Business_Introduction.pdf 615 KB · v1.0
  • Relationship Diagram PDF DD-HRM-002_Relationship_Model.pdf 614.9 KB · v1.0
  • Raw fact data DD-HRM-002_FactPayroll.csv 7.6 MB · v1.0
  • Dimension / supporting data DD-HRM-002_Dimensions.zip 231.9 KB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Headcount at 31 December 2025
  2. Q002 Easy Payroll paid in 2025
  3. Q003 Easy Leavers in 2025
  4. Q004 Easy Joiners in 2025
  5. Q005 Easy Overtime paid in 2025
  6. Q006 Easy Gratuity paid in 2025
  7. Q007 Easy Leave encashment in 2025
  8. Q008 Easy Annual leave taken in 2025
  9. Q009 Easy Sick leave in 2025
  10. Q010 Easy The latest quarter
  11. Q011 Easy Logistics' people
  12. Q012 Easy UAE nationals on the payroll
  13. Q013 Easy The busiest overtime month
  14. Q014 Easy The ledger's salary line
  15. Q015 Easy Basic pay in 2025
  16. Q016 Easy Deductions in 2025
  17. Q017 Medium Turnover in 2025
  18. Q018 Medium Logistics' turnover
  19. Q019 Medium Overtime as a share of pay
  20. Q020 Medium Payroll growth
  21. Q021 Medium Cost per head, December 2025
  22. Q022 Medium Cost per head, a year earlier
  23. Q023 Medium Payroll against the ledger
  24. Q024 Medium What the Logistics head-office line holds
  25. Q025 Medium Settlements paid late
  26. Q026 Medium How long leavers wait
  27. Q027 Medium Headcount against plan
  28. Q028 Medium Logistics' financial year
  29. Q029 Medium Year to date
  30. Q030 Medium Months of heavy overtime
  31. Q031 Medium Notice periods
  32. Q032 Medium Leave approved after it started
  33. Q033 Medium Emiratisation in Logistics
  34. Q034 Medium Average service
  35. Q035 Medium Women on the payroll
  36. Q036 Medium Manufacturing's overtime peak
  37. Q037 Hard Gratuity underpaid
  38. Q038 Hard Gratuity shortfall
  39. Q039 Very Hard End-of-service liability at 31 December 2025
  40. Q040 Very Hard Leave liability at 31 December 2025

General discussion

Anything about this dataset that is not one question — loading the files, which tool, how you set it up.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in