A program to recognize and reward our most engaged community members
You are a Human Resource Information System Analyst (HRIS) and your manager has asked you to answer the following questions using Altair Monarch Classic by analyzing the Maynard.txt file:
An attempt.... Looking forward to learning new tricks.
Hi Shelton!
Great attempt here! I have already posted the answers to this in the Monarch Success Plan, but a few quick comments;
1. Yes! This is correct.
2. Yes! This is correct.
3. Almost, there. Adding a Sort by Salary (Descending Order) would help you with this. I did notice that one of the salary values for one employee was different though.
Question for you; Do you think a webinar to review these would be helpful?
Hi Shelton,
By the way, the Sort option mentioned by Baba is in the Table window. I think you have used the Sort option on a key field in a summary on your example. Note how this sorts by the total value of all records that have same summary key value. Therefore, Banning is at the top of the list with their individual 87,570. Then it is the combined value of (37,500 + 44,800) = 82,300 for the two employees called Marshall. Then Hampsted, with a combined total of 80,100, then Smith on their own with 75,000 . . and so on.
Thanks. I should have realized that multiple employees had the same name.
Hi,
I solved few.
@Baba Majekodunmi
Can you share vidoe links in 'Monarch Data Preparation part', so that we have more techniques to decode the problem.
@Baba Majekodunmi Can you share vidoe links in 'Monarch Data Preparation part', so that we have more techniques to decode the problem.
Question 1:
As per your answers you got 29 as per Monarch Classic, but we used Monarch Data Prep we got 32, how ?
Your answers link:
https://community.altair.com/community?sys_id=6828c1301b8be510507ca6442a4bcbe4&view=sp&id=community_blog&table=sn_communities_blog
Here are my table and summaries for the top 5 and hires 90-95
Hi Susan! You got #1 and #2 correct.
Can you share the formula you used for #3 - the bonus calculation?
@Baba Majekodunmi Can you share vidoe links in 'Monarch Data Preparation part', so that we have more techniques to decode the problem. @Baba Majekodunmi Question 1: As per your answers you got 29 as per Monarch Classic, but we used Monarch Data Prep we got 32, how ? Your answers link: https://community.altair.com/community?sys_id=6828c1301b8be510507ca6442a4bcbe4&view=sp&id=community_blog&table=sn_communities_blog
Yes that is correct. I made a mistake during the recording. The correct answer is 32.
@Baba Majekodunmi , thank you for confirming, really i am enjoying learning.
Thank you for the vidoes and exercies.
Fun exercise - I've attached shots of generated tables. I watched the answers video as well. Nicely presented and very informational.
Thank you,
Submissions attached.
3 attachments
