Case Studies
Data migration - clean, map, transfer
The client had an old Access database system and wished to move the data to a new more efficient, reliable and faster system. The data was tidied up, fields in the old system mapped to the new system, with the data then transferred.
Find out more…
Find out more…
Your Community, Mapped!
Tasked with planning community services, a local community council sought to identify the streets and schools within each council ward boundary. An interactive community map aided with answering these questions.
Find out more…
Find out more…
Ensuring accurate billing to clients
To ensure accurate client billing, a Power BI report provides details of the time spent per project, the type of activities performed, and highlights any potential discrepancies in recorded time allowing for corrective action to be promptly taken.
Find out more…
Find out more…
Project status: Target vs Actual
To keep all staff informed on project status compared to target, a Power BI report provides a summary. This summary is displayed on an office monitor and automatically updated daily.
Find out more…
Find out more…
Retrofit - Tracking performance metrics
A Power BI report tracks domestic property energy efficiency improvements. The report is a valuable tool for monitoring the progress of the implementation of the improvements and quantifying the energy saving achieved.
Find out more…
Find out more…
Data cleanse new asset hire system
A project management consultancy implemented new processes to optimise asset tracking and billing. During the settling in period, regular data cleansing helps identify and correct any accidental errors or omissions.
Find out more…
Find out more…
How quick are suppliers paid?
Bottlenecks in the invoice approval process resulted in the late payment of invoices. A new system provides greater visibility of each invoice’s workflow status with greater clarity on the number and value of invoices outstanding at each stage.
Find out more…
Find out more…
Inspections - Tracking the status
A Power BI report streamlines the tracking of the status of inspections and snagging items resolved by providing links to supporting photos and access to the invoices raised eliminating the requirement to attach supporting documentation to each invoice.
Find out more…
Find the off-hire periods
Whilst the client’s internal system tracks asset rental periods to third parties, it lacked visibility of off-hire dates and the total number of days offhire. A Power BI report was created to clearly display both on-hire and off-hire periods in a single view.
Find out more…
Proactive cashflow management
Providing clearer visibility of monthly cashflow through a Power BI finance dashboard displayed on a wall mounted monitor.
Find out more…