Collaborate With Confidence - Build Your Updated Skills Inventory in 2019

If we are going to see improvement in project collaboration all stakeholders will need to start interacting much earlier on. 

Collaborating using Autodesk Revit software for example requires a specific skillset e.g. interference checking, model linking, working with worksets, understanding the copy/monitor tool and more.

Within a couple of minutes, KnowledgeSmart administrators can build an assessment in KnowledgeSmart focusing around assessing their team on these specific aspects. 

Having access to up to date skills inventories across all participating companies can help build a successful team that is adept at working together. It can also help assess suitability for collaboration and where collaboration should take place ideally. 

One of the biggest costs of projects is waste and I am not just referring to physical waste. Wasted resources and poor resource planning can cost companies millions.

The above image shows the results from two firms looking to collaborate. Visual slicers on the right include: company name, certificated training (yes or no), 2Yrs+ Project Experience (Yes/No), Current Project Focus, Project Manager, Elapsed Time and Hire Date. We can assess collaboration suitability and even map out optimal project teams.

The above visualisation uses a radar chart to compare the skills gaps across two companies. The process involves focusing on the skills that the project needs. If the skill gaps are too considerable for training to solve, at this point, the project management team would consider collaborating with a further company or hiring internally focussing on the relevant skills required. Using the 5 unique datafields that KnowledgeSmart allows you to capture our analysis contains richer data. In this case: office location, hire date, project area focus, years of project experience and certificated training (yes or no).

The above image shows a slightly different way of looking at skill gaps across the collaborating companies and these can be analysed according to current team structure or even on an individual bases.

Using the same filters as described above we can now also identify the best possible project mentors between the two companies. Who are the people that can offer the most support to teams on either side of the collaboration? 

 All these visualisations can easily be added to a dashboard that can be shared across the management team and stakeholders so that improved, more insightful decisions can be made very early on.

KnowledgeSmart can help companies collaborate with more confidence both internally and externally. This will identify potential risks and problems early on and make sure the right people are assigned to the right elements of the right project.

 

Critical MS Excel Areas to Test – Prior to Hiring

I recently came across a great article by Kat Boogaard from GoSkills which goes through six critical things any Microsoft Excel user should know how to do.

1. Sorting Data

2. Removing Duplicate Data

3. Basic Math Functions

4. Freezing Panes

5. Date Functionality

6. Making the same change across worksheets

According to a course curriculum structured by the Macquarie University taught by Dr. Yvonne Breyer, Director, Learning and Teaching the following skills would be essential to master their beginners Excel Skills for Business Specialization:

1. Crucial navigational controls in Excel
2. Performing Calculations - formulas and functions
3. Excel Formatting Tools
4. Working with data - managing your spreadsheets
5. Optimising your spreadsheet for printing
6. Creating and modifying charts in Excel.

I am sure we can all agree that Microsoft Excel is one of the most widely used business tools today and with it becoming increasingly important to isolate the data needed as fast as possible.

During a typical interview, the panel might prompt the candidate to elaborate on their current Excel skills and possibly examples of projects they have worked on. The response from the candidate is entirely subjective and based on self-perception.

Imagine you could include a well-designed skills assessment as part of the evidence you gather to evaluate for feasibility, acceptability, and desirability. A skills assessment based on these 6 critical areas highlighted by Kat Boogard and Macquarie University?

Validity

KnowledgeSmart skills assessments are valid: they measure what they are supposed to measure. Our Microsoft Excel (amongst other) assessments offer two levels, i.e., fundamentals and advanced. From the results of these assessments, an employer or potential employer would easily be able to ascertain who has a good understanding of the program and who doesn't. Two elements are reported namely score (accuracy) and elapsed time (the time the candidate took to complete the assessment, module or specific question). 

Reliability

Authored by industry experts, our assessments are reliable and consistent which means any candidate can easily be benchmarked against current employees or candidates. 

Discrimination

The one area that I particularly like is that independent skills assessments do not discriminate between people based on anything other than their ability to demonstrate and apply their skills.

The next time you are facing a possible new hire consider including an independent skills assessment as part of your decision matrix analysis. KnowledgeSmart skills assessments are entirely customisable which means the assessment can be adapted to your exact requirements. There are also some unique datafields that allows administrators to personalise the background data captured.

So much more than a test score

You will not only gather great insight into the candidate's skills as far as accuracy and speed of working is concerned, but you will also be able to capture a valuable background data.

Below is an example of how your KnowledgeSmart Results and Background Data can then be visualised to be placed onto a Microsoft PowerBI Dashboard if needs be. Group the background data most critical for your company,

Comparing Candidates

With all this information readily available you would also be able to plan inductions plan a lot more effectively once you have made your selection.

Microsoft PowerBI KnowledgeSmart Visualisations - Example Dashboard

Don't just take our word for it. Have a look below at what JohnsonBIM have to say.

We use KnowledgeSmart to enable our clients to recruit smarter candidates and to prove their ability; we find that it ensures better outcomes. By replacing guesswork with the KnowledgeSmart skills assessment, our clients know precisely how and where their candidates will add value to their organisation before they hire them.

Mike Johnson - Managing Director, 

JohnsonBIM, London, UK