課程介紹

You’re looking for a complete course on understanding HR Analytics using Excel to drive business decisions, right?

You’ve found the right HR Analytics using MS Excel course! HR analytics provides scientific support to decision-making concerning a fi

…[更多細節]

哪些人適合這堂課？

• Anyone curious to master HR Analytics from beginner to Advanced in short span of time
• Student who wants to have a career in the field of HR/ HR Analytics
• HR manager/ executive who wants to expand on the current set of skills

學習目標

• Use MS excel to create and automate the calculation of HR metrics
• Make HR Dashboards and understand all the charts that you can draw in Excel
• Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
• Use pivot tables filtering and sorting options in Excel to summarize and derive information out of the HR data
• Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real world HR problems
• Knowledge of all the essential Excel formulas required for HR Analytics
• Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index and Match

課程介紹

People analytics is also known as HR analytics or you can say talent analytics. It is kind of analytics which helps HR managers, executives to make data-driven decisions about their employee or the workforce. It gives you expertise in using statistic

…[更多細節]

哪些人適合這堂課？

• HR Professionals who want to incorporate data analysis into their practice.
• Managers who want to make data-driven decisions about employee, teams and their management practices.
• Data Analysis professionals looking to apply their skills to people management decisions.
• Students learning HR.
• Students or any individual who want to advance into HR.
• Business owners and Entrepreneurs.

學習目標

• A Step by Step Approach to solve Business Problems in the area of People Analytics.
• Understand the concepts of Statistical model building.
• Journey of Analytics.
• HR analytics and its importance.
• Employee life cycle the areas where you can use analytics.
• Get an understanding of HR metrics and the Journey from Metrics to Analytics.
• Identify a business problem and its importance. You’ll also learn how to convert a business problem into statistical problem.
• Understand the science behind gathering the data from various sources and how to do it right.
• Understand how to create an efficient data dictionary for better understanding and future reference.
• Identify the dependent and independent variable in your dataset.
• Understand and learn about various file formats in which the data is stored Understand the steps involved in data preparation.
• Various methods to measure Central Tendency, Variability and Shape of data.
• Understand the steps involved in hypothesis testing, Univariate and Bi-variate Analysis.
• Learn the concepts of Feature Engineering.
• R and Rstudio: Installation, importing files and installation of packages.
• Understand the concept of Machine Learning – Supervised and Unsupervised Learning Techniques.

課程介紹

HR analytics is also known as people analytics or you can say talent analytics. It is kind of analytics which helps HR managers, executives to make data-driven decisions about their employee or the workforce. It gives you expertise in using statistic

…[更多細節]

哪些人適合這堂課？

• Data Analysis professionals looking to apply their skills to people management decisions.
• HR Professionals who want to incorporate data analysis into their practice.
• Managers who want to make data-driven decisions about employee, teams and their management practices.
• Students learning HR.
• Students or any individual who want to advance into HR.
• Business owners and Entrepreneurs.
• And the most important is applying machine learning on HR Data and predicting futuristic insights.

學習目標

• Learn applied statistics right from scratch and move to machine learning.
• Simultaneously learn analytics on R and Python.
• Understand the steps involved in data preparation.
• Various methods to measure Central Tendency, Variability and Shape of data.
• Understand the steps involved in hypothesis testing, Univariate and Bi-variate Analysis.
• Learn the concepts of Feature Engineering.
• Identify the dependent and independent variable in your dataset.
• Understand the concepts of Statistical model building.
• Identify a business problem and its importance.
• Understand the concept of Machine Learning – Supervised and Unsupervised Learning Techniques.
• 4 Hands-on case studies.
• More than 20 types of charts/plots.
• All of it with practical approach.

課程介紹

_____________________________

Updated in Nov 2020

Details of Update: Added 9 new lectures that covers step by step procedure to perform various HR Analytics and Data visualization using ‘Orange’ – A powerful open source data mining and ML tool

___

…[更多細節]

哪些人適合這堂課？

• HR professionals & managers who are required to analyze and solve HR issues based on data
• MBA HR Students
• HRBP & HR Generalists
• L&D Professionals
• C&B Professionals
• Recruitment Professionals

學習目標

• Select relevant HR Metrics relevant for your organization and build HR Dashboards
• Know what data to look for in various scenarios relating to HR
• Select the right analytics methods/tools for a given HR scenario
• Create Histograms, Boxplots and perform necessary analysis to validate various HR Scenarios with data
• Use scatter diagram, correlation, chi-square test, ANOVA, T-Test to validate HR Hypotheses
• Build simple predictive models using Regression
• Lead a HR Analytics project

課程介紹

To view our complete offering, search for “Jeff Higgins”.

More about this Course

This workshop provides attendees with the foundation knowledge, examples, and tools they need to successfully jumpstart the Workforce Analytics journey in any industry

…[更多細節]

哪些人適合這堂課？

• HR professional who’s interested in using data to determine where to cut, where to invest and whom to invest
• Beginner data scientist who’s interest in maximize the return on HR’s human capital investments

學習目標

• High-level briefing focusing on case studies and examples to help HR jumpstart Workforce Analytics journey
• Understand the basic foundation and benefits of Workforce Analytics
• How to create a winning business case for HR
• How to speak the language of business and get funding for your next project
• Foundation to measure, track and analyze the impact of various workforce intervention decisions

課程介紹

The job of HR is not an easy task. One has to manage a huge number of employees – From acquiring good people to retain them is an intricate task.

This course will help them to perform their mundane tasks and analyze data well.

Simply gathering data

…[更多細節]

哪些人適合這堂課？

• Intermediate to Advanced Excel Users

學習目標

• Analyzing Expense Claims
• Analyzing Google Forms Survey
• Data Cleaning for Emails
• Fuzzy Lookup

課程介紹

This is the second course in our series “People Analytics : Learn ~ Practice ~ Implement”.

Our mission is simple – “Help anyone learn Data Science, create projects they were passionate about, and use those projects to improve their careers and lives

…[更多細節]

哪些人適合這堂課？

• Managers who want to make data-driven decisions about employee, teams and their management practices.
• HR Professionals who want to measure and improve employee satisfaction in their organization.
• Business Owners and Entrepreneurs.
• Students or any individual who want to advance into HR.

學習目標

• End-to-End Statistical project on Employee Satisfaction Using Factor Analysis in R.
• Master practical skills to solve HR business problem using Step-by-step approach called “Anatomy of a Statistical Model”.
• Understand how employee satisfaction affect business in terms of money?
• Convert Employee Satisfaction business problem into a Statistical problem.
• Understand how to discover and collect data.
• Understand how to prepare and explore the data for meaningful insights.
• Apply the dimension reduction technique to find significant factors for Employee Satisfaction.
• Extract major findings and insights from the statistical solution.
• Understand how the insights will help leaders make strategies and policies to improve employee satisfaction.

課程介紹

This important new and lastest course in HR covers the important and new field of hr analytics and people analytics.

As human resource management, people management,  hr analytics and people analytics drive the market for HR professionals this new H

…[更多細節]

哪些人適合這堂課？

• Anyone interested in using HR Analytics. Ideally for those working in, or looking for a career in, HR or in Data Analytics

學習目標

• Learn about the importance of HR Analytics to those either in HR or Data Analytics
• Understand how a good awareness of HR Analytics is vital to career development
• Be able to communicate with others about HR Analytics
• Know the key phrases and language used in discussing HR Analytics
• Understand HR as a service
• Be aware of the various of elements the customers of HR expect
• Know how to put forward a Business Case and the use of analytics in that
• Be able to conduct a strategic analysis of the business or organisation
• Be able to outline the important role of HR in determining Business Strategy
• Identify the ways in which HR can help meet the Business Strategy
• Discuss the evolution of HR Analytics
• Explain the various types of HR Analytics available
• Explain the Problem Solving Process
• Discuss the recruitment process and data analytics in that process
• Consider the talent development process, KPIs and Return on Investment issues
• Explain Staff Engagement and Empowerment
• Outline Performance Appraisal and data arising from such systems
• Outline some of the challenges faced with data
• Outline data modelling

課程介紹

Well, we’re going to build an interactive dynamic dashboard in excel. Yes you heard it right. We gonna create it in MS Excel. No, we are not kidding…. Let me show you the end result, then you might believe me. You may have seen dashboards in tableau,

…[更多細節]

哪些人適合這堂課？

• Anyone who would like to take his Excel Skills to the next level
• Those who are dealing with reporting and want to take it to the next level
• Those who want to influence the manager and raise or get promoted

學習目標

• Learn how to create a professional KPI dashboard from scratch
• Build Interactive Dashboard Reports with Buttons and Drop Down Menus
• Streamline and Analyze Data with Excel PivotTables and Linked Charts
• The Art of creating Visually Stunning Excel Dashboards
• You can write some macros and design KPI Dashboard.
• Use effective design principles when creating and presenting data
• Effectively summarize and present data clearly
• How to approach an Excel dashboard project from idea to delivery
• Impress management with reports that make the decision-making process faster

課程介紹

To view our complete offering, search for “Jeff Higgins”.

More about the Course

Executive briefing focused on case studies and examples to help talent managers consume analytics insights and better understand the role of Workforce Analytics in busi

…[更多細節]

哪些人適合這堂課？

• Executives curious about the benefit of evidence-based talent management
• Managers who want to see what it takes to use Workforce Analytics to improve their decision making process

學習目標

• Executive briefing focusing how decision makers can utilize Workforce Analytics in creating their workforce strategy
• The business imperatives of linking workforce to business strategy
• Step-by step guide on aligning workforce strategy to business objectives
• Real-life success examples and case studies
• Understand the basic foundation of Workforce Analytics