KPI: Sponsor Metrics Dashboards

Sponsor Metrics Dashboard

Part of the IMS Key Property Insights Offering, the Property Insights Dashboard, provides views into the financial data uploaded from your accounting system.  This guide will discuss the views included within the offering, the Filters that can be applied to the portfolio, and how to navigate between the views.

Views

There are many views available allowing you to drill into your portfolio to understand what is being performed and why with an increasing level of data granularity. In any of the dashboards that contain a timeline, the user has the ability to drill up and down by hovering over the date header and selecting either + or - . This allows the fields to be aggregated monthly, quarterly, and yearly.

Example:

Screen_Shot_2019-06-27_at_10.23.47_AM.png 

Sponsor Metrics

This is the landing page. Overarching metrics about the portfolio’s financials are located at the top with bar charts of values by month labeling the minimum and maximum for each metric. Below, is the NOI Actual vs Budget and a Map view showing each property location. At the bottom of the view, is the Property Details outlining the property data by each individual property showing various metrics including NOI Variance and Variance Percentage. There are two Click to Filter options incorporated on the NOI by Property and Property Details sections, here the user has the ability to select a property and the entire dashboard will adjust to the selection.

Picture1.png

Asset One Pager

This view allows the user to see details about an individual or group of properties. The top of the view shows different metric totals with the corresponding line graphs for Actual against Budget over the date range selected. Following this are the Attributes, Debt, and Equity sections that aggregate the values where applicable. For the text fields that are unable to be aggregated, the number of selections will populate with the added ability to hover over the text to view all varieties. At the bottom of the sheet is a statement view for each month specified in the date range selected showing Actual, Budget, and Variance by each Category of Revenue, Operating Expenses, and Net Operating Income.

Picture2.png

Property Comparison

This view gives the user the flexibility to compare either two different properties against each other for the same time period or the same property against two different time periods. The top bar graphs show Actual vs Budget with the Budget as the Orange line and Actual as the Blue bar (Dark Blue is over Budget and Light Blue is under Budget). This is controlled by a drop-down menu above the legend on the top right-hand side that includes options such as EGI, OpEx, NOI, and per unit for each. Below this are the metric summaries broken out into Actual, Budget, and Variance (amount and percentage). The top graphs have a click to filter interaction ability where by clicking on a single bar (or multiple by holding the Ctrl key), that month will be filtered down to the measures below.

Picture3.png

Period Analysis

This dashboard gives the user the option to view a Month over Month or Quarter over Quarter NOI portfolio performance. This is controlled by a drop-down menu on the top right-hand corner titled Analysis Comparison. The Select Date box directly to the left allows the user to pick the date on which they want to compare against. The header values show the Monthly/Quarterly (whichever is selected) current NOI, Year to Date (YTD) NOI, and the Physical Occupancy for that period. Below each of these is an indicator that represents how the previous period compared to the current period. Following is the Period NOI Analysis bar graph that visually shows how the property performed on the current period against that of the current period Budget, prior period Actual, and current period last year Actual. Towards the bottom of the sheet is Property NOI Variance where you have the interaction ability to click to filter any of the properties. Next to each property you have the variance from the prior period as well as the prior year, and visually the variance against the Budget.

kpi_period_analysis.png

Expense Report

This dashboard gives the user the option to view a Month over Month or Quarter over Quarter Operating Expenses at the portfolio or property level. This is controlled by a drop-down menu on the top right-hand corner titled Analysis Comparison. The Select Date box directly to the left allows the user to pick the date on which they want to compare against. The header values show the Monthly/Quarterly (whichever is selected) Actual, Budget, Variance, and the percent of Budget accrued for that period. Following is the Period Comparison bar graph that visually shows how the property performed on the current period against that of the current period Budget, prior period Actual, and current period last year Actual. To the right is a Year to Date (YTD) Budget Remaining visual indicator that shows Operating Expenses accrued against the projected Budget and the percentage remaining in the center. Towards the bottom of the sheet is Expense Details where you have the interaction ability to click to filter any of the Expense Categories. Next to each category you have the Actual, Budget, Variance, and visually the Percent of Budget accrued with the ability to drill up or down by category/description to see the actual accounting descriptions.

kpi_ex_report_1.pngkpi_expense_report_2.png

Portfolio Financials

This dashboard is going to comprise of three different views to compare your portfolio financials. The first filter option Select View, allows the user to flip between the different options: P & L Table, Bar Chart, and Heat Map.

Portfolio Financials: P & L Table

This sheet allows the user to see their Property Actuals and Budget data at a more granular level. This view gives the user the ability to drill up or down by category/description. From the default view, to drill down into the Account Descriptions, hover over the Category header and click + . To drill back up into your Category hover over the Category header and click - . The values are colored red for negative and black for positive as shown in the legend.

Picture4.png

Screen_Shot_2019-06-27_at_10.24.39_AM.png

 

 

Portfolio Financials: Bar Chart

This sheet allows the user to compare all properties against each other by the different filters provided. The Measure filter lets the user select different views such as Actual, Budget, and Variance. The Metric filter lets the user select which total such as EGI, OpEx, and NOI. The bars are colored by the range of values that auto adjusts to what is currently populated as shown in the legend. The user has the additional ability to drill up into segments if this is utilized by hovering over the header and clicking - (an example is shown on the Heat Map sheet).

Screen_Shot_2019-06-27_at_10.24.50_AM.png

 

Portfolio Financials: Heat Map

This sheet allows the user to compare all properties against each other by the different filters provided. The Measure filter lets the user select different views such as Actual, Budget, and Variance. The Metric filter lets the user select which total such as EGI, OpEx, and NOI. The bars are colored by the range of values that auto adjusts to what is currently populated as shown in the legend. The user has the additional ability to drill up into segments if this is utilized by hovering over the header and clicking  - and similarly to reverse the action by clicking + .

Screen_Shot_2019-06-27_at_10.25.03_AM.png

Data Integrity

This dashboard is going to comprise of two different views that contain colorized tables to quickly identify what financial data has been received. The first filter option Data View, allows the user to flip between the different options: Actual / Budget and Rent Roll.

Actual / Budget – Rent Roll

Picture5.png

 Filters

Using drop down menus on the top of each screen (below graph for Property Comparison), you can slice and dice your portfolio in different ways. Most views contain the same filters, with slight differences.

 

Property

A multi-select drop down with the name of each property. 

property.png

Type

A multi-select drop down with the name of each property type.

type.png

Location

A multi-select drop down with the city and state location.

location.png

Segment

A multi-select drop down that can be used to indicate groups of properties in your portfolio.

segment.png

PM Firm

A multi-select drop down with the different property management firms.

pm_firm.png

Actual / Per Unit

A single-select drop down that changes the dashboard values to populate as actual or as the calculation of the actual divided by the number of units or square feet per property. The default view is actual.

actual.png

Date Range

A text box range that allows you to enter in the start and end date for the data aggregation duration. The default is set to a trailing 12 months starting at the last month.

date.png

Status

A multi-select drop down with the project status per IMS. The default view is set to Active.

status.png

Navigation

To move around the application to the different views there is a Jump to View drop down menu in the top right corner of IMS that takes you directly to each dashboard.

nav.png

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful