The Customer is a US-based machinery maintenance entity with 25,000+ employees.
With the goal to improve HR and performance management, the Customer wanted a BI solution that was to:
In the course of the project, ScienceSoft’s BI consulting team delivered the following:
As the BI system was to bring together data from 4 sources, it was tuned to discover any discrepancies (such as typos, mismatches, different abbreviations, etc.) between them.
Since the Customer wanted to improve HR management processes, ScienceSoft developed specific reports with the following information:
The reports allowed the Customer to watch over contract termination dates and organize relevant HR procedures on time. Additionally, the Customer got an overview of personnel costs and was able to use this information for budgeting.
To allow the Customer to control the headcount, ScienceSoft implemented the dashboards that show:
Two modules were designed for monitoring employees’ performance: the one was to track employees’ working time and the other their task fulfillment.
The delivered BI solution allowed the Customer to make HR and performance management more controllable thanks to monitoring task fulfillment, tracking employees’ working time and watching over important milestones (for example, a contract termination date). Besides, the system ensured data integrity by spotting discrepancies in it.
Microsoft SQL Server (DWH), Python (ETL), Microsoft Power BI (Reporting).