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 appendices.
- Choose a neighborhood on which to focus, from the list provided by your instructor.( Very Important: my assigned neighborhood is Flatlands)
- Import your data into Power BI (Desktop or Excel).
- Develop visualizations highlighting important KPI for your neighborhood, including, but not limited to, the total volume of residential sales in the last year in your neighborhood, and the growth (or reduction) of the market over the past 5 years. Use NYC TRANSACTION DATA.
- 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 last year of data in NYC TRANSACTION DATA? If your company achieves 12.5% market penetration in your neighborhood, what would its revenue be?
- Write 1-2 pages summarizing your process and findings
- Submit both the report and the Power BI file.