Altair Monarch Exercise 14 - Maynard Employee Analysis

Baba_Majekodunmi_703

Exercise 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:

1. How many employees were hired between 1990 & 1995?
2. Create a calculated field called "Bonus" that is 3% of Salary for employees in the 'Marketing' Department, and 2% for all other Departments
3. Who are the Top 5 Employees with the highest Salaries?

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.