Это видео недоступно.
Сожалеем об этом.
How to evaluate and visualize an internal equity or pay compression issue?
HTML-код
- Опубликовано: 25 апр 2021
- Want to learn how to design a salary structure? Check: www.caripros.com/design-salar...
FREE template for my video: Excel for HR - Create Annual Employee Salary Increase Template from Scratch. You can download and try it out yourself here: bit.ly/2MLLdb7
FREE actual workbook for my video "Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner". You can download and try it out yourself here: bit.ly/2UmeX2v
New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:
caripros-hr-analytics.teachab...
Topic: HR Topic - In this video we discussed how we define internal equity or pay compression issue and how I would go about to analyze my sample employee data and visualize in Excel to uncover the issue.
*****Follow-up Consulting Services*****
If you have specific question regarding your issue, you can email me at the email here goo.gl/WejijZ
Note that there will be a fee of US$200 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link: www.paypal.me/caripros
*****More Videos in Playlists*****
Power BI for Beginners: bit.ly/3ivKitD
Power BI for Advanced Users: bit.ly/3lE9zmO
Excel for HR goo.gl/JdeVnd
Excel for HR - Master Class goo.gl/LYfq2f
Excel Macro - Beginner goo.gl/Yae5nc
Excel Macro/VBA - Splitting a Master File goo.gl/m8CHya
Excel Macro/VBA - Auto-hide Rows or Columns bit.ly/2Mzteb5
Excel Charts Data Visualization goo.gl/2ao6BP
Excel Vlookup Function goo.gl/kP2Wpz
Excel Pivot Table Function goo.gl/rukkPs
Excel Array Function goo.gl/i4sQH8
Excel Index and Match Function goo.gl/i7VGU4
Excel Solver/Goal Seek Functions goo.gl/FTkTnj
Excel Cell Formatting Solutions goo.gl/gpa6MY
HR Analytics - Merit Matrix goo.gl/Koy7co
HR Analytics - Salary Structure goo.gl/uZBnFa
Excel Tricks goo.gl/TeqGDw
Excel Troubleshooting goo.gl/bdY5by
Fun HR Topics goo.gl/7zVg8h
For more successful stories, view at: caripros.com/index.php/success...
#ExcelforHR#HRAnalytics#Excel#HR
Really enjoyed your content. Hope you will be sharing more Compensation insight. Thank you!
Many thanks for your videos, they are super useful! 👍🏻👍🏻👍🏻
Very Nice, explanation on pay compression
Your skills are great 👍 I am one of your subscriber for last 2 years.. please never stop sharing and uploading videos .. all videos are very helpful .. thankss🇮🇳
Thank you so much 😀 will continue with my best efforts!
🤗🤗👍👍🙏
@@CariprosHRAnalytics could you please explain how to do this for large data sets, and how to incorporate performance rating
Right on target! My sheets look very similar to yours. Ya!
Could you please explain this with large data sets and how to incorporate performance rating in the chart'
You are excellent
super useful :)
Amazing video. One question: When you made the scatter plot comparing tenure and salary, you mentioned that in a mathematical world you would see a 45 degree line. Is it safe to say that the 45 degree line is an industry benchmark or a goal to try a reach to? That question excludes performance.
Thanks for the video. A quick question, if I have a large set of data, how can I color the dots based on performance? Is there a quick way, or it should be done manually? :-)
oh seems that i didn't cover this in the video. I will do another video to show it
@@CariprosHRAnalytics did you get to do the video showing how to reflect performance on the chart? :)
Thanks for sharing. Could you please tell me how to combine the rating into chart? I only manage the get the scatter chart with compo ratio and tenure 🙏🙏🙏
oh seems that i didn't cover this in the video. I will do another video to show it
@@CariprosHRAnalytics did you ever create a video that shows how you included the rating coloring in the scatter chart?