Our course is thoughfully designed in such a way that learner gets the Real Time Investment banking & Equity Research exposure. Learner is not necessarily be from finance background, as our course ensures that Basic finance & account concepts are covered in detail with real time examples.
It is 80% practical with industry used case studies.
Our assessment & presentation evaluations are similar to top investment banks & equity research firms Our expert trainers are on hand to help answer any questions you might have along the way.
Online support from our team for all your queries based on ticket based tracking system
Get 3 certifcations inone course financial modeling, equity research and advance excel. You can show them seperately in resume.
Live case studies for each financial topics to ensure that learner can understand it thoroughly.
Our expert will assist you in resume building and job portal updation.
You get lifetime access to the FINXL LMS which includes videos, excel spreadsheets, presentations, ebooks, quizzes and case studies.
Our career square forum is ths most dynamic platform to connect with expert across the globe.
The HR Analytics course is designed for anyone interested in preparing for the role of Human Resource Analytics role. Also, you will learn how to use tools to analyse your data quickly.
Course duration: Intensive 60 hrs
▶ Module 1- Excel expert
This module empowers the
participant with a never before seen depth in almost all of Excel's powerful
Features with a focus on becoming an Expert, by 'Mastering' each of the
mentioned categories. The module offers Tips, Tricks, Data analysis and
comprehensive coverage of topics that you may not even be aware of
- Excel Essentials, Introduction to key board accelerators
- Manipulating and formatting rows/columns, boarder sheets
- Data Validation, Hyperlinking, Conditional Formatting
- Paste Special, Freezing & Unfreezing Panes, Text to Columns
- Inserting, Viewing & Editing Comments, Removing Duplicates
- Using VLOOKUP & HLOOKUP, Using SUMIF, COUNTIF, AND AVERAGEIF
- Using the TRANSPOSE and SUMPRODUCT function
- Working with dates - DATEDIF, YEAR, YEARFRACE & MONTH
- Pivot table, Sensitivity analysis with Data tables
- Charting commonly used, Index, Search, Choose, offset
▶ Module 2- HR Analytics
⁃ Characteristics of HR analytics
⁃ Strategic focus for HR analytics
⁃ Major problems facing HR analytics
Skillsets
⁃ Most important skills required
⁃ Skills needed in a HR analytics team
⁃ Skillsets & experience needed in various positions of the
HR analytics process
▶ Module 3- BUILDING THE BUSINESS CASE
Variables
⁃ What are dependent variables and control variables
⁃ Impact of a moderator variable
⁃ How a mediator can affect the outcome
HR
Value Chain
⁃ How the HR Value Chain works and who are driving forces
⁃ HR Value Chain can be used to achieve business optimum outcomes
from HR
Applying
the HR Value Chain in Real Life
⁃ Steps are after defining the business problem
⁃ Explain how you can create measurable and impactful metrics to
measure HR effectiveness
Examples
of Analytics Cases
⁃ Real time examples where analyse factors that drive employee
turnover
⁃ Explain the link between engagement and performance
⁃ Understand the
principles that drive absenteeism
Building
the Business Case for HR Analytics
⁃ Understand the link between diversity and innovativeness
⁃ Explain the relationship between innovation and revenue
⁃ Describe how education does not translate into leadership
▶ Module 4- DATA AUTOMATION, DATA CLEANING
⁃ Learn how to automate the big data
⁃ Importance of a pilot analysis
⁃ Capability & compliance building of HR analytics
Data
& Metrics
⁃ Explain the purpose of HR metrics/data
⁃ Categories of performance
⁃ Performance measurement of various HR operations
Data
Cleaning
⁃ Create several descriptive statistics in R
⁃ Understand how to clean HR data in R
⁃ Transform HR data into
plots and graphs in R
Creating
HR Metrics
⁃ Understand organizations structures
⁃ Understanding of KPIs and result description
⁃ Transform strategic goals to HR metrics and see its result in
dashboard
▶ Module 5- REPORTING INSIGHTS
Reporting
& Advising
⁃ Describe the various rules of reporting HR analytics
⁃ Understand the mindset in reporting HR analytics
⁃ Explain the importance of data visualization
Data
Visualization
⁃ Understand why design is important in reporting
⁃ Explain how to put insights into perspective
⁃ Describe the basic principles of information design
Cash
study and assessment
Pre-Requisites
Anyone with graduation degree can appear for this course. No prior knowledge for HR function needed.
Target Audience
- If you are HR and would like that your decisions should be accurate and backed by logical data
- If you are from mathematics or statistic background and would like to analyse companies and their operations
- I - you would like to bring changes in your organization
as most of the HR teams are still working in old fashion.
Research Companies
All companies have Human Resource as separate department. Now a days, every company needs analysed information to take correct and timely decisions. Demand of HR Analytics professionals are on its top these days.