Moving from Spreadsheets to Scripts in HR
Learn how to use programming languages like RStudio or Python to analyse data in HR
What will I learn in this Tech Bite?
In this tech bite led by Bennet Voorhees you’ll learn how to move from doing analysis in tools like Excel to leveraging programming languages like RStudio or Python to explore and manipulate your HR data. He walks you through a practical example, showing you how to analyse a common People Analytics request, like summarising employee survey data in Excel and in RStudio, so that you can build the skills you need to be able to analyse large sets of data faster and smarter. Finally, he explores the benefits and limitations of each approach, helping you make an informed decision about the best method of data analysis for you.
Who should take this Tech Bite?
This tech bite is designed for anyone in a People Analytics or Data Analysis role and anyone who is looking to better understand how to use RStudio to make data analysis simpler so that they can easily derive insights and translate those insights into recommendations.
By the end of this tech bite, you will have learned:
1. The benefits and limitations of doing data analysis in different platforms like Excel or RStudio
2. The necessary steps involved with analysing data in Excel vs RStudio
3. Other resources that you can leverage within myHRfuture to help you build a solid data-driven foundation.
What are Tech Bites?
Our tech bites are short, sharp, technical how-to videos that help you build practical skills and knowledge that can be applied immediately on the job, so that you can work smarter and press PLAY on your Career.
Earn your Tech Bite Badge
Not only will this tech bite help you build hands on skills while providing real life context to what you’ve learnt, but you’ll also be awarded a myHRfuture SHRM recognised certification, that you can share with your network at the click of a button.
So what are you waiting for? Sign up to myHRfuture today and Press PLAY on your Career.
myHRfuture is recognised by the Society for Human Resource Management to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM.
What skills will you build in this Tech Bite?
Other Tech Bites in this Series
Why join myHRfuture?
Learn from Industry Experts
Get access to exclusive bitesized courses taught by leading HR experts
Develop the HR Skills of the Future
Upskill in the knowledge you need to be successful in your HR career
Create Your Own Learning Playlist
Customise your learning experience by focusing on what you want to learn
500+ Curated Resources
Access training, articles, research, videos, podcasts and MORE
Frequently Asked Questions
When do courses start and finish? +
Access to courses starts now and never ends! All of our online training courses are completely self-paced - you decide when you start and when you finish.
How long do I have access to courses? +
After enrolling, you have unlimited access to all of our courses for as long as you have a subscription to the academy - across any and all devices you own.
How long does each course last? +
Our courses vary from 45 minutes long to just over 2 hours long and each course is broken down into bitesized modules, so you can watch and learn whenever you want and wherever you are.
Can I watch the courses on my mobile? +
Yes! Our website is mobile optimised so you can watch videos and access content on the go, just visit our site via your mobile and all of the courses will be available for you to watch wherever you are.
Do I get a certificate for completing a course? +
Yes, upon completing any course on the myHRfuture Academy, you will receive a digital badge and a PDF certificate to show that you have completed all of the course content.