Seamless Recruitment & Training Using Modern BI

Case Study

About the client

The client operates within a vertically integrated system with a bold yet simple mission: to be the trusted partner in all healthcare decisions for everyone who depends on it. They combine clinical care, health insurance, medical research, and higher education, providing highly accessible, high-quality care and services to improve health in communities.

Industry

Hospitality

Revenue (USD)

Million

Head Count

Employees

Countries Of Operation

US

Overview

The objective was to implement automation and improvements within the HR department's workflows, streamlining tasks, reducing manual effort, and enhancing overall operational efficiency and control over regional hiring.
Optimize employee transitions to ensure uninterrupted organizational functionality and productivity.
Prioritize hiring in nursing department to keep track of vacancies.

Challenges

The reliance on distinct Excel sheets for individual regions created data silos and complicated central management and analysis.
The initial process required labor and time intensive manual data collection, which is error-prone leading to inefficiency
The initial approach hindered timely identification and filling of vacancies.

KPI's

OVERVIEW SECTION-

Monitoring overall region openings categorized by staff level and leadership level

Total Openings
Region-wise Openings

IN-DEPTH ANALYSIS OF OPENINGS-

Conducting a detailed analysis of openings to facilitate KPIs

Total System Vacancy Rate
Percentage Vacancy by Regions
Time Required to Fill Vacancies
Trend of Openings by Months
Reasons for Openings

NURSING FOCUSED OPENINGS-

Monitoring, analyzing nursing specific openings, as it holds particular importance for the business

Nursing Requirement by Region
Percentage of Openings for Nursing
Time Required to Fill Nursing Openings

Tools and Technologies

DOMO Central platform was used for data management and visualization, Excel Sheets were used for region-specific vacancy data, Email Connector were were utilized for importing excel data to DOMO automatically, DOMO Data Warehouse served as Central Data Repository. Magic ETL Tool was used to clean and format excel data.

BUSINESS FUNCTIONS BENIFITTED

DIACTO not just improved HR processes but also enabled data-driven decisions & optimized staffing. It also helped in efficient talent management. Enhancing ability to meet specific departmental needs.

- HR: Streamlined recruitment, better decision-making.
- Management: Centralized real-time view, improved control, and informed decisions.
- Nursing Department: Specialized monitoring and analysis for nursing.
- Operational Teams: Reduced manual work, and more focus on strategic tasks.
- Vacancies were filled faster to benefit the organization.

Outcome

Improved Control

Effective control achieved over employee requirements with DIACTO

DIACTO Streamlined Recruitment Process

Faster hiring, reduced time to fill vacancies

Enhanced Vacancy Management by DIACTO

Better decision-making, effective resource allocation

90% Reduction In Manual Work

DIACTO helped client to focus on strategic task by reducing manual work