HR Reporting

Company size:

Presence:

Technologies:

500+ Employees

Poland

Power BI, MSSQL Server

01:

CHALLENGE

One of the government’s most crucial institutions needed an analysis of their whole HR ecosystem together with their employee’s detailed data. Identification of top performers and managing talents could have helped polish diplomacy for years. Additionally, the Client was supporting voting outside of Poland and needed to monitor progress, report results, and do this within extremally tight schedules.

Everything had to include, customer’s specifics in the IT area:

  • Multiple legacy systems with old database technologies; data was very confidential, and work could be done only locally on a customer’s site.
  • complex business logic representing Institutional regulations

02:

SOLUTION

A set of Power BI reports integrating data from multiple source systems and excel files was created.

  • analysis of source data and source data model
  • design and implementation of database enhancements (materialized views, ETL procedures)
  • creation of Power BI data model
  • creation of a set of analytical reports for Human Resources and Operational reporting including compensation analysis, results comparison, and team members benchmarking together with advanced analysis of experience vs training comparison

03:

RESULTS

  • month closing in HR department sped up by 75%
  • ability to promote the best young talents and top performers
  • compensation correlation with performance and not only seniority
  • voting process analysis shortened from 3 days done manually to 2 hours done semi-automated.

YOU MAY ALSO LIKE:

contact

Let's talk

Katarzyna Strzelecka

Sales Operations Manager

+48 722 233 444

Clouds On Mars needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy policy.

contact

Let's talk

Clouds On Mars needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy policy.

This website uses cookies.