ETL & Visualization

Labour intensive company in a very high personal turnover market needs a system that extracts and transforms data from multiple systems to create visualizations to support and manage their recruitment process.

One of the world’s leading resorts, hospitality and gaming companies. It primarily develops and operates a large portfolio of integrated resort, retail, dining, hotel and gaming facilities in Macau. The Group is listed on the Hong Kong Stock Exchange and is a constituent of the Hang Seng Index.

    hotel recruitment reporting dashboard

ETL & Visualization

CHALLENGE

The company employs in excess of 20,000 employees in a market with a very high staff turnover. Follow up and prioritising areas, departments, divisions that require new recruits can be complicated when data is spread across several systems, and the scale of the company is such that manual reporting becomes impossible.

SOLUTION

iExcel developed a system that extracts, transforms and loads the data from 3 systems in order to build visualisations and dashboards with a high degree of cross-referencing and filtering. This allows the user to quickly understand the situation at a high and detailed level and to identify areas that need to be prioritised.

IMPACT

Understanding and visualising the recruitment status and process on a daily basis termendously improves the whole recruitment activity, and results in more successful recruitments.