Altair Monarch Exercise 1 - Employ
Baba_Majekodunmi_703
Altair Employee
Exercise Info
- Application (Classic vs Data Prep Studio): Classic
- Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
- Skills/Features Tested: Report Trapping, Filters, Calculated Fields, Summary
- Systems of Record: Not Applicable
- Estimated Time to Solve: 10 mins
- Exercise files required are attached
- Employ.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 Employ.txt file:
- How many employees work at the Maynard Corporation?
- How many employees are in each department?
- What is the Average (AVG) Salary for All Employees?
- What is the Average (AVG) Salary by Dept?
- What are the top 5 Zip Codes where Employees reside?
Answer
- Please upload 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 Exercises' section.
0