dots bg

Certified HR Metrics and Analytics (Video Based learning Course)

Learn to create HR Excel Dashboard, Strategy Map, Balanced Scorecard, HR Scorecard, KPI Dashboard, Recruitment Dashboard, Retention Dashboard, Reporting Trends in Graphs, Chart, Table, Metrics Calculations, Data Analysis, Regression and Correlation Analysis, Statistical Analysis, Benchmarking, Predictive Analytics, etc. Analyze HR data in Microsoft Excel (Pivot Table and Charts) and build intuitive dashboards using Microsoft Power BI.

Course Instructor: Meritt Learning Center

$55.60

dots bg

Course Overview

Certified HR Metrics and Analytics (Video Based Learning)

OVERVIEW

Learn to create HR Excel Dashboard, Strategy Map, Balanced Scorecard, HR Scorecard, KPI Dashboard, Recruitment Dashboard, Retention Dashboard, Reporting Trends in Graphs, Chart, Table, Metrics Calculations, Data Analysis, Regression and Correlation Analysis, Factor Analysis, Cluster Analysis, Statistical Analysis, Benchmarking, Predictive Analytics, etc. Analyze HR data in Microsoft Excel (Pivot Table and Charts) and build intuitive dashboards using Microsoft Power BI.


PROGRAM AGENDA

Session 1 : Business and HR Analytics

Introduction to Business Analytics, Fundamentals of HR Analytics, Evolution of HR Analytics and Scope of Human Analytics in Business. Evolution of Human Analytics: Quantification Methods, Establishing the Analytic Framework, Need for Standards in HR Analysis, Basic Data Analytic Techniques using Excel. Session 2 : Strategy Maps and Balance Score Cards HR as Strategic Drivers, Human Capital Reporting Standards, Using Data to Develop Operational Frameworks, Developing HR Measures. Developing HR Metrics and Score Cards: Choosing the Correct Metrics, Identifying the Key HR Processes for Business Developing HR Score Cards, Applying of HR Score Cards. Session 3 : Data Quantification and Analytic Techniques Linking HR with Business Drivers, Business Drivers Framework, Using Strategy Maps for Business, Balance Score Card Method. Statistical Analysis and Benchmarking: Statistical Analysis for Reporting, Benchmarking and Targets Linkage and Trends Analysis, Human Capital Measures and Business Results. Session 4 : Advanced Analytics and Predictive Outcomes Statistical Drivers and Advanced Analytics, Correlation and Causations, Using Regression and Data Analysis for Predicting Business Outcomes. Regression and Correlation Measures: Communicating with Data and Visuals, Selecting of Proper Charts and Diagrams, Dash Boards and Score Cards for Best Business Outcomes. Session 5 & 6 : Data visualization – In Microsoft Excel and Power BI Learn the skills to analyze HR data in Microsoft Excel and build intuitive dashboards using Microsoft Power BI. Learn to communicate data effectively by creating compelling reports and using storytelling techniques. Learn end to end Power BI Dashboard. Create Interactive dashboards. Data Storytelling & Project outcomes.

Faculty

An Alumnus of XLRI, Jamshedpur, with over 35+ years professional experience as HR Leader, Consulting Partner, and Office/ Practice Head. Worked with large corporations such as Vice President HR with Tata Enterprise, Director for Axon Learning, Director for Mindshare Consulting, Director HR - Consulting with Ernst & Young, and many such milestones, with specialist areas in Competency Mapping of unique roles and Assessment Centers, Organizational restructuring & Role profiling, Workplace audit, Compensation restructuring and Training assignments for reputed companies like IOC, M&M, HCL Perot System, Exim Bank, NTPC, BHEL, Airtel, GATI, Indian Oil, etc.

What you will get?

Session Reading Video Recordings of the Live Sessions Practical's with Sample Papers - Do it yourself On completion, you will receive "Course Completion Certificate" Your Name will be listed in the Meritt Training Directory


Contact Meritt Learning Center Email: training@merittconsultants.com; Contact: +91-7428466822 www.merittconsultants.com

Schedule of Classes

Course Curriculum

1 Subject

Certified HR Metrics and Analytics (Video Based learning Course)

4 Exercises22 Learning Materials

Overview of HR Metrics and Analytics

Program Overview

Video
00:05:07
FREE

Session 1 : Business Analytics and Evolution of HR Analytics

Readings for Session 1

PDF

Session 1 : Video

External Link

Dataset for Practical Exercise

DOC

Assignment for Session 1 : On HR Analytics

Assignment

Session 2 : Strategy Maps and Balanced Score Cards

Reading for Session 2

PDF

Session 2: Video

External Link

Questionare

DOC

51 HR Metrics Sheet

PDF

Assignment for Session 2 : Developing Metrics and HR Scorecard

Assignment

Sample

DOC

Session 3 : Data Quantification and Analytic Techniques

Reading for Session 3

PDF

Video of the Previous Session 3

External Link

Dataset 1 for Practical Exercise on Data Analytics

DOC

Dataset 2 for Practical Exercise on Data Analytics

DOC

Assignment 3 : Data Quantification and Analytic Techniques

Assignment

Session 4 : Advanced Analytics and Predictive Outcomes

Reading for Session 4

PDF

Video of the Previous Session 4

External Link

Dataset for Practical Exercise

DOC

Assignment Session 4 Predictive Analytics

Assignment

Session 5 & 6 : Data visualization – In Microsoft Excel and Power BI

Reading for Session 5 & 6 - Data Analysis Step By Step Guide

PDF

Reading for Session 5 & 6 - PowerBI

PDF

Download Power BI Link

PDF

Video of the Previous Session 5

External Link

Video of the Previous Session 6

External Link

Practice HR Data

DOC

Course Instructor

tutor image

Meritt Learning Center

29 Courses   •   188 Students

About Meritt


Meritt HR Consultants Pvt. Ltd. is a Human Resources consulting and advisory firm that delivers value through superior quality products and services to its end customers – whether big corporations, companies in the start-up phase, small & medium enterprises or family-owned-turned-professional business houses; within attractive cost structures, through its different “Centers of Expertise”.

Started in April 2013, Meritt is backed by a professional and knowledgeable management team, with more than 100 years of consolidated experience in the HR and business domains. It is also supported by a network of experienced consultants and associates in the different areas of expertise and specialization within the integrated HR services space.

Meritt offers a bouquet of consulting solutions, which are built around advising client organizations in the areas of people, processes, tools and data to support them with the most appropriate and effective business decisions for their sustainability and growth. Such efforts are aimed towards ensuring that the organizations are better equipped to plan and implement the requisite changes within their systems to meet the external demands.

The team of specialists and experts at Meritt is driven each day by an unrelenting passion to make meaningful contributions in its associations with clients partners to build superior organizations through higher standards of service deliverables.

To deliver the above practices, Meritt focuses on robust and comprehensive data research, analytics, measurement and reporting solutions to ensure both qualitative and quantitative value for its client organizations for superior business performance.

Contact Us                                                                                                                                                        

If you have any questions about us, please contact us by email: info@merittconsultants.com