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

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