Civil engineering consultancy · 31 staff · Wollongong
PROJECT HOURS ARE KNOWN SIX WEEKS LATE.
The problem
Timesheets were exported, cleaned by hand and pasted into a project workbook after invoicing.
What we built
An API pipeline from the timesheet system into Power BI project analytics. A daily report lands before work starts.
The result
- Before
- 51,700keystrokes a year
Six weeks late.
- After
- keystrokes a year
06:00 AEST, daily.
A keystroke is one thing a person had to type or click.
| Project | Budget h | Booked h | Left h |
|---|---|---|---|
| P-114 Culvert design | 320 | 212 | 108 |
| P-118 Subdivision, stage 3 | 860 | 790 | 70 |
| P-121 Retaining walls | 140 | 151 | -11 |
| P-126 Stormwater model | 410 | 96 | 314 |
| P-130 Bridge inspection | 95 | 88 | 7 |
| P-133 Car park | 260 | 40 | 220 |
An illustration of the build running, with sample data.
Every job is quoted individually after a free consultation.
Book a free consultation