Data Browser
The Data Browser is an interactive tool that allows business customers to visualize and explore their energy use trends and costs, and make comparisons to useful benchmarks such as local weather patterns. One or more views for Energy Costs, Energy Use, and Power are available. If applicable, business customers can also use menus to switch between multiple accounts or service points.
On this page:
Requirements
Utility Requirements
Same as listed in the product-wide requirements.
Customer Requirements
|
Category |
Description |
|---|---|
|
Billing Frequency |
Monthly, bi-monthly, and quarterly. |
|
Data Delivery Frequency |
Monthly, bi-monthly, and quarterly. |
|
Data Requirements |
Billing Data: Customers must have a minimum of one historical bill to view data in the Year view. Weather Data: Weather data is required for the weather line graph to display. AMI Data: A minimum of one historical bill with at least one day of historical AMI data is required to view daily or subdaily energy use and insights. Rates Data: The Rates Engagement cloud service must be purchased and rates must be modeled in order for cost insights to display in certain parts of the Energy Costs View. |
|
Data History |
A minimum of one historical bill is required for data to display in the Year view. For AMI customers, a minimum of one historical bill which includes at least one day of historical AMI data is required for the Bill view and Day view. |
|
Data Coverage |
Not applicable. By default, all graphs and views of the Data Browser display any data that is available, even if some reads are missing. |
|
Supported Fuels |
Electricity, gas, and dual fuel. Businesses with two fuels can switch between electricity and natural gas views. A combined view, which combines electricity and natural gas use, can also be enabled. |
Limitations
- Taxes and Fees Limitation: The amounts shown for energy use typically do not include taxes or fees, so they will not match the customer's bill. However, with additional setup and configuration, the costs can be made to match a customer's bill. Contact your Delivery Team for more information.
- Solar or Multi-Register Data: Utilities must be on the latest data transfer specifications in order for enhanced solar data to display in the Energy Use view for business customers with multi-register data. Your Delivery Team will work with you to identify which data transfer specifications you need to follow.
- Responsive Display: Daily energy use can be displayed in 15 or 30-minute intervals for all business customers with sub-hourly read data. When viewed on smaller screens such as for mobile devices, the responsive design displays hourly intervals to account for reduced screen space.
User Experience
The Data Browser is an interactive visualization tool that allows business customers to analyze their energy use trends by fuel type, time period, and a series of other views. Customers can hover over or select a data point in the Data Browser to see a tooltip containing more information about it.
The major views available for businesses are:
- Energy Costs View: The cost of energy usage over time, alongside factors such as a weather and solar power (if applicable).
- Energy Use View: The amount of energy usage over time, alongside factors such as a weather and solar power (if applicable).
- Power View: The demand (or rate) of energy consumption over time, alongside factors such as reactive power, apparent power, power factor, and weather (if applicable).
Depending on what data is available, each of these views presents different kinds of trends and insights at varying levels of granularity over time. The levels of granularity available are:
- Year view: Energy cost or usage by each bill period in a year. Monthly, bi-monthly, and quarterly bills are supported.
- Bill view: Energy cost or usage by each day in a bill period, as well as the day with the highest demand.
- Day view: Energy cost, usage, or power data (such as demand, reactive power, power factor, and more) by each hour of a day, as well as the interval with the highest demand.
For more information on how the feature behaves and displays data, see General Display Rules below. Some insights may not be available depending on data availability and the customer's fuel type.
General Display Rules
The Data Browser follows some general rules regarding when and how to display data. These rules vary depending on the view.
Year View
Rules for the Year view include:
- For all major views (Energy Costs, Energy Use, and so on), the Year view will always display any available data, even if some data is missing. For example, if 12 out of 13 months are missing data, the Data Browser will still show data for the one month that is available.
- Energy use and cost data for a bill must be sent to Oracle Utilities Opower for the same billing period. For example, if a business has quarterly bills, the utility cannot send monthly energy use data, and then later send the total cost of the customer's bill at the end of the quarter. Both the total usage and cost of the quarter must be sent together in order for it to display it in the Year view of the Data Browser.
- Data points are always shown for a full year plus one additional data point. This means that there are 13 data points for monthly billing, 7 data points for bi-monthly billing, and 5 data points for quarterly billing.
Bill View
Daily AMI data is required to display the Bill view. In general, the Bill view will display any available data, even if some data is missing. For example, if only 4 days of data are available, the Data Browser will still show data for those 4 days.
Day View
Subdaily AMI data is required to display the Day view. Data reads are shown by hour or by whatever time interval matches the business customer's AMI meter. The supported intervals are 60-minute, 30-minute, and 15-minute.
For the Energy Costs and Energy Use graphs, the Day view will always display any available data, even if some data is missing. For example, if only 5 hours of data is available, data for those 5 hours will be shown. Since 24 hours in a day can be assumed, missing data is shown as gaps in the graph.
High and low temperatures are not displayed in the tooltips for the Day view. However, average hourly temperature data will be displayed if it is available.
X-Y Axis
The Data Browser displays data in the form of lines, bars, and data points along an X-Y axis. Customers can hover over a given data point for more information and see a tooltip containing standard details such as a date range, energy use amount, and other information depending on the view selected.
X-Axis
The labels on the X-axis of the graph represent an interval of time (months, days, or hours).
|
View |
Display Rules |
|---|---|
|
Year view |
The abbreviated month and final day for each bill is displayed. For example, if a business customer is billed monthly on the 20th of every month, the label for September is Sep 20. This ensures that if more than one bill ends in a given month, each bill can be distinguished by the day information. Labels appear across the X-axis for every bill. Labels are hidden in a manner to ensure that labels do not overlap for reduced screen sizes. For example, labels can be displayed for every other bill when a browser window is reduced. |
| Bill view |
The abbreviated day of the week and numeric day for each daily read is displayed. Labels appear across the X-axis for every other day. Labels are hidden in a manner to ensure that labels do not overlap for reduced screen sizes. For example, labels can be displayed for every third bill when viewing area is reduced due to viewing the graph on a mobile device. |
| Day view |
Time of day intervals are displayed, such as 12am, 6am, 12pm, and so on. Labels appear across the X-axis for every six hours. Labels are hidden in a manner to ensure that labels do not overlap for reduced screen sizes. For example, labels can be displayed for every twelfth hour when viewing area is reduced due to viewing the graph on a mobile device. |
Y-Axis
The labels on the Y-axis of the graph represent an applicable unit of consumption, cost, or power (such as demand, reactive power, or power factor). The axis begins at 0 and displays increments up until an applicable maximum value that ensures all data can be shown.
Estimated Bills and Usage Reads
Utilities are sometimes unable to obtain billing reads or AMI usage reads for their customers, in which case such reads may be estimated.
Estimated Bills: An estimated bill is an approximate monetary amount that is calculated based on the energy that a customer has consumed in the past, rather than the energy that the customer has consumed in the present billing period. Estimated billing reads are marked in the data file sent by the utility to Oracle Utilities Opower.
Estimated AMI Reads: An estimated AMI read (that is, granular usage reads such as daily or subdaily reads) is an approximate usage amount that is calculated based on the energy that a customer that has consumed in the past rather than in the present billing period. Estimated AMI reads are marked in the data file sent by the utility to Oracle Utilities Opower.
In the Data Browser, estimated bills are indicated by a tooltip message that displays when the customer hovers over an applicable data point. This message will appear if any read shown in the Data Browser was estimated.
Note: Estimated bills and AMI reads are flagged separately in the data files sent by the utility to Oracle Utilities Opower. If a utility has not marked that a billing read was estimated, then no indication of an estimated bill will be displayed for any of the bill periods shown in the Year view of the Data Browser—even if one of the billing periods contains one or more daily estimated AMI reads.
Virtual Bills
A virtual bill shows a business customer's daily energy use and energy costs up to the present day in the Data Browser, even though the bill period is not finished yet. This is accomplished by determining the maximum number of days to display along the horizontal axis in the Bill view. This feature requires daily AMI data.
A virtual bill is useful because it assumes an end date for an in-progress bill, and it therefore allows daily usage data to be displayed in the Data Browser before the bill period is finished. Because of virtual bills, customers can go to the Bill view and navigate past their most recent bill period to see their daily usage data up to the present day.
Energy Tooltips
A tooltip is displayed when a customer interacts with a data point in the Data Browser. At minimum, the tooltip includes the time period covered and the amount of energy used by the customer. Other elements of a tooltip vary depending on which view of the Data Browser is selected and what data is available.
Time Period: The time period for the selected data point. For example, a tooltip for a day data point displays the month and day.
Energy Cost: The cost of energy for the selected fuel type and time period. Energy costs are shown on tooltips for the Energy Costs view. Hyphens are displayed for any data that is missing. The cost amounts typically do not include taxes and fees, and so do not match a customer's bill. However, with additional setup and configuration, the costs can be made to match a customer's bill. Contact your Delivery Team if you have any questions about this configuration.
Energy Use: The energy used for the selected fuel type (kWh, therms, and so on) and time period. Hyphens are displayed for any data that is missing.
Weather: The average temperature for the selected time period. Weather data is available in the Energy Costs and Energy Use views. High and low temperatures are also provided when using the Year view or Bill view.
Click Bar to View Each Day or Hour: For customers with AMI data, a message is displayed in tooltips in the year view and bill view, directing customers to more granular data. This message allows customers to quickly view data for the days in a bill period or the hours in a day.
Estimated Bills: Estimated bills are listed as estimates in a tooltip. See Estimated Bills and Usage above for details.
Solar Data
The Data Browser supports solar data by displaying a customer's net energy usage in a given interval of time on the horizontal axis. (This may also be referred to as net energy metering, or NEM.) See the Energy Costs view and Energy Use view for details.
Weather Data
Any weather data displayed in the feature is based on the geolocation (latitude and longitude coordinates) of the business customer. A weather service is used to select the closest weather station with weather data for the customer. This usually corresponds to the nearest airport station, usually within ~40 kilometers from the customer. Daily average temperatures are based on hourly temperatures.
Multiple Accounts
The multiple accounts experience varies depending on whether the feature has been configured for a standalone implementation or an embedded implementation.
In a standalone implementation, the Data Browser shows a drop-down list that allows business customers to choose which account to view. The addresses in the list represent the available accounts.
In an embedded widget implementation, the account drop-down is hidden since the utility site is expected to have its own account selection tools. In this case, business customers can switch between their accounts by logging into their utility account using single sign-on, and then clicking an account selector hosted on the utility website. All embedded widgets are then reloaded with data for the specified account.
Multiple Service Points
An account can include one or more service points. In such cases, the Data Browser displays a menu listing multiple accounts and service points for the business customer to choose from. Customers can select a service point from the menu, but not the premise itself.
Customer Feedback
A customer feedback module can be displayed at the bottom of the Data Browser. See Customer Feedback for more information.