business intelligence solution in human resource

www.cannyinformatics.com 1

Business Intelligence solution in Human Resource

Canny Informatics

Focused verticals

• Health Care

• E-Commerce

• Logistics

• Energy, Oil & Gas

• Lead Generation

• Manufacturing

• BFSI

• Social Media

• Machine Learning

Focused services

• Data Integration

• Data Warehouse

• BI & Analytics

• Data Visualization

• Reporting

Regions served

• India

• USA

• UK

• European Union

• Middle East

• Australia

About Canny Informatics



‘BI’ Offering

Data Integration

• Talend Data Integration

• Pentaho Data Integration

• Informatica

• Microsoft Data Integration

Services

BI Tools

• Pentaho Business Intelligence

• Qlik View

• Qlik Sense

• Microsoft Power view, Power

Pivot

Reporting

• Crystal Report

• Microsoft SQL Reporting

Services(SSRS)

• Analysis Services(SSAS), BISM

(Tabular Model & MOLAP)

• Jasper Report

• Pentaho Reporting Services

Data Integration | DWH | Dimensioning | Analytics | Visualization |Reporting


BI offering for HR Department

• Why BI for HR?

• On demand reporting

• Hiring, Identifying and Retaining the ‘RIGHT’ people in the organization based on the reports

• Predictive analysis for attrition

• Manpower operating strength to analyze Sales Performance vs Target vs Efforts

• Attrition Analysis based on tenure, job profile, organizational hierarchy and other different dimensions.

• Recruitment performance and ageing analysis on vacant positions

• Tracking the effect of changes in policies and processes based on pre-defined data points

• Identifying patterns in attrition and recruitment needs based on multiple dimensions

• Opportunity to generate employee engagement, satisfaction and other such reports based on surveys and identifying patterns over long term

• Opportunity to increase retention and identifying hidden parameters affecting retention


Success story: a large size client in Healthcare domain

• Client is one of the top 5 healthcare companies (Presence over 60 years)

• MIS automation

Challenges

Gleaning business insights due to MS-Excel base approach & multiple data sources

Manually cleansing data on monthly basis & reusability of reports for comparison was not achievable

Objectives was to overcome above said challenges with data access rights at different level

Solution was needed at low infrastructure cost & using open source technologies.

• Our Role

Selection of right development tools

Integration, data cleansing and data warehouse development and automation for data integration

Interactive dashboard designing for visualization

• MIS automation

https://drive.google.com/open?id=0B-wZG2X90CONc2VLM2dKVVppMGs


Success story: Continued…

• Man Power Analysis

• Periodic comparison of manpower to budgeted, agreed strength to operating strength

• Periodic opening strength, closing strength, new joiners, leavers and vacant against agreed strength

• Attrition Analysis

• Periodical analysis on different dimensions for attrition

• Recruitment SLA

• Measure recruitment time performance of HR department on various dimensions against defined

norms.

• Ageing analysis on vacant positions

• Ageing analysis of attrition base on tenure with organization

Objects are available in form of -Interactive Dashboards with different dimension & Time filters Tabular, Charts and other relevant representation styles


Dashboard Preview – DATA IS DUMMY


• Set up ETL schedule to build Enterprise Data Warehouse & Metadata Structure

Data sources used :- SAP, CRM, XLS, MySql

Scheduling for EDW to keep data ‘up to date’ of OLAP cube

• Design and deploy objects, KPIs, crosstabs reports and dashboards

KPI’s : Operating Strength vs Budgeted Strength, Attrition Analysis, Recruitment Performance SLA

Performance comparison base on effort and operating strength

Developed 6 dashboards and 24 to 30 objects

• All this delivered in duration of 1 month

Role of Canny Informatics

9

Legacy Systems

Transfo

rmatio

n &

En

richm

ent

Data QualityData

Cleansing

Matching &

Consolidation

Data Sources Data Integration Process

Performance Score Card

PredictiveAnalysis

Interactive Dashboards

Data Visualization

Proposed architecture at Your organization


Use-cases for HR at Your organization

• Predictive Attrition analysis

• Training performance

• Candidate & Trainer

• Field Performance against Performance during Training

• Effort vs Performance categorization on different dimensions for Sales team

• Predictive Analysis based on Training Performance

• Recruitment Costing

• Wrong hiring ratio – (loss on cost of recruitment & training)

• Ageing analysis of leavers based on tenure with organization for different dimensions

Objects can be developed form of -Interactive Dashboards with different dimension & Time filters Tabular, Charts and other reverent representation styles


Advantages of BI implementation

• Reduce operational cost by eliminating manual efforts

• Improved efficiencies by automation and analytical power for data

• Reduce dependencies by developing central repository / warehouse

• Unified version of truth for faster decision

• Key Performance Indicator can be available on Mobile

• Predictive analysis

• Other divisions can be also supported on BI


• Operating System : Cent OS (No

license Cost)

• BI Platform : Pentaho community

edition (no licensing cost)

• Database : MySQL as data

warehouse (no license Cost)

• ETL Tool : Talend data integrator (no

license cost)

Technologies Used

• Consolidation of High Volume data

by designing proper data warehouse

• Extracting and transforming data

from various sources to find targets,

experience of resources and financial

data.

Solution

Solution and Technologies

Canny InformaticsFF-5, JBR ARCADE,

SCIENCE CITY ROAD, SOLA

AHMEDABAD, GUJARAT 380060

Contact: GAURANG ACHARYA

(HoD BI & Analytics)

Email: [email protected]

Mobile: +91 9624793322

www.cannyinformatics.com

mailto:[email protected]

business intelligence solution in human resource

Recruiting & HR