Demand Heat Map

The Demand Heatmap displays demand data in a color-coded grid, and indicates the level of energy demand during specific times, days, and weeks of the year. This allows customers to see when they draw the most energy from the grid, to identify any anomalies, and to consider if and how to lower their demand during those times in the future. The widget is available for residential customers on a demand rate.

Demand refers to the rate at which electricity is consumed, not the actual amount of electricity consumed. Demand data is expressed in kilowatts (kW) rather than kilowatt-hours (kWh).

Requirements

Utility Requirements

Same as listed in the product-wide requirements. Additionally, to enable the display of this feature for customers who are on a demand rate, utilities must purchase the Oracle Utilities Opower Advanced Rates Engagement Cloud Service.

Customer Requirements

Category Description
Billing Frequency Monthly, bi-monthly, and quarterly.
Data Delivery Frequency Daily.
Data Requirements

Usage Period Data: Usage period data from the Oracle Utilities Opower Billing Data Transfer specification is required. Specifically, the usage_period_start_datetime and usage_period_end_datetime fields in the Bill Segment data entity are required.

Interval Data: Subdaily electric interval data in kWh is required. Data can be sent in whichever subdaily resolution is available. For information on providing interval data, see the Oracle Utilities Opower Interval Data Transfer specification.

Premise Data: Premise data is required. See the Oracle Utilities Opower Premise Data Transfer specification for more information.

Demand Rate Metadata: Demand rate metadata must be provided to identify customers as being on a demand rate. Your Oracle Utilities Delivery Team will work with you to collect this information as part of the Advanced Rates Engagement cloud service rates modeling process.

Data History A minimum of one historical bill and one day of AMI data.
Data Coverage Not applicable. By default, the heatmap displays any data that is available, even if some reads are missing.
Supported Fuels Electricity. Demand data for gas cannot be shown.

Limitations

Calculated Demand Data: The feature does not support demand rates data from a utility. Demand data is calculated based on interval data provided by the utility in kWhs, and is then displayed in kWs.

User Experience

This section describes the user experience of the Demand Heatmap for customers who are on a demand rate with their utility and who have electric interval AMI data. The image below is an example of the Demand Heatmap for a specific bill period.

Screenshot of color-coded heatmap showing dates and times of demand usage patterns for residential customers.

Service Point Selector: A service point selector menu may display above the heatmap for premises that have multiple service points of the same fuel type at a premise. If a customer has added custom meter names, each name is displayed with its service point identifier to help distinguish the available service points.

Date and Time Menu: The date and time menu allows customers to select the bill period for which to view demand data. The menu is limited to displaying options for the last 12-13 months.

Depending on the billing cycle, the menu shows different date ranges for different bill periods. For example, a customer on a monthly billing cycle would see menu options with month-long date ranges, while a customer on a bi-monthly billing cycle would see menu options with bi-monthly date ranges.

Demand Grid: The demand data is shown in a color-coded grid view. By default, a single color gradient is used so that the colors are more accessible to colorblind customers.

  • X-Y Axis: The y-axis represents the days and weeks of the selected time period. The x-axis represents the time of the day, broken down into 24 hours.
  • Panels: The panels in the grid represent different time intervals (such as one hour) depending on the resolution of the customer's data. Each panel in the grid is color-coded to indicate how much energy was in demand at that point in time.
  • Rows: The number of rows in the demand grid varies depending on the customer's billing cycle. For example, a customer with monthly billing would see a grid containing data for about four weeks, while a customer with bi-monthly or quarterly billing would see a grid containing data for additional weeks.
  • Highest Demand Interval: An icon is displayed in the panel when demand was at its peak. Demand refers to the rate at which electricity is consumed, not the actual amount that is consumed. This means that the interval with the peak demand icon may not always be the same as the interval with the highest amount of energy use.

Note:

Any data that is available will be displayed. If some reads are missing (for example, if a customer's meter malfunctioned or was unable to send data reads to the utility for some reason), the corresponding panels in the grid will appear empty.

Tooltips: A tooltip is displayed when a customer interacts with a data point in the Demand Heatmap. The tooltip includes the following elements.

  • Time Period: The time period for the selected data point or panel in the grid, including the month, day, year, and time interval.
  • Energy Demand: The energy demand for the selected time period, expressed in kilowatts (kWs).

Legend: Below the demand grid is a legend displayed in the form of a color-coded scale. The color on the left side indicates the low end of demand (usually 0 kWs), and then gradually changes as the scale moves to the right where the high end of demand is indicated.

The scale is dynamic and ends at whatever is the highest demand for the selected time period. For example, if the highest demand during the selected time period was 4 kWs, then the right side of the scale would indicate 4 kWs. This number may change when the customer selects a different time period.

When a customer interacts with the Demand Heatmap and selects (or hovers over) a panel in the grid, an upside-down triangle icon appears above the scale at the appropriate point that corresponds with the demand represented by the selected panel.

User Experience Variations

AMI Data Unavailable

If the customer does not have AMI data, then an error message displays stating that the information in the widget can only be displayed if smart meter data is available.

Heatmap Color Gradient

The Demand Heatmap gradient may use different colors to represent the demand data. The colors may range from green colors (for low demand) to red colors (for high demand), or custom colors that are specific to your utility.