Data Nectar designed and developed an enterprise business intelligence solution to integrate
data from disparate data sources while processing the data across various dimensions to provide
continuous insight across each level of the organisational hierarchy.
A range of data transformation was applied to model data to match with new organisational
structure. A modern data warehouse built on Postgres Database along with required security
provisions. Data marts serve the Power BI-based self-service Dashboards and Reports to enable
high-performance while fetching multidimensional data.
Self-service BI dashboards and automated report functionalities provided the user to visualise
and analyse the data around time to hire, cost to hire over a range of segmentation across sales
category, hiring executive, drug types, regions and more. The correlation between average sales
bandwidth and sales variations was identified accurately backed with facts and factors. Much
valuable insights that were missing in manual reports, were made available with just a few
clicks whenever needed.
The data-driven insights enabled the organisation to monitor individual HR executive's
performance around the actual average time to hire against the expected time to hire. An
overview of HR resources’ available bandwidth helped stakeholders making quicker decisions on
allocating them to the most critical open vacancies, in turn reducing time to hire.
- Database integrations of SAP HCM - SAP Finance (Oracle)
- Data extraction using BAPI
- Data cleansing & transformation to the required model with Talend
- Data Warehouse (Postgre)
- Power BI