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, mapped to the fields in the new system, with the data then transferred.
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.
Ensuring accurate billing to clients
To ensure billing accuracy to clients, a Power BI report was developed which 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.
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.
Retrofit - Tracking performance metrics
Tasked with improving the energy efficiency of domestic properties, the client requested a Power BI report accessible to both internal and external stakeholders. The report is a valuable tool for monitoring the project’s progress and quantifying the energy saving achieved through the implemented improvements.
Data cleanse new asset hire system
Leveraging their project management skills, the client creates processes designed to optimise asset tracking and billing. New processes and new systems require a settling in period and often result in accidental errors arising. Regular data cleansing of the new system helps spot and correct any anomalies arising.
How quick are suppliers paid?
Bottlenecks in the invoice approval process had resulted in the late payment of invoices. Through moving data to a new system, there is now greater visibility of the workflow if each invoice along with clarity on the number of invoices and the value of the invoices outstanding at each stage.
Inspections - Tracking the status
Tracking the status of inspections, snagging items resolved, and the timely raising of invoices was becoming time consuming. The report supports the work undertaken by providing links to supporting photos, and access to invoices raised eliminating the requirement to attach supporting documentation to each invoice.
Find the off-hire periods
An internal system tracks the dates assets are/will be rented out to third parties. However it was not quite so easy to view the dates the assets were off-hire or the total number off-hire at the same time. To address this, a Power BI report was created to providing a clear view of the on-hire and off-hire periods.
Proactive cashflow management
Providing clearer visibility of monthly cashflow through a Power BI finance dashboard displayed on a wall mounted monitor.