Monarch Learning Series 2023 Exercise 1 - Maynard Employee Analysis
Altair EmployeeExercise Info
- Application (Classic vs Data Prep Studio): Classic
- Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
- Skills/Features Tested: Report Trapping, Calculated Fields, Filters, Summary, Top N Analysis
- Systems of Record: Not Applicable
- Estimated Time to Solve: 15 mins
- Exercise files required are attached
- Maynard.txt
Exercise Overview
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:
- How many employees were hired between 1990 & 1995?
- Create a calculated field called "Bonus" that is 3% of Salary for employees in the 'Marketing' Department, and 2% for all other Departments
- Who are the Top 5 Employees with the highest Salaries?
Answer
- Please attach your answers below in the comment section for the exercise
- A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Learning Series Solution' section.
Comments
-
An attempt.... Looking forward to learning new tricks.
0 -
Shelton Vance_22282 said:
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?
0 -
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.
0 -
Thanks. I should have realized that multiple employees had the same name.
0 -
Hi,
I solved few.
- How many employees were hired between 1990 & 1995? -- Attached: Between1990-95.xls
- Who are the Top 5 Employees with the highest Salaries? -- Attached: Top-5-Salaries.xls
- Create a calculated field called "Bonus" that is 3% of Salary for employees in the 'Marketing' Department, and 2% for all other Departments -- working on it.
0 -
@Baba Majekodunmi Can you share vidoe links in 'Monarch Data Preparation part', so that we have more techniques to decode the problem.
0 -
Bhagyaraj Mullangi said:
@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:
0 -
Here are my table and summaries for the top 5 and hires 90-95
0 -
Susan DeWitt said:
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?
0 -
Bhagyaraj Mullangi said:Bhagyaraj Mullangi said:
@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:
Yes that is correct. I made a mistake during the recording. The correct answer is 32.
0 -
@Baba Majekodunmi , thank you for confirming, really i am enjoying learning.Thank you for the vidoes and exercies.
1 -
@Baba Majekodunmi Fun exercise - I've attached shots of generated tables. I watched the answers video as well. Nicely presented and very informational.
Thank you,
0 -
-