Case Studies

 

Database migration - move data from an old database to a new database

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.

 

Community mapping and planning case study

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 time recording

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 versus actual displayed in Power BI

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 - Energy performance metrics tracked using Power BI

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.

 

Energy performance metrics tracked using Power BI

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. 

 

Are you loosing track of invoices received?

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.

Gantt chart to show periods assets on hire and off hire

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.

Pin It on Pinterest

Share This