HR Analytics for Beginners - A Roadmap

Подписаться 75 тыс.

Просмотров 49 тыс.

50% 1

In this video I provide a roadmap for HR analytics for beginners. The secret to this roadmap is to leverage your basic Microsoft Excel skills to learn powerful data analytics techniques.
The good news is that a relatively small number of techniques can be used in a wide variety human resources analytics scenarios.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 • Introduction to Busine...
🤖 From Excel to Machine Learning. No, Really! 🤖
Yes, you read that correctly. ANY professional can move from Excel pivot tables to analyzing data using machine learning. 💥
Check out the following RU-vid video to learn more:
• From Excel to Machine ...
Stay healthy and happy data sleuthing!
#HRAnalytics #HumanResourcesAnalytics #HRAnalyticsForBeginners

Наука

Опубликовано:

14 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 34

@DaveOnData 3 года назад

💥 Learning R programming is easy for Excel users! 💥 📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MNpsyjSuR20.html 👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xIXymabyFIM.html

@priyankaghosh3400 3 года назад

Thank you sir

@DaveOnData 3 года назад

@@priyankaghosh3400 - You are welcome!

@MsDollyO2468 3 года назад

Ah Dave, I just watched this again and it's solid gold. I wish I knew you 5 years ago when I was starting out the transition to HR analytics, I could have avoided so much confusion and uncertainty! I cannot express how well structured and thoughtful this roadmap is to any HR professional at any point of their data analytics journey. It's rare for an educator like Dave that is so encouraging and willing to teach you the essentials as well as advanced analytics techniques for free. N.B. Any of the #DaveOnData paid courses are also a worthwhile investment, I'm working through his Intro to Linear Regression w/ Excel and other class webinars. I can attest that the same amount of guidance, clarity, enthusiasm and structure follows throughout! Like Dave always says "You've got this if you want it".

@DaveOnData 3 года назад

Greetings, Dolly! Thank you so much for taking the time to provide such a nice comment. This means a lot to me given that you are a HR professional yourself - who better to attest that the roadmap in the video is legit? 😁 So glad that you are finding my content and courses valuable for your analytics journey.

@PennyPanPiano Год назад

Thank you! Exactly the information I am looking for. You are awesome!

@VhangorD2 2 года назад

Hi! I loved this video. I've been working in HR for the last 12 years, and recently started to learn data analytics. Currently learning python bit I'm planning to take the Google Data Analytics certification after that. This video helps me to merge both HR and Data Analytics. Looking forward to watch more of your content. Thank you!

@DaveOnData 2 года назад

Awesome! Glad you found the content useful.

@joyeniang2757 Год назад

Hello

@tscaradine Год назад

This is amazing. I'm so happy I found your channel.

@dating_life350 2 года назад

Awesome, thank you for sharing :)

@emmaibanga7220 Год назад

Hi David, this video is helpful.

@kingsleyoguike5478 Год назад

thanks notify me of the road map

@jigsey. Год назад

I've an interview tomo in my current employer...I'm a procurement specialist who plans buying stock for a busy hospital..I've reached the furthest point.. so the other other I applied for an HR analyst... Thanks for the excellent video

@amitmukherjee5289 2 года назад

Hi Dave, Firstly thank you for posting this great video about the roadmap on HR Analytics. I am a HR professional and currently in between jobs, so I thought of up sharpen my skills. My question to you is in your other videos on Linear regression, SQL, Business analysis etc do you provide step by step guidance of how to go about it? Also for practice purpose do you or can you provide dummy data?

@DaveOnData 2 года назад

Awsome, glad you like the video! Regarding learning the techniques discussed in the video, check out the following: 👉 My online course that teaches the mighty process behavior chart: 📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xIXymabyFIM.html 👉 My FREE hands-on SQL tutorial playlist: 📺 ru-vid.com/group/PLTJTBoU5HOCSrExoOVTjDG33lFpDvmz2w 👉 My online course program taking you all the way from Excel to R to Machine Learning: 📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-b6hiyLEFA_M.html

@amitmukherjee5289 2 года назад

Thanks Dave once again for replying to my query along with the required information and more.

@DaveOnData 2 года назад

My pleasure!

@denwo1982 2 года назад

Do you have examples of R code I could use for a basic flat file of employee data that consists of employment Id, employee name, start date, end date, current salary, previous salary, gender etc… just trying to understand what are the benefits and answers I would get that I couldn’t get from writing it in sql? As that is my background sql server, then using bi tools like business objects, qlikview, ssrs and power bi etc..

@amitmukherjee5820 2 года назад

Hi Dave, as per the road map you have highlighted 3 main topics Excel, SQL and R. But I see many other sub topics and it seems a bit confusing as from where do I start my learning. So just a suggestion if you could make one video for just Excel and within it include Business Analysis and Regression, another for SQL and another for R and all the sub topics with it. Also can you provide sample excel spreadsheets for us to try what we learn? Sorry for asking too many questions

@DaveOnData 2 года назад

If you are referring to the subtopics under each of the green chevrons, they are simply breakdowns of what should be learned. For example, my online course "Introduction to Business Analysis With Excel" teaches all of those subtopics. My Excel online/live courses provide all the Excel workbooks needed for completing the hands-on labs. Also, my free "Introduction to SQL for Excel Users" covers all the topics needed to get started. Lastly, my online course bundle "From Excel To Machine Learning" teaches all of the topics listed and provides R code files for completing the hands-on labs.

@rgapa0108 2 года назад

Thanks David! Excellet information.. This is a great way to know where to start. I've seen a few comments about Python being a good choice for beginners. Any thoughts about it?

@DaveOnData 2 года назад

Great question! My experience has been, that R programming is typically much easier for professionals to learn if they have never used a formal programming language before. This is based on training 100s of professionals live and 1000s more via my online tutorials. The reason is that R code very much matches Excel code. For example, the following code shows how to calculate the average of a column of numbers in a table using Excel and R (BTW - "mean" is another name for "AVERAGE"): 👉 Excel: =AVERAGE(iris_data[Petal.Width]) 👉 R: mean(iris_data$Petal.Width) Look very similar, no?

@user-tl8iq1ik7l 2 года назад

Hi Dave,, I want to master excel.. I’m struggling really .. how can I master if? Can you advice if you have videos or training courses. Thanks in advance

@A96000 Год назад

Kind of shocked you didn't mention data visualization software like PowerBI or Tableau

@thanhtien2318 2 года назад

how did you do it can you share with me , thank you

@henriethaezeji Год назад

Hello Your video is very enlightening 4:09 please I have a question Is it possible to use KPI Analysis for thesame organization calculating between 2 periods

@sanchiareaz8440 3 года назад

Hi David! How do we get hold of the competitor’s bad attrition data, to compare.

@DaveOnData 3 года назад

If I understand your question correctly, getting that information is likely to be difficult as I would be companies would consider that proprietary information. It's possible that you might be able to secure industry survey data (e.g., attrition rates of software engineers in the tech industry) to use for comparison.

@manishshahi1655 2 года назад

Can I learn hr analytics while pursuing MBA HR

@MehdiBadriyan 3 года назад

Can you introduce a source for HR analytics in more details?

@DaveOnData 3 года назад

Hoping to get a point of clarification. Are you looking for resources on applying standard techniques (e.g., linear regression) to HR data?

@MehdiBadriyan 3 года назад

@@DaveOnData I’m looking a source that introduced the application of Machine Learning techniques in the HR topics and problems.

@DaveOnData 3 года назад

I'm not super familiar with specifics in this space. A quick search on Google returned this book: www.amazon.com/Predictive-Analytics-Resource-Management-Hands-ebook/dp/B08M31LY3H/ However, I would offer that a HR-specific machine learning book might not be necessary as you can think of interesting HR questions to analyze with machine learning in three categories: 1 - Classification: training models that predict a category (e.g., "Is this employee going to quit, yes or no?") 2 - Regression: training models that predict a numeric value (e.g., "How long is this employee going to stay in months?") 3 - Clustering: given a HR dataset, can I mine out any interesting groupings? If you have the HR business questions that you want to answer, then you can map the above to machine learning using an introductory book on machine learning/data mining (e.g., the mighty random forest for 1, linear regression for 2, and k-means for 3). HTH, Dave