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.
Find more posts tagged with
Comments
- 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.
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.
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.
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:
@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.
An attempt.... Looking forward to learning new tricks.