HR Analytics With MS Excel Course

 

If you cannot read this properly, please go to this site: http://3pointe.com.sg/hr-analytics-with-ms-excel-19-20-may-2014/ . HR Masterclass Course Information Date: 19 – 20  May 2014 Time: 9am – 5.30pm Venue: Rendezvous Hotel Fees: S$730 (EarlyBird or 2-To-Go) S$890 (normal) Early Bird Date: 20th April 2014 Note: Companies can claim 400% tax deductions or 60% cash payout of total training expenditure under the Productivity and Innovation Credit (PIC) Scheme. Trainer: Mr S.Shivesh Click Here For The Registration Form Back by Popular Demand.   HR Analytics With MS Excel Course – [19-20 May'14] “I wish, my HR Head could have seen this coming at least 3 months in advance” ~ A CEO of a very large Indian firm, as the crisis hit his firm. In recent years, companies of all sizes and geographical representation have been facing increasing challenging human capital issues.   A never before transformation has taken place in the traditional HR model into what is now a business partnership model which demands HR professionals and managers to engage with internal business leaders strategically. According to a research by MIT Sloan, top-performing companies are three times more likely than lower performers to be sophisticated users of HR analytics. In this course, you will learn about how to perform key analytics that will give you the information needed to equip you as a strategic business partner, and how to leverage on common features on Microsoft Excel to generate the data needed. Testimonials: “The course wowed me with the trainer’s calibre, substance and delivery.”  – HR Manager, Singapore Government Organzation “I am now able to see the value in identifying the concept behind the analysis and is now able to more in carrying out analysis” – HR Executive, SME Who Will Benefit HR Business Partners, Managers and Executives who need to make sense of data and present strategic business related information to the management.  This workshop is also relevant to any non-HR professionals and managers who want to gain a better understanding on how HR can play a strategic role in providing vital information to support the business. Learning Objectives After this workshop, you will be able to: Use data to respond to business situations, Interpret how HR data flows in, and links with other databases Understand best practices regarding HR analytics and HR Dashboards Conduct Predictive Analytics for productivity, rewards and performance Improve organizational performance through high quality talent related decisions Understand how to marshal resources within your organization to facilitate using metrics and analytics. About The Trainer Mr Sanjeeva Shivesh has more than 20 years of experience in business strategy with firms like Indian Railways, Booz & Co (London) and FIRE Capital Fund. As a corporate trainer, he specializes in program design for adult learners. In HR field, he has designed programs such as HR Analytics, Competency based Interview, Competency based Assessments, Balanced Scorecard, Total Rewards Management etc.  He holds a MBA from Cranfield School of Management, one of the top 20 Business Schools in Europe. Learning Agenda Day 1: HR Dashboards and Matrices Module 1: Introduction to Evidence Based HR Exploration into the concepts of Evidence based HR How different firms are using data driven approach to HR decisions Case studies from financial services, retail, technology, sports, etc. Module 2: Fundamental HR Metrics for success Metrics for Workforce Planning, Recruitment & Selection, Compensation and Benefits, Performance, Career Development, Attrition, Utilization, ROI etc Challenges with Metrics HR Dashboard Planning Interactive HR dashboard design exercise Participants working in groups work through a real life example to identify select and prioritize various HR Metrics linking to the strategy of the firm for their respective domains Recruitment and Selection, Talent Management, Learning and Development, Performance, Total Rewards etc. Module 3: Implementation of Metrics Participants shall be given a group assignment on the implementation of metrics for in-class practice and discussion based on what were discussed in Module 2. Day 2: HR Analytics Session Module 4: Fundamental Tools for HR Analytics Conducting exploratory analysis, exception analysis, variance analysis, hypothesis testing, regression analysis Case Study on Relationship between performance and pay Module 5: Analysis of HR Data in Microsoft Excel HR related Data Handling, Collection and Presentation, using graphical and numerical techniques like statistical and probability theory Case study: Participants work through examples on manpower planning, employee engagement in Microsoft Excel Module 6: People Development Analytics Choosing the right tools for Assessment and Development, validation of tools, Training Analytics Case Study: application for people development in successful firms, Return on Training Investment Module 7: Predictive Modeling in HR Analytical Tools for determination of cause-effect relationship, regression, multiple regressions, cluster analysis, factor analysis etc. Case studies from various sectors to be discussed. Learning Materials Every participant will receive Learner’s kit including notes, templates and case studies.  Participant will receive via email a set of the templates in soft copy. Certificate of Completion Informal consulting via phone/email for one year from date of certification Participant Fee Standard: S$890 Nett (S$356 Nett after PIC grant – Cash Payout Option) Early Bird: S$730 (S$292 Nett after PIC Grant – Cash Payout Option) Form must reach us by 20th April 2014 Group of 2 or more: S$730 Nett (S$292 Nett after PIC Grant – Cash Payout Option) *Enjoy up to 400% tax deduction or 60% cash payout under the Productivity and Innovation Credit (PIC) scheme for Staff Training. Find out more here Registration: Registration Form Please email the completed physical form to: enquiry@3pointe.com.sg or fax to: 6520 9851 For further queries, please contact us at: Email: sales@3pointe.com.sg    Or call Michael at: 9669 6694 This email is an advertisement. We sincerely apologize if you find this email an intrusion of your privacy or a source of inconvenience to you. If you no longer wish to receive our email advertisements – please click here. Thank you.