20 Feb

HR METRICS AND ANALYTICS VIDEO TRAINING

HR METRICS AND ANALYTICS 

VIDEO TRAINING

(VIDEOS COURSE)

 

STAND OUT WITH HR METRICS & ANALYTICS SKILLS

Do you desire to be relevant to your company as an HR Manager?

Do you want to possess the latest HR Skills – Metrics and Analytics Skills?

This is one Course that can make you really relevant and effective at your work and in your career.

Today’s HR Practice has gone beyond conventional administrative functions.

The Seasoned HR Professionals Know how to Gather HR data, Analyse HR Data, Interpret them, Draw Insights From Them and Report Same to Management with Top-Notch Visuals.


They Don’t Just Talk Grammar at Meetings; They Talk in Facts and Figures.

Knowledge of HR Metrics and Analytics Will Stand You Out As an HR Manager because Very Few HR Managers Possess this Skill.

This Video Course Will Teach You Everything You Need to Know About HR-Metrics and Analytics:

  1. How to Gather HR Data

  2. How to Analyse Data Using Excel Pivot Tables

  3. Basic Analysis Operations on Microsoft Excel

  4. Draw Insights on HR Data

  5. Report Generation With Great Visuals

All of these you will be able to do by watching these 4 hours videos Course

SAMPLE VIDEO

PLAY THIS VIDEO AND SEE THE SAMPLE OF THE VIDEO COURSE


THE VIDEOS WERE RECORDED DURING A LIVE SESSION

WHERE PARTICIPANTS PAID N150,000 FOR THE TWO DAYS EVENT

Do you really want to add value to your organization?

Do you want to upgrade your HR skills and be more relevant in the industry?

Do you want to learn HR Metrics and Analytics from the Guru Himself Without Having to Break Your Bank Account?

DELIVERABLES

The Videos Are in 5 Modules.

The modules will take you through HR Metrics and Analytics from Novice Level to Expert Level in these 4 Hours Training Videos.


Module 1:    Introduction To HR Metrics & Analytics              (36min)

 

This module introduces you to HR Metrics and Analytics. The following issues are addressed:

  • Understanding the Shift in HR Practice

  • Why You Need to Measure Things

  • Importance of HR giving facts in figures

  • Providing the right Reports the MD is interested in

  • Why it is essential to measure and Report HR Activities

  • Converting data to figures

  • How to Measure and Report on effectiveness and efficiency


Module 2: Basic Excel Skills for HR Manager                         (59 mins)

Microsoft Excel is a basic tool that is used to perform HR Metrics and Analytics. This Module Introduces HR Managers to basic Excel Skills they will require to analyze their HR data. This practical session will show you:

  • The correct ways to capture dates in excel and the importance of dates

  • Different Excel formula to Make your work easy

  • “Today’s formula” such that dates will automatically adjust themselves to reflect the true value as at “today”

  • How to set up your data to monitor expiring periods e.g., probation period expiration, leave expiration etc.

  • How to capture “Time Worked” with Excel e.g. cumulative overtime etc.

 


Module 3: Setting and Monitoring KPIs in Excel                   (34 Mins)

This is a practical session on Microsoft Excel. This session teaches HR Managers how to use conditional formatting to their advantage. The following shall be addressed:

  • Setting up performance parameters with Excel

  • Real-time performance monitoring such that there will be a flag-off on performance e.g. GREEN LIGHT will show for good performance,  AMBER LIGHT will come up for average performance and a RED LIGHT will flag off for below-average performance.

  • How To Set Excel to Monitor Probation expiring date such that there will be a flag-off one or two months to the expiry.

  • How To Set Excel to Monitor Leave Templates Such that there will be a flag-off to prompt you of their resumption dates

  • How to format a cell in Excel to monitor critical data

  • How to automatically locate duplicate entries in large data

  • Combining date and time with KPI setting using Excel etc.

 


Module 4: Analyzing HR Data with Pivot Table in Excel     (52 Mins)

This is another powerful, practical session. This session will expose you to the use of Pivot Table to analyze HR Data. You Will Learn;

  • How To Perform Operations on Pivot Tables

  • How to analyze different HR Data with Pivot Table to gain better insights e.g.

    • Staff headcount by department

    • Compensation distribution per departments/region/product line

    • Gender distribution per department/region

    • Age distribution per department/region etc.

  • Practical ways to interpret your analysis

  • Drawing insights from our analysis

  • Graphical representation of your insights for management report etc.

 

Module 5: HR Metrics and Analytics Dashboard Proper    (37 Mins)

This is the crux of the course. You will learn how to use our already made HR Metrics and Analytic Dashboard. A copy of the dashboard usually sold for N700,000 is included herewith these videos for you too. You will learn how to measure:

  • Effectiveness & Efficiency

  • Compensation component

  • Revenue per staff

  • Revenue per salesforce

  • Human Capital Value Added

  • Labour Cost Ration

  • Return on involvement in People

  • Individual Accident

  • Absent Analysis

  • Training Investment and Financial Impact

  • Asset management Efficiencies

  • Job Rotation Ratio

  • Vacation Utilization Ratio

  • Complain Resolution Rate

  • Attrition and Retention per Month

  • Recruitment Rate

  • Transfer Rate

  • Cost Per Hive

  • Time to Fill

  • Diversion Analysis

  • Regional Ratio

  • Compensation According to Region

 


WE HAVE HELPED MANY OTHER HR MANAGER LIKE YOU

TO UPGRADE THEIR HR SKILLS

We are experienced in HR Metrics and analytics. Many multinational companies are using our HR Metrics and  Analytics templates.

We are a Certified Training Firm of Chartered Institute of Personnel Management of Nigeria (CIPMN).

 

 

 

MEET THE GURU HIMSELF, MR. DEJI FOLARIN, THE BEST IN THE COUNTRY IN HR METRICS AND ANALYTICS, HE FACILITATED THE VIDEO COURSE

Ayodeji Folarin
MBA, MCP, ITIL, MCSD, MCSA, MCSE

Ayodeji has over twenty years of organizational experience in professional services, software development, business/system analysis, dashboard reporting, Data warehousing, IT solution services, IT training delivery and Project Management.

He has worked variously at Dangote Group (as Application Developer, Lead Facilitator in various IT Trainings), Lagos Building Investment Company -LBIC PLC (as Project Management Consultant), Green Unct Consulting (as Principal IT Consultant), Jireh Computer Solutions (as Managing Partner), Lakeshore Integrated Services (as Principal Consultant), Dangote Academy (as Training Partner)

He started pursuing his interest in training since 2001 while at Jireh computer solutions with responsibility as a lead facilitator to train Zenith Bank Staff nationwide. His style of training gave him great recognition in the training industry and he is currently on the faculty of consultant trainers for leading training organizations like Dangote Academy, Integrated Corporate services limited and many more.

HIS AREAS OF SPECIALTY INCLUDE DASHBOARD REPORTING, FINANCIAL MODELING, BUSINESS INTELLIGENCE, MICROSOFT OFFICE SPECIALTY, IT INFRASTRUCTURE LIBRARY, PROJECT MANAGEMENT, HR METRICS AND ANALYTICS, INFOGRAPHIC APPROACH TO PRESENTATION AND MANY MORE RELATED IT TRAINING.

AYODEJI IS A CERTIFIED TRAINER BY MICROSOFT (MICROSOFT CERTIFIED TRAINER – MCT); MICROSOFT CERTIFIED PROFESSIONAL WITH SEVERAL PROFESSIONAL CERTIFICATIONS LIKE MCP, MCITP, MCPD, MCTS; ITIL CERTIFIED; ORACLE CERTIFIED.

OTHER DETAILS

VIDEO PRICE

N10,000

 (for the 5 Modules)

 

 

HOW TO ORDER

Credit Our GTBank Account Number 0159819628 

(Barbados Solutions) 

Send Your Email Address Where You Want to Receive the Videos  to

0802-322-6334

 

Inquiries 

Dr. Biodun Omosaku

0802-322-6334 (WhatsApp/Call)

 

POWERED BY 
BARBADOS SOLUTIONS, 
21 ABEOKUTA STR. ANIFOWOSHE, IKEJA, LAGOS

0802-322-6334

I am a Neuro-Linguistic Specialist, Success Coach, mentor, and a Cognitive Psychologist. I have chosen to use my training and expertise to help others to become the very best they are created to be through my publications, seminars, books, and videos.

Leave A Reply

Your email address will not be published. Required fields are marked *