Reports in Energy Intelligence are grouped into the following 'Views'. A 'View' is the main source of data used to create the Report.
The following pages will shows examples of the Reports, along with a link to take you to the Report in your Energy Intelligence.
Sigma Views
Click on each link to take you to a Directory of Reports that use the View.
...
...
...
...
Sigma Bill Consumption
...
All queries raised against bills within Sigma and associated to all Sigma Items
...
Sigma Bill Validation Results
...
The validation results for bills in Sigma and associated to all Sigma Items
...
Sigma Bills and Charges
...
The bills that have been loaded into Sigma, including individual charge lines, bill tags, batches and associated to all Sigma Items
...
5 years
...
Sigma Database Items
...
All Sigma item types available for reporting
...
5 years
...
Sigma High Frequency Periodic Data
...
High frequency data loaded from periodic channels
...
14 months
...
Sigma Metered Consumption
...
Details the monthly average and total consumption and costs for the selected Account(s). Restricted to A&R flagged Bills.
...
Attempts to calculate an estimated bill cost for an Account for a year and month period. It will use recent, historic bill data or metered consumption, depending on the “quality” of metered consumption available. It will only accrue where it there is no actual billing data for the complete month. It will calculate the accrual based on the best data available. The Accrual Type column outlines the accrual methodology that has been used.
...
Provides an overview of the total consumption and gross cost by Provider and Commodity, displaying the information in four separate charts.
...
Details the daily consumption from the current bill, the previous bill and the previous years bill, showing the percentage differences and potential savings.
Uses the Sigma Bill Consumption (primary view), Sigma Bill & Charges and Sigma Bill Consumption Views.
...
Details the CO2 and CO2e variance over a period of time by financial year for selected Site(s) or Site Group(s)
...
Provides a view of periodic data for a selected site or channel. All the charts in this report will default to the last 30 days. It will provide a heat map to show the usage for each half hour period across each day of the week. This will help highlight suspect usage. It will also provide a view of the trend for each day in the period, a breakdown of the data by each half hour period and a view of the total by day of the week.
...
Shows a list of all open data quality notifications relating to gaps, unexpected or overdue data in the context of the meter and channel to which they relate.
...
Details the overall impact for each of the Data Sources. Contains Drill Through from the Channel Data Source to the List of Quality Notifications report
...
Shows the the billing elements such as the cost of the billed units, VAT. Metered Consumption, DUoS, Capacity, BSUoS, FIT, CCL etc.
...
Determines the total number of days where bills are missing for an account and calculates an indicative cost based on the daily average bill amount for the existing bills.
An account can be selected to see which particular periods of time are missing bills.
(Drill down to Missing Bill Days for Account (Drill Through))
...
This page shows Reports that use the Bill - Queries View. The first column has a link that will open the Report in Energy Intelligence.
| Table of Contents | ||||
|---|---|---|---|---|
|
Click on the link in the table to take you directly into the Report in Energy Intelligence in your own database.
| Report | Thumbnail | Report Description | |
| Bill Queries Dashboard |
| Bill Queries DashboardProvides an overview of the open bill queries and the number closed in the last calendar month | |
| Queries - all Open Queries |
| Queries - all Open QueriesDetails queries with a status of 'Open' with a breakdown by Category and age. | |
| Site Capacity Detail (per Account) | Displays the capacity and maximum demand in each bill received within the last two years. You can use this information to get an indication as to whether the capacity may need need to be adjusted (Drill down from Capacity Review - Detailed) | ||
| Site Billed CO2 (stacked by Commodity) | Details the kg CO2 from the Accounts in selected Site(s), broken down by Commodity. The table of data includes the total consumption and gross cost. | ||
| Site Billed CO2 Emission Comparison for a Period | Details the total CO2 emissions in kg for a Site(s) compared against a figure for a previous period. Values are displayed by commodity and include the present consumption and gross cost. The Move represents the changes in CO2 for each site. Also known as League Table CO2 Emissions. | ||
| Site Billed Consumption, CO2 and Cost per Commodity | Details the total consumption for selected Site(s), broken down by Commodity. The table of data includes the kg CO2 and gross cost. | ||
| Site Billed Consumption Comparison for selected Periods (includes Cost and C02) | Details the consumption for a Site(s) compared against a figure for a previous period. Values are displayed by commodity and include the present kg CO2 and gross cost. The Move column in the results table represents the changes in Consumption for each site. Also known as League Table Any Period. | ||
| Site Billed Consumption, CO2 and Cost per m2 | Details the total consumption, CO2 and cost for a Site(s) normalised by the floor area in m2 | ||
| Site Billed Consumption, CO2 and Cost per Person | Details the total consumption, CO2 and cost for a Site(s) normalised by 'Population' | ||
| Site Cost by Commodity for the Last Financial Year | Details the gross cost (£) for selected Site(s), broken down by commodity for the last financial year. | ||
| Site Cost by Commodity (Stacked) for the last Financial Year | Details the gross cost (£) for selected Site(s), broken down by commodity for the last financial year displayed in a stacked bar chart | ||
| Hourly Usage per Day per Site for the Last Calendar Month | Shows an aggregated view of the usage in each hour period for each day of the week for the last calendar month. This allows you to see where consumption in a particular hour is not as expected when compared to other periods. | ||
| Site Monthly Billed Gas and Electricity Cost and Consumption vs. Previous Year (Drill Through) | This is a Drill Through Report. Details the billed cost and consumption for gas and electricity for 1 month compared to the same month in the previous year. | ||
| Site Performance (Year to Date) League Table Summary - 10 Worst Performing | Details the current year to date total billed electricity and gas consumption and also consumption per m2 of floor area. This report is ordered by consumption per m2 to help highlight your worst performing Sites. You can also see how the total site consumption compares to the same period in the previous year. A Site Name can be selected to drill down further and provide a view of the monthly billed costs and consumption for the site. (Drill down to Year to Date Monthly Site Cost and Consumption per Commodity) | ||
| Sites by Bill Gross Amount Map | Displays a map showing selected sites and the sum of the Bill Gross Amount for a selected month and year. The size of the circle represents the gross amount e.g. the larger the circle, the higher the bill gross amount. | ||
| Total number of Accounts for Active Sites by Commodity | Provides a count of the accounts for active sites i.e. those that do not have a Non Operational Flag or Closed Date Flag, broken down by commodity. Report refreshed monthly on 2nd of the month. | ||
| Total number of Active Sites | Provides a count of the active sites i.e. those that do not have a Non Operational Flag or Closed Date Flag. Report refreshed monthly on 2nd of the month. | ||
| Billed Cost per Commodity | Details the total billed by Commodity. | ||
| Billed Cost per Commodity for the last Calendar Month | Details the total billed by Commodity for bills with an invoice date within the last calendar month. | ||
| Total CO2 by Commodity | Details the total CO2 emissions in kg by commodity. Results are available for the following commodities where applicable: electricity, gas, water, oil and propane. | ||
| Weekly Channel Compare Report (Original) | Compares the Periodic Channel consumption for two selected weeks. The Graph shows the present and previous consumption. The table compares each consumption value (present and previous) along with the percentage move. Choosing more than one Channel will create a separate tab for each one. Only one week per date range can be selected. | ||
| Year to Date Billed Energy Overview | Provides a year to date overview of billed electricity, gas and water cost and consumption for the current year, alongside the same period in the previous year, with the applicable percentage change and trend. Also, a summary of all billed costs and all emissions for the current year are displayed. | ||
| Year to Date Monthly Site Billed Cost and Consumption per Commodity (Drill Through) | This is a Drill Through Report from Site Performance League Table Summary (10 Worst Performing) Displays the monthly billed cost and consumption for electricity and gas for the current year to date. A month can be selected to show the billed cost and consumption for that month and how it compares to the same month in the previous year. | ||
| Yearly Consumption Trends (using best available data) | Displays the total consumption usage across all commodities for each year.Queries - Closed in the last Calendar Month |
| Queries - Closed in the last Calendar MonthDetails queries with a status of 'Closed' that have been closed in the last calendar month. |
