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. Q017 Medium Turnover in 2025
  2. Q018 Medium Logistics' turnover
  3. Q019 Medium Overtime as a share of pay
  4. Q020 Medium Payroll growth
  5. Q021 Medium Cost per head, December 2025
  6. Q022 Medium Cost per head, a year earlier
  7. Q023 Medium Payroll against the ledger
  8. Q024 Medium What the Logistics head-office line holds
  9. Q025 Medium Settlements paid late
  10. Q026 Medium How long leavers wait
  11. Q027 Medium Headcount against plan
  12. Q028 Medium Logistics' financial year
  13. Q029 Medium Year to date
  14. Q030 Medium Months of heavy overtime
  15. Q031 Medium Notice periods
  16. Q032 Medium Leave approved after it started
  17. Q033 Medium Emiratisation in Logistics
  18. Q034 Medium Average service
  19. Q035 Medium Women on the payroll
  20. Q036 Medium Manufacturing's overtime peak

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