Certified HR Metrics and Analytics (Live Virtual)

Total 18 Hours Session



SHRM Professional Development Credits (18 PDC's) for SHRM-CP or SHRM-SCP

The program is pre-approved by SHRM for recertification professional development credits (18 PDCs) for HR knowledge and competency programs related to the SHRM Body of Applied Skills and Knowledge (the SHRM BASK).

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

HR Analytics

Nirmala Garg,

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.

 Data visualization – In Microsoft Excel and Power BI

Atikant Jain

Data Analytics Trainer | Power BI | Microsoft Fabric | AI | Python | SQL

Atikant Jain, popularly known as “The Analytical Guy,” is an experienced Data Analytics Trainer and professional, currently based in Australia. An alumnus of NorthCap University and MBA from IMT Ghaziabad, he has industry experience with TCS, Relaxo Footwears, and Curate Data Analytics.

He specializes in Data Analytics, Power BI, Microsoft Fabric, AI, Python, SQL, Data Visualization, and Forecasting, and has trained professionals across organizations on applying analytics to real-world business challenges.

What you will get?

·        Manual User Guide Book Reading materials Recordings of the sessions

·        Practical assignments during the session and follow-up assignments

·        One year access to Learning Management System (LMS)

·        Online/on call support available

·        Final Project work on given topics to be completed in 60 days

·        On completion, you will receive "Recognition Certificate" with Grades

·        Your Name will be listed in the Meritt Training Directory

·        Participants will get SHRM Professional Development credits (18 PDC's)

Contact

Meritt Learning Center

Email: training@merittconsultants.com

Contact: +91-7428466822

www.merittconsultants.com