+61 2 9570 3160

UniPhi Blog

UniPhi 14 - RESTful API linked to PowerBI

Mark Heath, 31 Jul 2018

UniPhi 14 provides an enormous stride forward for users in accessing their data. During this release, we expanded our RESTful API to include a lot more endpoints. The RESTful API provides a user friendly way of accessing UniPhi data without needing to understand the relationships across 400 tables and the business logic embedded within the UniPhi app. Using PowerBI, users can connect to an "end point" or table of information using the "Web" connector available from the "Get Data" function in PowerBI.

API documentation will be published as part of our 14 release and one of the key uses for this API is connecting the "end points" to PowerBI. This connection enables end users to design their own live dashboard reports and analyse their data in new and fascinating ways.

We have also created some standard dashboards to assist users in getting started. These will be presented as PBIX files (The PowerBI file extension) for users to download and then open in PowerBI desktop, a free desktop application downloadable from Microsoft.

There will be webinars on this new feature in coming weeks and its sure to be the biggest hit of the release. Here's some screenshots from our Major Projects demo site.

Cost Benchmarking

Geographic analysis

Financial performance

Timeline with key milestones - beats a Gantt Chart!


Share this:

UniPhi 14 - Tactical resource planning

Mark Heath, 30 Jul 2018

A more intriguing left field feature of UniPhi 14 is what we're calling tactical resource planning. As usual, a spreadsheet was shared with us from a client who said, can you help improve this. It was a one month look ahead resource by resource, project by project and task by task. The spreadsheet was updated by over 100 people! The summary sheet highlighted over and under allocations which was excellent information for management but oh what a nightmare to collect.

The problem was a distributed data capture problem that lends itself to a web based portfolio application as a solution. And, with the penny dropping that what they were after was a forecast of their timesheet, the solution became a simple one. End users were already entering actual hours, if we replicated this interface, they could enter forecast hours too.

Now, all staff members enter in what they expect to be working on, in collaboration with their project managers, over a rolling 4 week period. The summary report is run and resourcing issues identified by senior management.

Sample screen - before the first amendment to include comments
Summary report on overs and unders

Once again, working closely with clients and their end users has resulted in a nifty little tool for all our users. I can't wait for the feedback (which has already lead to a new comments field) and the inevitable improvements that ensue.


Share this:

UniPhi 14 - Defects Management

UniPhi Software, 25 Jul 2018

4 years ago, we released our OnSite mobile apps product. The main focus of this product was to assist in the management of defects, as per this blog post at the time.

Since then, the majority of use for these apps has been in site surveillances carried out by independent review engineers on infrastructure projects. The app has supported all sorts of new roads and rail networks. However, it hasn't been used much for its intended purpose. Hopefully, UniPhi 14 will assist in changing this.

The main issue in using it for defects was that the correspondence that was logged as comments in the issues module of UniPhi couldn't be extracted easily to share with non-UniPhi users. We use reporting services for our reports (see this post) and we didn't know how to strip the HTML stored in our database when using this platform. Turns out, there's a setting for that, so we now have the defects management report!

New Defects Log Report - With Comments!

This report puts all image files uploaded into their own column and adds all comments into the report as well. This new capability (that was there and hidden the whole time - Doh!) has opened up issues management to broader than just defects, with RFIs, Safety and other types of issues being able to be shared with non-UniPhi users as a register with all comments, actions, due dates and ratings.

If you want to find out what our other features are, follow us on LinkedIn and Twitter - we post all our updates there!


Share this:

UniPhi 14 - Email Notifications

UniPhi Software, 24 Jul 2018

There's been a lot of expansion to the UniPhi email notifications in version 14. Thanks to considerable feedback from our lovely end users, we've added the following:
  1. Notifications on new projects created. This has been added to assist bid teams when new opportunities are logged into UniPhi
  2. Notifications on new actions you've been assigned to. This handy feature came about due to the great success of an independent verification deployment. There was so much activity that we had to get more nuanced as to the changes. Now, an engineer will know they've been assigned a new surveillance or review action rather than having to check modified activities/issues to see if that modification affected them.
  3. Notifications of documents awaiting your sign off contextualised to the lowest delegated authority. This was hurriedly implemented when a CEO did not like being notified of a document awaiting sign-off before all the underlings had already signed it off. Of course, unbeknown to the CEO was our experience of other CEOs incorrectly signing off contracts and invoices because they blindly relied on the fact that the underlings had already signed off the document. The question here being, what value are they adding signing the document off? With UniPhi presenting all the information they need in one screen, I would imagine a more productive thing would be that if they did sign it off before others then the whole document gets signed off. Alas, a battle for another day.
  4. Notifications on signed off documents. This helps external PMs (to a client of construction services) know when instructions have been signed off so they can then send the notice to the contract. The majority of UniPhi clients these days are developers who then engages with their external consultants to use UniPhi to manage their projects. This provides significant productivity savings for all organisations concerned of up to 50% on the activities undertaken in UniPhi.
Notification Email

UniPhi email notifications has always been a bane of contention with our team and our philosophy of providing a platform product for people to collaborate but truth be told, it is crucial to successful deployments. Hopefully these new features will assist in future deployments being even more successful.

To keep up to date on our feature release, follow us on LinkedIn and Twitter!


Share this:

UniPhi 14 - Resource Planning

UniPhi Software, 23 Jul 2018

There is one feature in particular which has been a big focus of the recent update.  From working on improving tracking its lifecycles to reports, feature 7 in our countdown is resource planning.

The resource module provides UniPhi users with a variety of different capabilities, for instance; the ability to budget resource hours in a project. 

Each resource in UniPhi has a cost and charge rate against their user profile.

Cost & Charge Rates

This means that when you budget, for example, Denis Adams for 8 hours in a week and he has a cost rate of $50 against his user profile (as seen above), running the report with "Cost" selected instead of hours will result in an output of $400 in the week instead of 8 hours.

The module, furthermore,  provides users with the ability to forecast resource hours (week ending) and have variance analysis between actual and budget, as well as forward workload planning. 

Resource Variance Analysis

This means, you can now report on hours or on cost depending on your needs, view the variance and are able to more accurately plan further in advance for all your resource needs.

To keep up to date on our feature release, follow us on LinkedIn and Twitter!


Share this: