Power BI Dashboard Creation for Talent Competency Model

Project name: Power BI Dashboard Creation for Talent Competency Model

Location: Hobart, Australia 

Timeline: 2 Months + Ongoing Maintenance 

System Architecture: SQL Server, PowerBI, Angular, MVC, ASP.Net 


The client required an Excel & Power BI data visualisation specialist to convert the inputs captured within an Excel file into a Power BI dashboard.

The project data was a “Professional Skills Competency Assessment Tool” which was in Excel. The client wanted to be able to visualise the assessment scores of company employees into specific dashboard outputs. One dashboard was required to show the competencies against benchmark targets and the individual employees with their scores. The second dashboard was required to display the same information but at an hierarchical level and was for the purpose of the Head of the Team.

Furthermore, the client wanted to create an improved front end, date entry, tool that could be accessed via a url link, instead of sharing an Excel spreadsheet with each individual for completing the assessment and then manually manipulating data for visualisations. 

Created a dynamic form on Angular and ASP.Net to capture the individual responses of their competency assessment which was segregated at three different levels of hierarchy. The data captured in the form was linked to SQL Server which in turn was linked to the client's PowerBI to update their dashboards on a real-time basis. This enabled the client to get the most recent output of the individual employee, team and organisation’s performance, area of strengths & weaknesses and all other statistics that the client wanted to be able to report.