Business Intelligence Dashboards

The Business Intelligence dashboards offer interactive data visualisations, for simple analysis of often complex and vast data sets. These are sophisticated business intelligence dashboards that allow users to look at key performance indicators in an interactive graphical form. The power is in the ability to slice and filter the data to present exactly what you want, in just a few clicks.

There really are no limitations as to what data can be presented within the dashboards, so our product will be constantly evolving to show you your energy data in this simple and intuitive way.

Note. Based on your current product subscription, you may see a number of the below dashboards. If you see something of interest that is not part of your current subscription, please speak to your account manager.


Row Level Security 

The Energy.Hub's advanced business intelligence tools have been updated with Row Level Security, opening up access to users with specific group allocations.  In short, once you have a group of sites assigned to a user, you can grant them access to the advanced business intelligence dashboards, where they will only see their portfolio data. 
This is really great for those customers serving their customers through the Energy.Hub, providing more powerful data insights.

 


Billing KPI

The Billing KPI dashboard provides useful information for the Billing Manager, Finance Manager and Procurement Specialists. Below is a screen shot of the current version within the Energy. Hub which can be found by navigating to Home in the main menu and then selecting Overview, Hub BI and Billing KPIs.

Just as displayed in Excel, there are two different worksheets contained within the report; Bill Details and KPI's

BIllin KPI - BI Dashboard

 

Here you can view the data, and can compare and filter using the below parameters:
 
  • ​Invoice Date Range
  • Commodity
  • Group Name
  • Payment Status
  • Supplier Name
For business users, the dashboard answers the following questions:
 
  • What is the total number of invoices for my filter criteria?
  • What is the total consumption in kWh?
  • What is the Average PPU?
  • What is the Total Amount of money billed?
  • What is the Net Amount by Grouping and Group?
  • What is the Net Amount by Invoice Date and Payment Status?
  • The summary information for the individual invoices in the bills.

 

Invoice Summary 

Like the Billing KPI dashboard, the Invoice Summary dashboard is another useful tool for the Billing Manager, Finance Manager and Procurement Specialists. Below is a screen shot of the current version within the Energy.Hub which can be found by navigating to Home in the main menu and then selecting Overview, Hub BI and Invoice Summary.

Just as displayed in Excel, there are two worksheets contained within the report, these are Invoice Items (Summary) and Invoice Items (Visuals)

 

Invoice Summary - Hub BI


Here you can view the data, and can compare and filter using the below parameters: 
 
  • Invoice data range
  • Group
  • Commodity
  • Grouping - Type of charging e.g. Energy, Renewable Energy, DUoS
  • Charge Description - The actual item of charging 
For the business users, it answers the following questions:
 
  • What is the Net Amount by Group?
  • What is the Net Amount by Commodity?
  • What is the Net Amount by Supplier?
  • What is the Net Amount and Consumption by Group, Month and Payment Status?


Consumption Analysis 

The Consumption Analysis dashboard provides useful information for Energy Managers and Data Analysts. It is also interesting for end users who want to gain a better understanding of their consumption profiles at their own sites. Below is a screen shot of the current version within the Energy.Hub which can be found by navigating to Home in the main menu and then selecting Overview, Hub BI and Consumption Analysis.

Just as displayed in Excel, there are four worksheets contained within the report, these are Invoice Items (Summary) and Invoice Items (Visuals)

Consumption Analysis - Hub BI

Here you can view the data, and can compare and filter 
using the below parameters: 

  • Invoice Date range
  • Commodity
  • Group
  • Site
  • Site Code 
  • Site Classification 
For the business users, it answers the following questions:
 
  • What is the Net Consumption of your Portfolio?
  • What is the Net Amount by Group?
  • What is the Net Amount by Site/Site Classification?
  • Which sites are performing well/poorly inclusive of Group and Classification?
  • What is the Vacant Energy usage?
You can analyse historical emissions data and consumption data across your sites and compare how they are doing. 

Budget Analysis 


The Budget Analysis dashboard provides useful information for Energy Managers and Finance Managers providing insights on the performance of their portfolio against set budgets. Below is a screen shot of the current version within the Energy.Hub which can be found by navigating to Home in the main menu and then selecting Overview, Hub BI and Budget Analysis.

Just as displayed in Excel, there are two worksheets contained within the report, these are Budget (Key KPI's) and Budget (Details)

Budget Analysis - Hub BI

Here you can view the data, and can compare and filter using the below parameters: 

  • Invoice Date range
  • Commodity
  • Group
  • Supplier
  • Site
  • Budget 
For the business users, it answers the following questions:
 
  • What is the Planned and Actual consumption?
  • What is the Planned and Actual cost?
  • How much Under or Over Budget are you in both Consumption and Cost?
  • Which sites are performing well/poorly inclusive of Group and Classification?
  • What is the Vacant Energy usage? 


Trade Analysis 

The Trade Analysis dashboard provides useful information for Energy Managers, Finance Managers and Procurement Specialists keeping track of current hedged and unhedged positions. Below is a screen shot of the current version within the Energy.Hub which can be found by navigating to Home in the main menu and then selecting Overview, Hub BI and Trade Analysis.

Just as displayed in Excel, there are four worksheets contained within the report; Power Position Management, Gas Position Management, Power Price Scenario Analysis and Gas Price Scenario Management. 

Trade Analysis - Hub BI

Here you can view the data, and can compare and filter using the below parameters:

  • Invoice Date range
  • Forward Curve
For the business users, it answers the following questions:
 
  • Net Value of my Hedged and Unhedged Position?
  • What is my average Hedged Price?
  • Based on my forecasted consumption volume, am I covered in-line with my procurement strategy
 

Energy Calculators 

The Energy Calculators are an ever-evolving area of interest to Energy.Hub users. The idea of the calculators is to solve complex questions posed in energy. The Energy.Hub currently contains two calculators, the Energy Flex Calculator and the HH Cost Profile Calculator.

The Energy Flex Calculator helps you understand how much money you could make if you moved to a DSR balancing type contract where you could take advantage of wholesale pricing opportunities, by turning down consumption during high wholesale price events .

The HH Cost Calculator helps you see a single site's Fully Loaded Cost Curve (including all third part charges) so you can see how much the site actually costs in each half hour. You can then use this data to help analyse a wide variety of technical solutions. For example, examining whether batteries, on-site storage or generation may work for a specific site will depend on this HH analysis.

Below are some screen shots of the current version within the Energy.Hub which can be found by navigating to Home in the main menu and then selecting Overview, Hub BI and Energy Calculators.


Just as displayed in Excel, there are four worksheets contained within the report; Power Position Management, Gas Position Management, Power Price Scenario Analysis and Gas Price Scenario Analysis

Energy Calculators - Hub BI


Consumption Benchmark KPI's 

We have made it really easy for you to track energy performance with a new Consumption Benchmark KPI Business Intelligence dashboard, with the addition of Excel reporting.  You can now compare yearly, monthly, weekly and daily consumption including carbon emissions, and track them from the BI dashboard. 

Additionally, for those customers that buy energy by season, the report also includes the breakdown into Winter, Summer, Spring, and Autumn periods. 





Red Amber Green Reports and Season KPI's 

The delivered cost of a kW can vary wildly in any single day, one key driver of this is the distribution costs.  This report gives end users control over these costs, and the first step is being able to see when you are using energy in each DUoS time band. 
We have created a new Red, Amber & Green Report (RAG), which allows Energy.Hub users to fully interrogate these costs.