What is Power BI?

What is Power BI?

Power BI is a data visualization product offered by Microsoft.  It can be used for presenting financial and other key metrics of your properties to your investors, executives and property managers. I have built Power BI dashboards for property management clients with...

Consolidated Financial Reporting With Excel

Consolidated Financial Reporting With Excel

You plan to acquire another property management company. How will you do consolidated financial reporting for the combined companies? Here I describe the process being used at many parent property investment companies for creating consolidated financial statements. I...

Visual Data Analysis

Visual Data Analysis

You property management software has a ton of pre-built reports, and almost all of them consist of rows and columns. Most of us are used to these reports, and since this is all we get, we accept them. What if you had the option to do visual data analysis of your...

Six Sigma in Property Management

Six Sigma in Property Management

Six sigma can help property management executives improve profits, employee morale and tenant satisfaction. Six sigma is a set of methods designed to improve processes. It has been successfully used at companies like Motorola, GE and Honeywell, but it is not useful...