Challenge: 

Data from the property management software was difficult to extract and reporting was done for 10 years manually to consolidate metrics for weekly and monthly financial, sales and operations reporting.

Using a connection from Yardi Data Connect, a daily refresh was established to extra raw semantic data from Yardi. The data then was pulled into PowerBI Fabric and then various dashboards were custom built for leasing, operations, finance and management team.

Outcome

Major time were saved weekly and monthly manual reporting that used to be done on Excel. As well, with much more real time data (reporting going from weekly to daily), management team has a much finer control to make adjustments to strategies. With the added data, much better analytics and predictions can be done as well.