USE CASE
Monitoring dashboard of different HR areas
Integration and cleaning of different data sources for the different HR areas. Dashboard and data governance policies development.
THE CHALLENGE
Data Mining process automation from the HR area from different sources, and integration in a single space while developing the different visualization elements and determining the governance policies for the different user types.
Integrating the different data sources and availing ourselves of DOMO ability to consume data in different ways, the aim is to reduce study times and simplify the key metrics by creating new dashboards, enabling self-service dashboards and creating alarms.
In addition, security policies will be implemented so that each user profile only sees the corresponding data despite being integrated and centralized.
THE SOLUTION
The data are extracted and integrated from the different data sources. Subsequently, already on the platform, they are treated and debugged and after the different display elements are created.
In the first instance, the different client HR areas and their data sources are identified. At the same time, the different governance rules must be defined for the people who will access this data and the different alarms that must be set after the data integration.
DOMO connects to the different data sources that are subsequently debugged. Afterwards, these data must be studied to identify the dimensions and metrics that already exist in the solution and rename them, or if they do not exist, create them so as not to have to modify the ETL process or the datasets that will feed the dashboards.
Alternatively, customer training can be offered to be able to exploit the self-service consumption model that would make the platform optimal.
Panel's experience in the field of process integration and automation has allowed to maximize the use of DOMO platform.
SCOPE
Integration of data sources from HR tools and their visualization.
TECHNOLOGICAL ENVIRONMENT
DOMO
METHODOLOGY
Dashboard Business Intelligence
POINTS OF INTEREST
BI
Data governance
SUCCESSES ACHIEVED
The entire data cycle is covered for all HR areas from its extraction to its visualization, centralizing all the information in a single tool.
Time reduction both in the data extraction and integration process itself and in the monitoring of indicators and charts by creating alerts.
Integration of a data governance system that allows us to reduce the number of data sources that feed the data visualization and consumption elements.
Optimization of the information display for each user/time through the development of a small self-training, integrated into DOMO to enhance the self-service visualization generation area.
Examples of KPIs used:
• Number of training hours per employee.
• Number of courses per employee.
• Course completion rate.
• Number of certifications obtained per employee.
• Employee satisfaction rate with training courses.
• Total cost of training in relation to the assigned budget.
• Number of employees who received training in technical skills.
• Number of employees who received training in non-technical skills.