EIG Property Management

Data

Dataset from Vitals - Board

'data.frame':   1282 obs. of  24 variables:
 $ Unit.ID                  : int  11816 11723 11724 11725 11726 11727 11728 11729 11730 11731 ...
 $ Property.Name            : chr  "5th 1022" "Broadway 2407" "Broadway 2407" "Broadway 2407" ...
 $ Unit                     : chr  "0" "1" "2" "3" ...
 $ BR.BA                    : chr  "3 Bed/2 Bath" "1 Bed/1 Bath" "1 Bed/1 Bath" "1 Bed/1 Bath" ...
 $ Property.Unit            : chr  "5th 1022-0" "Broadway 2407-1" "Broadway 2407-2" "Broadway 2407-3" ...
 $ PM                       : chr  "LAS" "RMW" "RMW" "RMW" ...
 $ Resident                 : chr  "LEAH RADDOHL, KARLYE MUSICK, MARGARET SCHAUFF" "Jerry Brown" "ZAKKARY AUGUSTINE" "Rabin Osborne" ...
 $ Days.Since.Move.In       : chr  "27" "2,456" "461" "2,721" ...
 $ Lease.End.Date           : chr  "4/22/24" "8/21/23" "4/30/23" "7/24/23" ...
 $ Days.Until.Lease.End     : int  361 116 3 88 403 361 NA 88 NA 368 ...
 $ Balance                  : chr  "$34" "$165" "$0" "$718" ...
 $ Delinquency.Status       : chr  "" "4 - Needs Follow-up" "" "2 - PM Approved PP" ...
 $ Vacancy.Severity         : int  0 0 3 0 0 0 -2 0 4 0 ...
 $ Unit.Comparison.Factor   : chr  "100%" "100%" "100%" "100%" ...
 $ Rent..Target.Listing.Rate: chr  "$2,175" "$850" "$850" "$850" ...
 $ Rent..Current.Base.Rate  : chr  "$2,175" "$850" "$800" "$850" ...
 $ Rent..Renewal.Rate       : chr  "$2,175" "$875" "$850" "$850" ...
 $ Renewal.Status           : chr  "Tenant moving out" "Updated in Buildium" "Tenant moving out" "Renewal Offer Ready" ...
 $ Radar                    : chr  "OFF" "OFF" "ON" "OFF" ...
 $ Rent.Amt                 : chr  "" "" "850" "" ...
 $ Maint.Progress.Status    : chr  "" "" "Prioritized" "" ...
 $ Applicant.Status         : chr  "" "" "" "" ...
 $ Physical.Move.in.Status  : chr  "" "" "" "" ...
 $ Move.in.Date             : chr  "" "" "" "" ...

Delinquency by Property

Vacancy Severity of Properties

Balance VS Property

Full Balance Pending by Property

Tenant VS Move In Days

Tenant with most days at EIG

Vacancy VS Property

Vacancy Severity by Property

Rent Mean

Lolipop chart showing the rent’s mean of each property arranged

Avaerage Balance by PM

Average Balance of each property by Property Manager

Renewal

Renewal Status by number of bedrooms

Linear Model

Linear Regression applied to Rent Listing VS Rent Renewal Rate

Linear Model W

Linear Regression applied to Rent Listing VS Rent Renewal Rate

Model by Property

Linear Regression applied to Rent Listing VS Rent Renewal Rate by Property

Mapping MN

Mapping Minnesota Map