💥 Learning R programming is easy for Excel users! 💥 📺 ua-cam.com/video/MNpsyjSuR20/v-deo.html 👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 ua-cam.com/video/xIXymabyFIM/v-deo.html
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!
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".
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.
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
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
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.
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?
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: 📺 ua-cam.com/video/xIXymabyFIM/v-deo.html 👉 My FREE hands-on SQL tutorial playlist: 📺 ua-cam.com/play/PLTJTBoU5HOCSrExoOVTjDG33lFpDvmz2w.html 👉 My online course program taking you all the way from Excel to R to Machine Learning: 📺 ua-cam.com/video/b6hiyLEFA_M/v-deo.html
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?
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?
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..
I am still a student and i don't have work experience in hr field yet So, would this work with me or i must work firstly in a real jop as an hr then i can transmit
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
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.
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
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
💥 Learning R programming is easy for Excel users! 💥
📺 ua-cam.com/video/MNpsyjSuR20/v-deo.html
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 ua-cam.com/video/xIXymabyFIM/v-deo.html
Thank you sir
@@priyankaghosh3400 - You are welcome!
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!
Awesome! Glad you found the content useful.
Hello
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".
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.
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
This is amazing. I'm so happy I found your channel.
Thank you! Exactly the information I am looking for. You are awesome!
thanks notify me of the road map
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
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.
Hi David, this video is helpful.
Awesome, thank you for sharing :)
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?
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:
📺 ua-cam.com/video/xIXymabyFIM/v-deo.html
👉 My FREE hands-on SQL tutorial playlist:
📺 ua-cam.com/play/PLTJTBoU5HOCSrExoOVTjDG33lFpDvmz2w.html
👉 My online course program taking you all the way from Excel to R to Machine Learning:
📺 ua-cam.com/video/b6hiyLEFA_M/v-deo.html
Thanks Dave once again for replying to my query along with the required information and more.
My pleasure!
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?
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?
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..
Kind of shocked you didn't mention data visualization software like PowerBI or Tableau
I am still a student and i don't have work experience in hr field yet
So, would this work with me or i must work firstly in a real jop as an hr then i can transmit
Yes! You can learn valuable data analysis techniques without a job in the field.
how did you do it can you share with me , thank you
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
Hi David! How do we get hold of the competitor’s bad attrition data, to compare.
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.
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
Can you introduce a source for HR analytics in more details?
Hoping to get a point of clarification. Are you looking for resources on applying standard techniques (e.g., linear regression) to HR data?
@@DaveOnData I’m looking a source that introduced the application of Machine Learning techniques in the HR topics and problems.
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
Can I learn hr analytics while pursuing MBA HR