Skip to main content
Data Dare project management & project accounting L3 sticker: the findi360 mascot analysing Mizan Group: Four Programmes, One Cut-off — Project Management & Project Accounting.

DD-PRJ-003

Mizan Group: Four Programmes, One Cut-off — Project Management & Project Accounting

The Mizan group - a supermarket chain, a manufacturer and a logistics company - ran four programmes between 2023 and 2026: store expansion and refurbishment, a plant line expansion with the plants' overhauls, fleet renewal with a client mobilisation, and a group ERP rollout. You get every project and task with baseline and actual dates, monthly planned value and % complete, every invoice (the same lines as the ledger set DD-GLT-003) with its capitalisation date, the purchase orders behind them (DD-PRC-003), change requests with their approval times, the project managers' monthly forecasts, milestones with the client's billing, the holiday calendar and 100,000 timesheet lines - in Parquet, CSV, JSON and Excel, with no date table. Build the earned-value picture, close the books at 31 December 2025, and find what the controls missed.

  • Project Management & Project Accounting
  • L3 · PARQUET
  • ~100,815 rows
  • 12 tables
  • 50 questions
Get the data 50 questions
Free account: download the data, check your answers and earn a certificate. Create it → More Project Management & Project Accounting: L1

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-PRJ-003_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-PRJ-003_Data_Dictionary.xlsx 14.8 KB · v1.0
  • Business Introduction PDF DD-PRJ-003_Business_Introduction.pdf 616.8 KB · v1.0
  • Relationship Diagram PDF DD-PRJ-003_Relationship_Model.pdf 616 KB · v1.0
  • Raw fact data DD-PRJ-003_FactTimesheet.parquet 2.3 MB · v1.0
  • Dimension / supporting data DD-PRJ-003_Dimensions.zip 74.4 KB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Projects across the group
  2. Q002 Easy Original budget of the portfolio
  3. Q003 Easy What the projects paid
  4. Q004 Easy Fleet renewal spend
  5. Q005 Easy Timesheet lines in 2025
  6. Q006 Easy Chargeable hours on the plant expansion
  7. Q007 Easy Change requests raised
  8. Q008 Easy Milestones achieved late
  9. Q009 Easy Public holidays in 2025
  10. Q010 Easy Purchase orders behind the projects
  11. Q011 Easy The client's milestone billing
  12. Q012 Easy Revised budget of the hypermarket
  13. Q013 Medium Actual cost of the ERP programme
  14. Q014 Medium ERP programme overrun
  15. Q015 Medium Earned value of ERP-RET at 31 March 2025
  16. Q016 Medium SPI of ERP-RET at 31 March 2025
  17. Q017 Medium CPI of ERP-RET at 31 March 2025
  18. Q018 Medium SPI of the plant expansion at 30 September 2024
  19. Q019 Medium Commissioned, then the customer left
  20. Q020 Medium The largest overrun in money
  21. Q021 Medium Employee utilisation by company, 2025
  22. Q022 Medium And its utilisation
  23. Q023 Medium How long approval takes
  24. Q024 Medium Timesheets entered two weeks late
  25. Q025 Medium Hours booked on public holidays
  26. Q026 Medium The month with the fewest hours
  27. Q027 Medium Change requests approved after the work was invoiced
  28. Q028 Medium When the forecast admitted the overrun
  29. Q029 Medium Final forecast against the final cost
  30. Q030 Medium Spend by company on capital projects
  31. Q031 Hard Committed but not invoiced at 31 December 2025
  32. Q032 Hard Work done but not invoiced at 31 December 2025
  33. Q033 Hard Assets under construction at 31 December 2025
  34. Q034 Hard Capitalised before the project finished
  35. Q035 Hard And how much
  36. Q036 Hard Billed ahead of progress
  37. Q037 Hard A project that never pays back
  38. Q038 Hard Sixteen hours on two companies
  39. Q039 Hard Who
  40. Q040 Hard Average slip of go-lives and openings
  41. Q041 Hard CPI of the plant expansion at completion
  42. Q042 Hard Overrun against the revised budget
  43. Q043 Very Hard Estimate at completion of ERP-MFG at its planned go-live
  44. Q044 Very Hard The project manager's forecast against the formula
  45. Q045 Very Hard The ERP programme's CPI at the year end
  46. Q046 Very Hard Store-months the group never saw
  47. Q047 Very Hard How much of the hypermarket overrun was ever authorised
  48. Q048 Very Hard Capital cost per crew hour
  49. Q049 Very Hard The project manager with the worst record
  50. Q050 Very Hard Logistics project labour, fiscal 2025-26

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