Asset Management Studio

The Asset Management Studio has been created for  people at real estate companies who spend a lot of time in Excel analyzing data. They have titles such as Asset Management Analyst, Acquisitions Analyst, Operations Analyst etc.

They are good at Excel but find some of the work they do in Excel is repetitive and not a good use of their talents.

The Asset Management Studio greatly increases the productivity and impact of these people.

SQL knowledge is not required. Our data engineers can create custom SQL queries if you need them. If you find yourself having to add extra columns to your data sets, it might be better to add the additional columns to the data model in the SQL database.

AI models need to be fed with good, clean data. Where else in your company do you have the data aggregated, cleansed and ready for analysis? We have leveraged AI to for these use cases:

• Automating “Month-End Close”: sifting through the GL transactions and flagging duplicate payments, missing payments, outlier transactions etc.
• For real estate acquisitions, automating the process of sifting through offering memorandums and identifying the interesting ones
• Analyzing P&L data and generating investor letters and board presentations

Do you have an AI use case in mind?

Yes, we can customize the catalog dashboards. Use the catalog for ideas. We can also build a completely custom dashboard for you.

Examples of data packs (also called data models) are the rent roll, the A/R aging report, the P&L and so on. Typically, data models are based on the reports you run in your property management system. A data model starts as a report or data collection that can be exported from your property management system. If your system has an API, then a data model would be built from the API “endpoint”.

A data model has additional columns that might not come directly from the report or API endpoint. If you find yourself exporting a report, and then writing formulas to add more columns, think of the data model as the end result of that effort.

It’s up to you. Most of our customers build their own dashboards. People who were previously creating pivot tables and Excel charts are now creating and publishing dashboards they built using Power BI and Tableau.

The guidance for migrating from Excel reporting to Power BI or Tableau is included in our service offering..

If you want us to build you a custom dashboard …. Our process is described here.

The monthly fee includes:

• The data infrastructure, hosting of your database, and refreshing your data (daily, weekly, monthly),
• Administering the environment and troubleshooting any outages,
• Tech Support (email, phone or video meeting),
• Weekly “Office Hours” to support your analysts as they work on their data projects.

General Ledger and Trial Balances are available only in the Enterprise plan.

Additionally, some of our customers ask us to load their pro formas (which are usually in Excel files). Other customers have compiled market rent data and have us to load these into the Data Warehouse. We can load such data into the Data Warehouse. These services are available only in the Enterprise plan.

One big reason companies use RentViewer is to have a “single source of truth” and not have many different spreadsheets lying around. When you are pulling data from the data warehouse into Excel, you typically want only the required columns to come into Excel, and not have to do any joins manually in Excel.

For example, you want to look at the A/R Aging data (30, 60, 90 day balance) for each tenant along with Total Charged and Total Paid columns. Since these columns originate in different data packs (A/R Aging and Rent Roll), we can create a custom query for you. You will be able to pull the result of this query into your Excel model without having to create VLOOKUPs. Such work typically involves writing SQL code at our end.