Case Study

PROBLEM STATEMENT

Our client, a leading industrial automation company with 12 global offices wanted to set up a centralized employee assessment system.

The objectives of the system were:

– Monitor the employee skills regularly through a centralized system

– Presenting the data to respective department heads

– Providing insights to the training and development team to design skill enhancement programs 

Hiring any online assessment company was costing huge as a company was aiming to conduct an assessment of 2500+ employees across the globe.

SOLUTION

We developed a PowerApp with Power BI integration to generate real-time visualizations and results. More than 10+ functional assessment tests were added to the app which is accessible through all the organizational users. Entered data then stored in SQL Server On top of this data, various reports were developed in Power BI and integrated into PowerApps. RLS(row-level security) is implemented to grant necessary access to Dashboards and kept it limited to respective department heads with admin access to the Training and Development head.