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 select Hub BI and Billing KPIs.

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

Billing KPI BI V2

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 select 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 BI V2

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 select 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 Summary BI V2
 

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 select 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 KPI BI V2
 

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 

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. 

Consumption KPI BI V2

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.  

RAG Seasonal BI V2