Altair Monarch Exercise 5 - Homes Analysis

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Classic
• Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
• Skills/Features Tested: Report Trapping, Filters, Calculated Fields, Summary
  
• Systems of Record: Not Applicable
• Estimated Time to Solve: 15 mins
• Exercise files required are attached
  • Homes.txt

Exercise Overview

You are a Real Estate Analyst and your Manager has asked you to analyze data on Property Listings using Altair Monarch Classic: 

1. What is the total number of properties, total assessment of those properties, and the average assessment?
2. What is the average price by the ‘Style’ of property?
3. Create a Calculated Field to identify properties with an Estimated Age Greater Than or Equal to 20 years.
4. Create an Excel Export by Filter for each ‘Town’ by tab into a single workbook.
5. Create an Excel Export by Summary Key for each ‘Listed By’ Vendor by tab into a single workbook.

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.