Sigma Online User Manual

Recorded Training Sessions

These training sessions were recorded live during 2020 - 2023.

Click on a link in the grids to open the recording.

The recordings are in the following categories:


General


Back to Basics

recorded July 2022

  • Help on:
    • Welcome Screen, Searching Options, Items
    • Activity Launcher, Moving between Activities
    • Estate Management and Refreshing Data


Checking the Quality of your Sigma Database  

recorded September 2021 

  • Best practice and reports to identify issues
  • How to rectify identified issues
  • Reports to identify gaps / accuracy of data

Energy Viewer

recorded July 2020

  • How to set up Users and using the Energy Viewer

Hints, Tips and Shortcuts for Sigma

recorded September 2020

  • How to refresh data and expand the screen
  • Searching tips and hints and tips for Sigma

Managing your Estate

recorded May 2020

    • How to view all Supply Points, Accounts, Meters etc
    • How to edit/create new Items, change/manage Contracts and manage/add Associated Data (such as Floor Area) 


Recording your data for Energy Compliance

recorded September 2020

  • Understand what details can be recorded and how to record data such as DECs and EPCs




Billing


Bill Entry

recorded September 2020

  • How to amend the Bill Entry View
  • Specific Validation for manual bills 
  • Moving between Bill Entry/EDI Batch Management/Estate Management

EDI Automation

recorded May 2020

  • How to set up EDI Automation, viewing the automatic schedule and email notifications

Energy Bill Relief Scheme 

recorded November 2022

Introduction & Background

  • What is EBRS?
  • Eligibility
  • How Discounts are Calculated
  • Examples
  • How will it appear in Sigma?
  • Future Changes - BSUoS Review
  • Live Demonstration - View the EBRS charges in Sigma and New Energy Intelligence Report


Failed Bills and Managing Queries *NEW*

recorded April 23

Hints and Tips on EDI Batch Management

  • Investigation techniques for Warning or Failed Bills
    • Right click options to investigate
  • Creating a Query that can be dealt with later
    • Differences between adding a Query for a Warning and a Failed Bill

Query Management

  • View a Query from the Data Selector, Estate Management and Query Management
  • Understand the Query Management Activity
  • Customising the layout of the Activity
  • Creating Notes for Actions on an outstanding Query
  • Resolving Queries
  • Understand the Filtering options
  • Export the list of Queries
  • Adding to the dropdown lists (using the Data Object Setup Activity)

Query Management

recorded June 2020

  • Understand what a Query is, how to identify existing queries and how to create new ones
  • How to manage Queries
  • How to filter the Activity and report on Queries

Setting up Validation

recorded May 2020 

  • Understand the EDI pre-set Validators
  • Understand your own EDI Validators
  • How to set up new Validators and understand the failed validation

Targeted Charging Review - Changes in Billing and Sigma 

recorded April 2022

Targeted Charging Review 

  • What is TCR? 
  • Distribution Charges and Changes 

Sigma 

  • Example Bill in Sigma 
  • Validating DUoS Charges 
  • How to configure and apply new Validation

TCR Charges Validation follow up 

recorded September 2022

  • Setting the TCR Validators to Info only 
  • Setting other Validators to Info only 
  • How Info only Validation shows in EDI Billing 
  • How info only Validation shows in Manual Billing 
  • Running reports in Energy Intelligence to show the details of the failed Validators 

Updating Flexible Procurement PPU Charges 

recorded October 2022

  • Overview of Associated Data Channels  
  • How to add Associated Data Channels individually and in bulk 
  • How to update Associated Data Channels with new prices individually and in bulk 
  • How to view the current prices held in Associated Data Channels 
  • How to set up the relevant Validators 
    • Example of Bills with Passed / Failed Validation 
  • Available Help 


Using the Accounting System Interface for Billing Data transfer (Accounts Link)

recorded August 2020

  • Understand the functions of the Activities
  • Understand the options available when creating a file
  • How to create a file and view/extract the file

Understanding  Validation Issues

recorded June 2021

  • How to view the Query/failed validation
  • Understand and investigate the Validation message and create a query
  • View 10 example Validators and how to view/amend existing Validators



Metering 


Automating the input of all Consumption Data types  

recorded March 2022

  • Understand what can be automated, what is required and how to set up a schedule for:
    • HH data
    • Manual Meter Readings
    • Consumption Data
  • Understand the benefits of automating the input of data
  • How to manage/amend/stop the schedule(s)


Entering Manual Meter Readings

recorded July 2020

  • How to input manual meter readings in bulk and via the Energy Viewer
  • How to export Meter Readings and run the Self Read Values Report
  • How to validate the billed consumption Vs meter readings

Identifying Data Gaps using the Data Monitoring Activity

recorded May 2020

  • Overview of the Data Monitoring Activity
  • How to set up a Data Gap Strategy, how to view the gaps manually or automatically

Identifying excessive HH consumption, using Data Monitoring 

recorded June 2022

  • Overview of Data Monitoring Activity
  • Online Demonstration
    • How to set up HH Exception Monitoring
    • How to set up email Notifications
    • How to work through Notifications
    • Overview of other available HH Strategies
    • Reporting on Data Monitoring

Importing AMR Data

recorded June 2020

  • How to check the Periodic Channel is set up correctly
  • How import the Data manually or automatically
  • How to check and monitor the data

Monitoring & Validating HH Data- Identifying Zero Consumption  *NEW*

recorded May 2023

  • How to create a Monitoring Strategy to check for zero consumption in any hour in a day
  • View and work through the Strategy Notifications
  • Overview of other available Strategies
  • How to check/amend existing Strategies
  • View available Monitoring Reports

Monitoring Trends in HH Data

recorded August 2020

  • Explanation of the Fixed and Dynamic Profile Strategies 
  • How to set up, create email notifications
  • How to investigate, add notes and close Notifications




Reporting


Accrual Reporting

recorded August 2020

  • How to use the Sigma Accruals Master Report and the EI Accruals Report

Budgeting

recorded June 2020 

  • Determining your Budget Figures
  • How to create a Budget Group 
    • How to add Accounts, Meters or Monitoring Points to the Budget Group
    • How to add Target figures (if required)
  • How to view/manage the Budget once created


Don't Miss Scheduled Meter Readings, Zero Usage and Overdue Queries - Tips on setting up Alerts *NEW*

recorded June 2023

  • How to use EI to create Alerts
  • How to create Broadcasts for Reports with Mandatory Filters
  • How to change the Date Filter to enable Broadcasts every month


Emission Factor Reporting Period Config & Adding Commodities in Bulk (Releae12.28)

recorded July 2021

  • How to change the Emission Reporting Period 
  • How to add Commodities in Bulk

Energy Intelligence Reporting

recorded June 2020

  • Overview of what data goes into EI and EI itself
  • View the different types of reports, mark reports as favourites
  • How to export/schedule reports

EI Report Editing

recorded May 2021

  • How to amend existing Filters, adding additional Filters
  • How to hide columns, amend the column and Filter names
  • How to remove/replace graphs, add a logo and save the revised report

Energy Intelligence Features and New Targeting Reports 

recorded February 2023

  • Recap on options available for Best Available Reports
  • Sending Reports to Managers responsible for numerous Sites
  • New Targeting Reports
  • New Bill Reports

Energy Intelligence Report Editing

recorded July 2020

  • How to edit a report including renaming columns, changing widths and reordering, adding prefixes/suffixes, add totals, averages etc
  • How to amend filters including adding/amending, linking and moving the location of a filter
  • How to add a logo to a Report

Forecasting Consumption and Emissions Data

recorded May 2021

  • Understand the methodology of Forecasting consumption and emissions data
  • How to configure the Estimation Techniques and Forecasting 
  • Sample EI Reports and the Emissions Summary Dashboard

GHG Scope 3 Reporting (Release 12.24)

recorded March 2021

  • How to add new Commodities such as Waste, Transport, Business Travel etc
  • How to add Consumption Data Items

Kim's Top Ten Favourite Energy Intelligence Reports   

recorded January 2022

  • Checking the configuration of Energy Intelligence
  • Kim's Top Ten Reports in Energy Intelligence
  • EI Report Directory updates

Refreshing EI Data and Emissions Dashboard (Release 12.23)

recorded February 2021

  • How to refresh EI data
  • How to personalise the preferences of data sources
  • View the Emissions Dashboard and view the Reports Directory

Reporting on Half Hourly Data

recorded June 2020 

  • View a selection of HH reports in both Sigma Reporting and Energy Intelligence Reporting
  • How to view data using the Browsing Activity

Understand the source of the data used in your GHG Reporting 

recorded November 2021

  • View the Emission Reporting configuration including how to refresh the data, change the hierarchy of the data sources, set estimation techniques and forecasting options
  • View 2 useful reports in Energy Intelligence

Understanding and Running a Report in Energy Intelligence   

recorded October 2021

  • Understand  the layout of Sigma include the folders, how to search for reports
  • Understand the Best Available View
  • How to open a report, filtering options, exporting, right click options and closing a report
  • How to add reports to the Favourites folder, refresh the data and view the Energy Intelligence Report Directory





Editing /Adding Items and Data


Adding Additional data to Sites for Benchmark Reporting

recorded August 2020

  • How to add Floor Area, Population etc manually, using the Wizard or in bulk

Adding Asset Types for commodities (Release 12.21)

recorded November 2020

  • How to add Assets such as Solar Generation, EV Charging etc to Meters, Accounts etc
  • How to view and assign Meter Relationships
  • How to create Accounts, Meters, Supply Points etc


Adding Bespoke Emission Factors and New Password Security (Release 12.25)

recorded March 2020

  • How to add your own Emission Factors manually or in bulk
  • Details of Password criteria

Creating Multiple GHG Categories (Release 12.29)

recorded August 2021 

  • How to update existing commodities, create new commodities with primary and secondary GHG 

Editing Data in Bulk

recorded May 2020

  • How to export Sites, Meters, Accounts etc in bulk
  • How to update data in bulk, report on the data, change Contracts and Account Numbers in bulk

Estate Setup and Maintenance

recorded May 2020 

  • How to set up a Site, Supply Point, Account, Meter and Channel using the Wizard and individually
  • How to change Account Numbers and Meters and how to close Sites






Tenant Billing


Recharging your Tenants using Sigma

recorded July 2020

  • How to produce bills for tenants
  • How to view the additional elements required for recharging, such as Tenant Accounts, Tariffs, Cost Definitions etc
  • How to manage a change of tenancy





@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018