ArzMex Houses

0. Introduction

ArzMex Houses have a bussiness model is purchasing & reselling properties located on Arizona at USA on digital app similar with House Rocket Idea. The request is a complete dashboard of portfolios the dashboard contains some filters like zipcode, price, and contains maps with distribuition of the portfolios, with some characteristics for better decisions.

1. Bussines Problem

One of Manangers with CEO requested several filters to be able to see how the company is doing!

Filter data with Zipcode.

Filter data columns.

Descriptive Statistical:

- Total of Houses.

- Mean of price.

- Mean of sqft living.

- Mean of m2.

- Price p/ m2.

Map with all Houses.

Map with price density.

Check annual and daily variation.

House Distribution per:

- Per Price.

- Number of Bedrooms.

- Number of Bathrooms

2. Process Insight's

Some insight's to CEO during the EDA and Data Clearing.

1. Zipcode with suspicious errors need to checkout the Lat long to Engineering Team.
2. Houses price density concentrate at Phonex Region.

3. CEO Geral Process

1. Filter data with Zipcodes
• Table with all CEO filtred zipcodes.
2. Filter data columns.
• Table with all selected attributes.
3. Descriptive Statistical.
• Table with statistic metrics.
4. CEO request Maps.
• Folium map with zipcodes.
5. Annual and Daily price changes.
• Line plot with Annual Price.
• Line plot with Daily Prices.
6. House filtred attributes.
• Histogram with all CEO request attributes.