Case Studies

 

Database migration - A data analyst can help 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, fields in the old system mapped to the new system, with the data then transferred.
Find out more…

 

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.
Find out more…
Ensuring accurate time recording

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…
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.
Find out more…
 
Retrofit - Energy performance metrics tracked using Power BI

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…

Energy performance metrics tracked using Power BI

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…
Are you loosing track of invoices received?

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…

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…

Gantt chart to show periods assets on hire and off hire

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…

Cashflow management - Invoices received versus invoices raised

Proactive cashflow management

Providing clearer visibility of monthly cashflow through a Power BI finance dashboard displayed on a wall mounted monitor.
Find out more…

Pin It on Pinterest

Share This