Exercise Files

You can download all Monarch exercise files here: Monarch Sample Files for Exercises

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

1. How many employees work at the Maynard Corporation?
2. How many employees are in each department?
3. What is the Average (AVG) Salary for All Employees?
4. What is the Average (AVG) Salary by Dept?
5. What are the top 5 Zip Codes where Employees reside?

 

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.