MET AD 571 Assignment 1
Data
7 points
Assignment 1 Objective: Prepare a managerial report, starting with an executive summary; expected length up to 1-2 pages APA format, excluding cover page, table of content, and appendixes.
1. Import your data into Power BI (Desktop or Excel) via BU Server or Provided CSV Files
2. Using your assigned neighborhood to visualize and explore the following angles for residential properties:
o How the overall market behaves over the past 5 years
o How the Borough in which your neighborhood exists behaves over the past 5 years
o How your neighborhood behaves over the past 5 years
o The top selling property types
o Proportion of properties are residential versus commercial
o The trend in sales
o The trend in transactions
o The trend in price per square foot
o The proportion of sales by Year Built
3. Develop visualizations highlighting the percentage growth (or reduction) of the market as compared with your neighborhood over the past 5 years.
4. If real estate companies, on average, earn a commission of 5 cents per dollar on residential sales, what is the total revenue earned in your neighborhood over the latest year in the data? If your company achieves 12.5% market penetration in your neighborhood, what would its revenue be overall and on an annual basis?
5. Write 1-2 pages summarizing your findings. For example: Discuss the findings related to the overall market as it compares to your neighborhood. Discuss whether there is a risk or an opportunity in your neighborhood based on the trajectory of sales. Assess whether there is an interesting opportunity upon initial analysis or a big risk with your neighborhood.